RE: Backing up the recovery catalog
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Jun 2006 08:21:37 +0100
Both, export and RMAN backup. We do not use a recovery catalog for the
catalog backup though, just the controlfile method.
Just talking about it with someone else though and I think we might move
to setting up another catalog and using that for the 3 RMAN repositories
we have (dev, prod and 10G).
We also have multiple schemas in each catalog and just create a new
schema rather than housekeeping old entries off. We find that much more
efficient than trying to purge old entries when the catalogs are very
busy most of the time.
John
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: 26 June 2006 18:02
To: oracle-l@xxxxxxxxxxxxx
Subject: Backing up the recovery catalog
Hello everyone,
I'm curious how you all are going about backing up your recovery
catalogs. Do you do it through rman backups, or logical exports, or
both? I've always done it through logical exports (exp), then
compressed and backed up to tape through Netbackup with bpbackup - all
scripted to run very smoothly and automatically after each database
backup and archive log backup. This has served me well in the past, but
now I'm setting up a new server and was just reviewing this
configuration and the documentation that recommends backing up the
recovery catalog via rman instead, so I'm considering changing my ways
but not sure if that's a good idea. Just curious what others are doing
and if you have any compelling reasons for doing it one way or the
other.
Thanks,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.
Other related posts:
