Re: RMAN Catalog

From: Robert Freeman <>
Date: Fri, 10 Apr 2009 11:27:45 -0700 (PDT)
Message-ID: <>

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).



 Robert G. Freeman
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...
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" <>
To: "" <>; "" <>; oracle-l-freelists <>; oracle-db-l <>
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.
Brandon [] 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.
Received on Fri Apr 10 2009 - 13:27:45 CDT

Original text of this message