Page Comparison

A full restore is only something being done after all other options has been exhausted, because there will be loss of data.

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 logfile, in the section above, the name of the backup file holding the CONTROLFILE is found.

On the line below the file name is the SCN (System Change Number). In this example a bit covered but readable as 10825040664713.

Restore SPFILE from backup

...

RMAN> set dbid=20141184369;
RMAN> startup mount;
RMAN> catalog start with '/opt/oracle/backup/CDRATOR/' noprompt;

Start the restore/recover operation

RMAN> configure device type disk parallelism 8;
RMAN> run {
2> set until SCN 10825040664713;
3> restore database;
4> recover database;
5> }

And now there is time for one or more cups of coffee  !!!!

Open up the database

...

If the

...

restore and recover completed without any warnings and errors, you can open the database.

RMAN> recover database;
RMAN> alter database open resetlog;