RMAN-06024: no backup or copy of the control file found to restore with RMAN-6026 RMAN-6024 no backup of controlfile

Hi,

Sometimes You can get “RMAN-06024: no backup or copy of the control file found to restore ” error.

 

Details of error are as follows.

RMAN-06024: no backup or copy of the control file found to restore
Cause: A control file restore could not proceed because no backup or copy of the control file was found.
It may be the case that a backup or copy of this file exists but does not satisfy the criteria
specified in the user's restore operands.



Action: None - this is an informational message. See message 6026 for further details.


RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

 

This error is related with the SCN of the highest backed up archived redolog and will try to find a backup of the controlfile.

You can resolve this by making another archivelog backup of the target database.

RMAN> backup archivelog all;

and than restart the duplicate afterwards, then the database duplicated successfully.

 

Or you can solve this error by using catalog backuppiece command as follows.

 

RMAN> catalog backuppiece '/rman/backup/c-4673639742-20200130-01.ctl';

cataloged backup piece
backup piece handle=/rman/backup/c-4673639742-20200130-01.ctl RECID=37 STAMP=897176040

 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/