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

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Mon, 13 Dec 2004 15:54:12 -0600
Message-ID: <FCC960FDB92F5E469A02464FF72872F403170D57@pscdalpexch50.perotsystems.net>

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_at_gmail.com]=20 Sent: Monday, December 13, 2004 3:50 PM
To: Hollis, Les
Cc: jhenslee_at_wausauwindow.com; carmen.rusu_at_rrc.state.tx.us; oracle-l_at_freelists.org
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_at_ps.net> 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_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?
>=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_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?

>=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

Received on Mon Dec 13 2004 - 15:49:43 CST