Site icon IT Tutorial

RMAN-20506: no backup of archived log found

Hi,

Sometimes You can get “RMAN-20506: no backup of archived log found ” error.

 

Details of error are as follows.

RMAN-20506: no backup of archived log found
Cause: during the recover process, no backup was found from which the archived logs could be restored.
Action: this message should be followed by a list of missing archived logs. Please make the necessary archived log backups available and try again.
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log

This error is related with the insufficient backup to complete the duplicate command, because it is an old backup.
more log files are needed to complete.

To solve this problem, you should use the until clause in RMAN script, if there is no sufficient backup available.


RMAN> 
RUN
 {
 SET UNTIL SEQUENCE 1453 THREAD 1;   --recovers upto available log sequence 1453
 DUPLICATE TARGET DATABASE TO "MSDBCLN" NOFILENAMECHECK;
 }

 

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/

 

Exit mobile version