What is the cause and solution for oracle error code RMAN-06059: expected archived log not found, loss of archived log?
Amen Answered question 16/11/2022
This error occurs when we try to backup using RMAN:
RMAN> backup database plus archivelog;
Cause: The archived logs are either deleted or moved another location on disk and the control file could not find the archived logs.
Solution: You must update RMAN’s repository to reflect that archived redo log files have been either
physically deleted or moved to another location on disk.
- If the the archived logs are removed from disk use the CROSSCHECK command to inform RMAN:
RMAN> crosscheck archivelog all; --Now the backup command and it will work. RMAN> backup database plus archivelog;
- If the archived logs are still on the disk but on different location use CATALOG command to update RMAN repository with the new location:
RMAN> catalog start with '/DR-RBKP/Friday/oldarchive'
Amen Answered question 16/11/2022