Re: RMAN question about losing Catalog repository
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx, "ChrisDavid.Taylor@xxxxxxxxxxxxxxx" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jan 2010 19:14:38 -0800 (PST)
On caveat here is if the backup you want to restore is > 365 days old there
will not be a control file record. If the backup you want to restore was
created > control_file_record_keep_time then the control file records might
well be gone. Those with legal requirements to maintain long term backups need
to be aware of this and make sure the recovery catalog is backed up.
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
________________________________
From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: "ChrisDavid.Taylor@xxxxxxxxxxxxxxx" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>;
Oracle L <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, January 27, 2010 1:32:29 PM
Subject: RE: RMAN question about losing Catalog repository
I think you may have your terms mixed up. Yes, you have to have the
repository, but the repository is always in the controlfile, and may optionally
be stored in a recovery catalog as well. You don’t need the catalog in order
to restore, you only need the repository, and the one in your controlfile
should be sufficient unless you need to do a point-in-time restore to a backup
that is no longer present in your controlfile.
Reference:
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmarchi.htm#BRADV103
Regards,
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:
