Re: RMAN Catalog
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 10 Apr 2009 11:27:45 -0700 (PDT)
In a worse case situation if you have the backup set pieces, you can always use
PL/SQL to restore RMAN backups without a RC or a control file. I just had to do
this a couple of months ago for a client who was running Oracle 8 (!i)! It's a
painful process, but it works.
Some MML/SBT tape software makes it *very* difficult to get backup set pieces
off of the backup media manually too. Sometimes a quick call to
dbms_backup_restore does the trick. (ok... the call isn't that quick, but it's
not to complex).
Cheers!
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
________________________________
From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: "Richard.Goulet@xxxxxxxxxxx" <Richard.Goulet@xxxxxxxxxxx>;
"JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>; oracle-l-freelists
<oracle-l@xxxxxxxxxxxxx>; oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
Sent: Friday, April 10, 2009 9:25:45 AM
Subject: RE: RMAN Catalog
You should be able to restore 7yr old backups w/o a recovery catalog as well –
just as long as you have old backups of your controlfile set with proper
retention.
Regards,
Brandon
From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Goulet, Richard
if you need to be able to restore a database to any point in time in the last 7
years the recovery catalog is priceless.
________________________________
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:
