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:
1 | 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:
123
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:
1
RMAN> catalog start
with
'/DR-RBKP/Friday/oldarchive'
Amen Answered question 16/11/2022