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

Takes a little coordination as the backups of the databases actually
occur on 4 servers OTHER than the one where the repository
resides....the RMAN repository is also my Onames server database....




-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx]=20
Sent: Monday, December 13, 2004 3:50 PM
To: Hollis, Les
Cc: jhenslee@xxxxxxxxxxxxxxxx; carmen.rusu@xxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: rman: how do you backup the recovery catalog database?

We likewise do cold backups of the RMAN catalog.

There has been some discussion of possible logical corruption
of the catalog if it were backed up hot while the repository is in=20
use, similar to the reasons for doing cold backups  of OID.

I don't know if the arguments are valid, as it looks like testing
this would be a fairly involvded task.  It is easier to just do
cold backups on RMAN.

A check on MetaLink has not revealed any insight on this.  Perhaps I
just did not find the correct document.

Jared



On Mon, 13 Dec 2004 14:57:06 -0600, Hollis, Les <Les.Hollis@xxxxxx>
wrote:
> 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 ....
>=20
> With that and archive logs, we feel comfortably sure we could restore
it
> and our production databases with it.
>=20
> -----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?
>=20
> I (personally) take exports of my recovery catalog database after all
=3D
> =3D3D
> backups are complete and include them in my Unix File System Backups.
I
> =3D3D
> also compress the export dumps and copy them to servers across town
for
> =3D3D
> DR purposes.
>=20
> -----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?
>=20
> Which is a better method to backup the recovery catalog?=3D3D20
>=20
> By logical or physical backup?
>=20
> Horror stories? Good ones?
>=20
> rcat db 10.2.0.3
> os Linux SUSE 8
>=20
> target dbs 9.2.0.4 and 8.1.7.4
> os: SunOS 2.8
>=20
> 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
>=20


--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: