Tag Archives: ORA-06059

RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

While running the backup through RMAN prompt it will generate the following error.

RMAN-06059: expected archive log not found.

Solution:
1. You need to check the location of archive log that archive is present or someone remove or move it to another location.

2. If someone move to other location then move it back to archive location and run the backup again.

3. If archive is not available, then to get ride of this error, you need to run Crosscheck your archive logs from RMAN prompt for mark them as expired in rman catalog.
RMAN> crosscheck archivelog all;
Crosscheck command marked archived log as expired which is not find in physical location.

4. For delete the expired archivelog run the following command:
RMAN> DELETE EXPIRED ARCHIVELOG ALL;

Advertisements