DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002

    How to recover the database where the recovery catalog is there in case of crash.?


    A database named "A" keeps all the recovery catalog information of all other databases.

    Now question is incase the database "A" crashes, how to recover it..?

  2. #2
    Join Date
    Aug 2007
    Cyberjaya,kuala lumpur
    you can recover it using the target database control file.

  3. #3
    Join Date
    Nov 2000
    Pittsburgh, PA
    Your best bet is to use autobackup of the control file as well as snapshot. You need to make sure that the control file is the last thing that gets backed up. Then once you restore the latest control file backup, you can do a startup mount. Then your database has all of the information that it needs for you to do a "restore database;" followed by a "recover database;" you then simply do an "open database reset logs;" followed by a new backup, I would assume.

    configure Controlfile autobackup format for device type disk to 
    '${BACKUPDIR}/${ORACLE_SID}_`/bin/date +%Y%m%d_%H%M%S`_%F.ctl';
    configure snapshot controlfile name to
     '${BACKUPDIR}/${ORACLE_SID}_`/bin/date +%Y%m%d_%H%M%S`_snapshot.ctl';
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.