RE: rman: how do you backup the recovery catalog database?

 We export the catalog schema to a file and backup to tape...for the reason that if the server blew up we could import that schema in any other database and be up and running. Our scripts are set so that if the catalog blows up ( then we automatically switch to nocatalog.. To ensure backups keep rolling.) We set the control_file_record_keep_time parameter to 30 to enable to recovery up to 30 days back...well past 99.99999 percent we would need and our SLA's.

Cheers,
Brian

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hollis, Les
Sent: Monday, December 13, 2004 3:57 PM
To: jhenslee_at_wausauwindow.com; carmen.rusu_at_rrc.state.tx.us Cc: oracle-l_at_freelists.org
Subject: RE: rman: how do you backup the recovery catalog database?

We have a scheduled (by cron) shutdown/coldbackup/startup daily @ 3:00 PM when no DB backups are running....and the backup is system copied to tape daily ....

With that and archive logs, we feel comfortably sure we could restore it and our production databases with it.

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Henslee, Jeff
Sent: Monday, December 13, 2004 2:53 PM
To: carmen.rusu_at_rrc.state.tx.us
Cc: oracle-l_at_freelists.org
Subject: RE: rman: how do you backup the recovery catalog database?

I (personally) take exports of my recovery catalog database after all = =3D backups are complete and include them in my Unix File System Backups. I =3D also compress the export dumps and copy them to servers across town for =3D DR purposes.

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

From: Carmen Rusu [mailto:carmen.rusu_at_rrc.state.tx.us] Sent: Monday, December 13, 2004 2:53 PM
To: oracle-l_at_freelists.org
Subject: rman: how do you backup the recovery catalog database?

Which is a better method to backup the recovery catalog?=3D20

By logical or physical backup?

Horror stories? Good ones?

rcat db 10.2.0.3
os Linux SUSE 8

target dbs 9.2.0.4 and 8.1.7.4
os: SunOS 2.8

Thanks,
Carmen Rusu
DBA
--

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

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

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 13 2004 - 15:59:33 CST