Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In the logfile, in the section above, the name of the backup file holding the CONTROLFILE is found.

Restore SPFILE from backup

The following commands shall be executed:

Code Block
SH> export ORACLE_SID=CDRATOR
SH> cd $ORACLE_BASE/backup/$ORACLE_SID
SH> rman target /
RMAN> set dbid=20141184369;
RMAN> startup nomount force;
RMAN> restore spfile from '/opt/oracle/backup/CDRATOR/20170328-ARCH-l4s08qf6_1_1';

Restore Controlfile from backup

Code Block
RMAN> startup nomount force;
RMAN> restore controlfile from '/opt/oracle/backup/CDRATOR/20170328-ARCH-l3s08qf2_1_1';

Catalog the backup files

Code Block
RMAN> startup mount force;
RMAN> catalog start with '/opt/oracle/backup/CDRATOR/2017' noprompt;

...