Oracle Error RMAN-06118: a backup control file older than SCN string must be used for this recovery

Oracle Error Message

RMAN-06118: a backup control file older than SCN string must be used for this recovery

Reason for the Error

An attempt was made to recover the database, but some files had no backup, and were not present in the control file at the beginning of the restore. This happens when the control file used during the recovery is a backup control file taken before the creation of some of the files that had no backup. In this situation, the control file that is used must be taken before the creation of all files that have no backup. This will enable RMAN to automatically re-create all of the files that had no backup.

Solution

Restore a control file that was backed up before the specified system change number (SCN). The following RMAN commands can be used to do this: SET UNTIL SCN ; (where is the SCN displayed in the message) RESTORE CONTROLFILE;