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
> Sent: Thursday, January 09, 2003 1:18 PM
> Subject: RE: RE : RMAN Repository
>
>
> Yeah but do you have to pay for another Veritas NetBackup license and
> server to backup the catalog? If just have one database server and one
> database license why should I have to buy another license and install
> another 1-2GB of Oracle software on another server? The only answer I
can
> think of is so Larry can spend more money on yachts, planes, and cars.
>
> Contrary to Oracle Corporate aspirations, not all data in the universe
> really needs to be stored in Oracle databases, especially backup
> information
> about Oracle databases I want to backup. 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? ;-) Seems the simple solution to this
silliness
> is
> just to remove the requirement of having a database to backup a
database.
>
>
>
> Steve Orr
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 10:50 AM
> To: [EMAIL PROTECTED]
> Cc: Orr, Steve
> Subject: RE: RE : RMAN Repository
> Importance: High
>
>
>
> > The overhead of the repository database is more. With the initial
> releases of RMAN (EBU) Oracle was rightly
> > criticized for the fact that you had to backup the database that
holds
> information about the database you want to backup.
> > Getting rid of this silliness seems reasonable to me.
>
> Why silly?
>
> It isn't any more silly than making a separate backup of the Veritas
> Netbackup catalog.
>
> It's just a different level of abstraction.
>
> Jared
>
>
>
> "Orr, Steve" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 01/09/2003 08:45 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject: RE: RE : RMAN Repository
>
>
>
> If you aren't using a repository all you have to do is make sure
control
> file backups are part of the routine. There are 2 ways to backup the
> backup metadata: 1) the RMAN repository database; 2) backup
> controlfiles.
> Functionally and operationally they're pretty much the same. The only
> things you can't do with controlfile RMAN/database metadata is: 1) use
> previous "incarnations" of the database for recovery; 2) use database
> stored scripts. No big deal as far as I'm concerned.
> When RMAN first came out a separate repository database was a
> requirement.
> Subsequent releases added some functionality for using controlfiles.
The
> vulnerability of losing the repository or losing the backup
controlfile
> is
> about equivalent. The overhead of the repository database is more.
With
> the initial releases of RMAN (EBU) Oracle was rightly criticized for
the
> fact that you had to backup the database that holds information about
> the
> database you want to backup. Getting rid of this silliness seems
> reasonable to me.
>
> Steve Orr-man for RMAN,
> Bozeman, Montana
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 08, 2003 2:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE : RMAN Repository
> Importance: High
>
> And how does one go about restoring a database when all control files
> are lost, and the only recovery data is stored in the control file?
> This doesn't sound very reasonable.
> Jared
>
> "Deshpande, Kirti" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject: RE : RMAN Repository
> Joe,
> That's what I have heard (from 2 Oracle University
> Professors/Lecturers/Demonstrators). But no one would tell me when it
> may
> happen. We do not use RMAN (yet) so I did not pursue it further.
> - Kirti
> -----Original Message-----
> Sent: Wednesday, January 08, 2003 1:08 PM
> To: Multiple recipients of list ORACLE-L
> <snip>
> Obilgatory oracle statement/question: rumor has it by some
instructors
> that RMAN repository is going away and only control file recoveries
> will be possible, truth or fiction?
> joe
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
> 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).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
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).
