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..?
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..?
you can recover it using the target database control file.
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';