[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

Title:	Oracle
Notice:	For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010
Moderator:	EPS::VANDENHEUVEL

Created:	Fri Aug 10 1990
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1574
Total number of notes:	4428

1539.0. "Backup of DRD devices in TruCluster and OPS" by GUIDUK::SOMER (Turgan Somer - SEO06 - DTN 548-6439) Tue Apr 01 1997 19:34

    
    We are struggling with how to backup DRD devices on a TruCluster
    OPS configuration. The scheme we came up with so far is:
    
    1) "dd" Oracle file on the DRD devices to an ADVFS file
    
    2) use vdump to backup the ADVFS file.
    
    and use the reverse procedure for restores.
    
    Any comments and suggestions please?
    
    
    P.S. The above process does not seem to work: Oracle does not like the 
         files that we restore with vrestore and "dd" combination for some 
         reason but in theory, it should work fine , right?

T.R	Title	User	Personal Name	Date	Lines
1539.1	Possibility.... ???	CICS03::helen	Helen Pratt	`Wed Apr 02 1997 09:19`	13
	Just a thought and I haven't tried this so.... Have you taken into account that Oracle doesn't write to the first 64k of a file? The person at Oracle I spoke to said they;d had sucess using a seek of 128, assuming the default 512 block size. Hope it helps, Helen.
1539.2	Yes, Oracle says it's a DRD issue	GUIDUK::SOMER	Turgan Somer - SEO06 - DTN 548-6439	`Wed Apr 02 1997 17:15`	8
	Funny, you should mention this. We just found out from Oracle that we have to use "dd ..skip=64k..." But, according to Oracle it's Digital drd peculiarity, not an Oracle issue.
1539.3	Enterprise Backup ?	WOTVAX::GALLACHERM		`Thu Apr 03 1997 10:17`	7
	Oracle Enterprise backup (obackup) is a lot easier to use than dd. Cost may be an issue but I know of at least two TruCluster customers using it in the UK without problems. Mark -//-
1539.4	EBU + DMO +NSR ??????	ZPOVC::CSNAQS		`Fri Apr 04 1997 02:49`	11
	Hi, I thought EBU does not know how to backup OPS now, and there is no way to use DMO & NSR to do an online OPS backup. Oracle was telling me that if you want to use EBU, you must shutdown the other instances first. So, I am very curious as how the 2 Trucluster customers in UK do their backups. Regards.
1539.5	exclusive !	WOTVAX::GALLACHERM		`Mon Apr 07 1997 06:53`	6
	Correct - they shut down to one instance (exclusive) before backup. Mark -//-
1539.6		COMICS::CORNEJ	What's an Architect?	`Wed Apr 16 1997 11:25`	10
	I'm on a customer site right now (Hi mark - your name is in their docs:-) The Oracle consultant here has recomended against the oracle tools and to stick with dd for the raw partitions. Is there an "official" Oracle statement on this? Jc
1539.7		VAXRIO::LEO		`Wed Apr 16 1997 18:15`	19
	Hi Jc, It's really amazing because I have an Oracle consultant down here Brazil saying exactly the opposite. We are selling a NSR + DMO + EBU solution to an OPS/TCR Production Server environment based on that. I think that database aware backup would be always better (more secure) and easier to implement. Jc, Have the Oracle consultant explained to you the reasons he not recomends this kind of backup solution ? Anyone could help us in order to have an official position from Oracle? Leo Digital Technical Support
1539.8		COMICS::CORNEJ	What's an Architect?	`Thu May 01 1997 04:27`	11
	(sorry for the delay - I don't read this conference too often) The Oracle guy here said that the tools are not yet robust enough for him to recommend then into a 24x7 operation. Turns out that this site will not go OPS yet, so there is no issue here today. Jc