RE: Backing up RMAN catalog database

From: Sam Bootsma <sbootsma_at_georgebrown.ca>
Date: Wed, 7 Feb 2007 11:21:37 -0500
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A11D43F2@TCCEML02.gbrownc.on.ca>

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_at_georgebrown.ca

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: February 7, 2007 10:25 AM
To: fred_fred_1_at_hotmail.com; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith Sent: Wednesday, February 07, 2007 10:20 AM To: oracle-l_at_freelists.org
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 Received on Wed Feb 07 2007 - 10:21:37 CST