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

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

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Posts
    205

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

    Hi,


    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
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    you can recover it using the target database control file.
    Thanks/Gopu

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

    Code:
    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';

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