way back when, I wrote my own set of scripts to handle backups. As each datafile was backed up, I wrote the full path name to a text file. At the end of the backup the text file was written to tape as well.
As I did restores, I read the text file. then I used that file to let me know which file I was reading from the tape and where to put it. I wrote another text file while I was doing the restore, as each file was successfully read and written to disk. This allowed me to restart the restore from where I had stopped, instead of from the beginning again. Admittedly, this was for cold backups of the Oracle database, but I can't see why RMAN couldn't have as easily done the same thing for hot backups. --- Arup Nanda <[EMAIL PROTECTED]> wrote: > Huh!!! > > <Quote> > If the backup was made while the repository was in use for > other backups, it may be in a logically inconsistent state from > the RMAN perspective. > </Quote> > > That sent a shiver through the spine, Jared. I admit, I never tested > the > recovery of the RMAN repository and never (shame on me!) considered > the > effect of incomplete recovery of the catalog. > > Others, any ideas? specifically the effect of losing the catalog > database > and recreating it from a hot backup? Robert Freeman, perhaps? > > This is another reason why I dislike the idea of a database to store > the > recovery catalog. Granted, the catalog needs to stored somewhere and > it > happens to be in (surprise! surprise!!) an Oracle database; but it's > more > akin to driving a leather interior tank to work everyday. It could > have been > plain and simple like a text file. A sql based interface would not > have been > possible; but then again is it there, really? The RMAN scripts could > have > been adapted to query and manipulate the ascii text file. Just my > thoughts! > > Arup > > > > > > > >From: [EMAIL PROTECTED] > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: RE : RMAN Repository > >Date: Thu, 09 Jan 2003 15:19:43 -0800 > >MIME-Version: 1.0 > >Received: from newsfeed.cts.com ([209.68.248.164]) by > >mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); > Thu, 9 Jan > >2003 16:23:24 -0800 > >Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com > >(8.9.3/8.9.3) with UUCP id QAA72977;Thu, 9 Jan 2003 16:19:12 -0800 > (PST) > >Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id > 0052BE7E; > >Thu, 09 Jan 2003 15:19:43 -0800 > >Message-ID: <[EMAIL PROTECTED]> > >X-Comment: Oracle RDBMS Community Forum > >X-Sender: [EMAIL PROTECTED] > >Sender: [EMAIL PROTECTED] > >Errors-To: [EMAIL PROTECTED] > >Organization: Fat City Network Services, San Diego, California > >X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. > Bergman > >Precedence: bulk > >Return-Path: [EMAIL PROTECTED] > >X-OriginalArrivalTime: 10 Jan 2003 00:23:24.0598 (UTC) > >FILETIME=[7D17A560:01C2B83E] > > > >Hot backup of the repository is fine as long as you can be > >assured that all files needed for a complete recovery are > >going to be available. > > > >Recover a hot backup of an RMAN repository to another > >server using imcomplete recovery, ( your RMAN server > >burned to a crisp, drives and all ), and you may or may not > >have a good repository. > > > >If the backup was made while the repository was in use for > >other backups, it may be in a logically inconsistent state from > >the RMAN perspective. > > > >Kind of like backing up OID. > > > >Could be that I'm wrong on this, but I don't have time to test > >it and come up with a definitive answer. > > > >Jared > > > > > > > > > > > >"Arup Nanda" <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > > 01/09/2003 01:09 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > > cc: > > Subject: Re: RE : RMAN Repository > > > > > >Jared, > > > >I do. Actually, I back up the "other" master in the multi-master > setup, in > >order to reduce load on the main database. But now that you have > asked the > >question, I am beginning to wonder why I ever thought of that. > Restoring > >will not restore the untransmitted transactions (it's asynch > replication); > >so I will lose data and at the same time a little load on the main > RMAN > >repository is not a bad idea either. Hmm...may be I'll switch to the > main > >database for hot backup. > > > >The reason for hot backup is quite simple - it's easy to throw in > another > >database into the hot backup system, rather than figure out a quiet > period > >for cold backup when no other databases are being backed up using > RMAN. > > > >HTH > > > >Arup > >----- Original Message ----- > >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > >Sent: Thursday, January 09, 2003 3:30 PM > > > > > > > I do a cold backup of my repository daily. > > > > > > Replication of it is not a bad idea, as Arup mentioned, > > > though I haven't tried it myself. > > > > > > Speaking of backing up the RMAN repository, does anyone > > > back them up hot? > > > > > > Seems to me that would not be a good idea. > > > > > > Jared > > > > > > > > > > > > > > > > > > > > > "Ruth Gramolini" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 01/09/2003 11:04 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > > > cc: > > > Subject: Re: RE : RMAN Repository > > > > > > > > > The earlly versions of rman suggested that you put a 2nd > recovery > >catalog > > > in one of the databases you are using the "real" recovery catalog > for. > > > Then > > > you use this to record the backups of the recovery catalog > database. I > > > never headed this advice, altho I do use a recovery catalog for > all > > > production, developement, and test databases that I back up. > > > > > > Ruth > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Thursday, January 09, 2003 1:44 PM > > > > > > > > > RE: RE : RMAN Repository>If I need a database to backup a > database then > >do > > > I > > > need another database to backup the database that backed up the > original > > > database? > > > > > > Exactly my thoughts. > > > > > > Igor Neyman, OCP DBA > > > [EMAIL PROTECTED] > > > > > > > > > > > > ----- Original Message ----- > > > From: Orr, Steve > > > To: Multiple recipients of list ORACLE-L > === message truncated === __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
