RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN-20242: specification does not match any archive log in the recovery catalog

This error caused due to mismatch in RMAN catalog information and physical disk files.

For verify, run the following command and verify it with physical disk archive present:

rman> list archivelog all;

Error occurred when we try to find the archive present on catalog but not on disk.

Reason:
1.May someone move to another location for empty the space at archive destination

RMAN> backup archivelog sequence between 1000 and 1500 thread N delete input;

Note: You can take backup with this command by specify the sequence so space is free from disk and then move the archive backup to location then backup again of specific archivelog.

2. Archive log has been deleted from location.
In this case you need to run the following command to sync the catalog with present archivelog at physical disk:

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

Note: In this case you need to take hot backup immediate, for complete recovery purpose otherwise you are not able to do complete recovery with old backups.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.