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 <arupnanda_at_hotmail.com> 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: Jared.Still_at_radisys.com
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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_at_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: <F001.0052BE7E.20030109151943_at_fatcity.com>
> >X-Comment: Oracle RDBMS Community Forum
> >X-Sender: Jared.Still_at_radisys.com
> >Sender: root_at_fatcity.com
> >Errors-To: ML-ERRORS_at_fatcity.com
> >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: root_at_fatcity.cts.com
> >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" <arupnanda_at_hotmail.com>
> >Sent by: root_at_fatcity.com
> > 01/09/2003 01:09 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> > 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" <ORACLE-L_at_fatcity.com>
> >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" <rgramolini_at_tax.state.vt.us>
> > > Sent by: root_at_fatcity.com
> > > 01/09/2003 11:04 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> > > 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" <ORACLE-L_at_fatcity.com>
> > > 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
> > > ineyman_at_perceptron.com
> > >
> > >
> > >
> > > ----- 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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Jan 10 2003 - 05:04:20 CST