RE: Backing up RMAN catalog database

We use the RMAN daily export method ... set up by a contractor a couple
years earlier.  But this database is not in archive log mode.  Should it
be?  My thinking is yes, because otherwise rman backups (eg. archived
log files) since the last export of the recovery catalog may not be
recoverable by RMAN.

Thanks,

Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: February 7, 2007 10:25 AM
To: fred_fred_1@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Backing up RMAN catalog database

Fred,

The traditional (Oracle suggested) way is to have a second Rman catalog
on a different database server.  This catalog is used by the first Rman
database.

Another way is to simply export the Rman catalog when no backups are
running and save the export file someplace safe.

Either way works as long as it is documented.

Tom


 

--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity
to whom it is addressed.  If you are not the intended recipient, you are
hereby notified that any disclosure, dissemination, copying or
distribution of this transmission or its attachments is strictly
prohibited.  In addition, unauthorized access to this transmission may
violate federal or State law, including the Electronic Communications
Privacy Act of 1985.  If you have received this transmission in error,
please notify the sender immediately by return e-mail and delete the
transmission and its attachments.


-----Original Message-----

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith
Sent: Wednesday, February 07, 2007 10:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Backing up RMAN catalog database

Hello

I am curious how those of you that use an RMAN catalog go about backing
it 
up.

I'm running Netbackup 5.1MP7 and backup 5 databases to a master server.
My 
rman catalog database is on a separate server. Do you backup the catalog

database to the same master server?
Do you simply connect with the target being the rman catalog (and no 
connection to a catalog database)?

Are there any issues with backing up the catalog database to the same
master 
server?

Thanks!

_________________________________________________________________
FREE online classifieds from Windows Live Expo - buy and sell with
people 
you know 
http://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http:/
/expo.live.com?s_cid=Hotmail_tagline_12/06

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: