Starting point
The starting point is that the entire database is either deleted or corrupted, but the basic directory structure is in place:
...
In the directory backup/logs you can find the log from the last backup:
Find DBID of database
From that logfile, you can find the start of the last backup, where you can find the DBID of the database.
...
In this case the ORACLE_SID is CDRATOR and the DBID is 20141184369.
Find SPFILE backup
In the logfile, at the very end, the name of backup file holding the SPFILE is found.
Find Controlfile backup
In the logfile, in the section above, the name of the backup file holding the CONTROLFILE is found.
...
| Code Block |
|---|
RMAN> startup mount force; RMAN> catalog start with '/opt/oracle/backup/CDRATOR/2017' noprompt; |
Start the restore operation
| Code Block |
|---|
RMAN> configure device type disk parallelism 6; RMAN> restore database; |
...