RE: Backing up the recovery catalog
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Oct 2006 16:11:32 -0700
I'm rehashing this old topic again since I got too busy to respond back
when I originally posted my question.
I'm curious if anyone can come up with a scenario where the lack of a
recovery catalog would prevent successful database recovery? Assuming
that you have controlfile backups, I can't think of such a case. I'm
leaning towards following the same path as Jared and phasing out the
recovery catalog since it just seems like an unnecessary level of
redundancy to me - especially with the added ease of controlfile
autobackups in 9i+.
It seems to me that the only benefits of the recovery catalog are that
it can hold more historical data (control file is limited to 365 days
and 20,000 blocks), and it can hold rman scripts. So, if either of
those two things are important to you, then it might make sense to have
a recovery catalog but other than that it just seems more and more like
a waste of resources to me.
Am I missing something?
Thanks,
Brandon
________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Monday, June 26, 2006 3:40 PM
To: Allen, Brandon
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Backing up the recovery catalog
I shutdown the recovery catalog database and backup it up cold.
Backing it up after every database backup seems like overkill to
me, as
any of the databases can be recovered using the controlfile.
As databases get moved and new ones added, I am not even using
the recovery catalog.
Though I have argued for its use in the past, I haven't actually
realized
much benefit from using it, and am phasing it out here.
Jared
On 6/26/06, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
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:
