How to fix the Oracle error RMAN-06118: a backup control file older than SCN string must be used for this recovery?

In this post, you’ll learn more about the Oracle ErrorRMAN-06118: a backup control file older than SCN string must be used for this recovery with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error RMAN-06118: a backup control file older than SCN string must be used for this recovery ?

You can fix this error in Oracle by following the below steps

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;