DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN Catalog Recovery

  1. #1
    Join Date
    Jan 2004
    Paris, France

    RMAN Catalog Recovery


    Talking with a friend of mine with some knowledge in Oracle, I have been
    quite surprise to learn that it is possible from Oracle9i to recover the
    RMAN catalog even if it lost completely (DRP).

    He told me that with the autobackup controlfile, I may be able to recreate
    the catalog as I can ask rman to recover from the autobackup control file
    and spfile, all the registered database and to recover as well my backup et
    backupset information.

    So the process looks like this :
    1. Recreate RMAN database or tbs
    2. Recreate RMAN Catalog Owner
    3. Connect to RMAN and create the catalog
    4. Recreate all information of the catalog from autobackup control file.

    Does anybody knows a link that explain that ?


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain

    The purpose of the control file autobackup is to provide a way to restore the backup repository contained in the control file when the control file is lost and the recovery catalog is either lost or was never used. You do not need a recovery catalog or target control file to restore the control file autobackup.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width