RE: rman: how do you backup the recovery catalog database?
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: <Les.Hollis@xxxxxx>, <jhenslee@xxxxxxxxxxxxxxxx>, <carmen.rusu@xxxxxxxxxxxxxxx>
- Date: Mon, 13 Dec 2004 17:03:29 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hollis, Les
Sent: Monday, December 13, 2004 3:57 PM
To: jhenslee@xxxxxxxxxxxxxxxx; carmen.rusu@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Henslee, Jeff
Sent: Monday, December 13, 2004 2:53 PM
To: carmen.rusu@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx]
Sent: Monday, December 13, 2004 2:53 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
