Sometimes our RMAN archive log backups hit with the following RMAN-06059 error.
sent command to channel: Disk1 Starting backup at 26-JAN-2000 11:04:32 current log archived released channel: Disk1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 01/26/2010 11:05:30 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability ORA-19625: error identifying file /u01/ABCDPR/arch/ABCDPR_434345355_1_661.arc ORA-17503: ksfdopn:4 Failed to open file /u01/ABCDPR/arch/ABCDPR_434345355_1_661.arc ORA-17500: ODM err:File does not exist RMAN>
Solution
We have two options here
(a) When the missing archive is needed
(b) When the missing archive can be ignored or not needed
When the missing archive is needed
In case the missing archive is needed, we need to restore the archive from OS backup to the same location where the RMAN is looking for
or
We can restore it in any location and then catalog it using
catalog start with <location> Ex catalog start with "/tmp"
RMAN would read all the files in the location and catalog them.
When the missing archive can be ignored or not needed
If the archive log is not needed, we can delete it from the catalog and proceed with the backup
export ORACLE_SID=ABCDPR1 $rman target / Recovery Manager: Release 10.2.0.4.0 - Production on Tue Dec 6 11:36:11 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ABCDPR (DBID=76474531740) RMAN> connect rcvcat rman_username/password@TEST connected to recovery catalog database RMAN> crosscheck archivelog all; RMAN> Delete noprompt archivelog expired;
Then rerun the RMAN backup again and it should complete successfully without any issues.
I hope you like this article on RMAN-06059 and it helps in resolving the issue. Please do provide the feedback
Also Reads
how to find archive log sequence number in Oracle: check out How to find archive log history, how to find archive log sequence number in Oracle, how to check archive log mode in Oracle, archive log list
alter system switch logfile: Check out this post for alter system switch logfile, alter system archive log current command, how to use them and what all they perform in the background
Oracle Recovery Manager: Recovery Manager(RMAN) is a backup and recovery utility provided by Oracle. it comes with database installation and makes the jobs easy for DBAs
How to check alert log errors in oracle: check out this to find what is alert log, location of alert log and how to check alert log errors in oracle. How to find startup, and shutdown using the alert log
How to delete the archive logs in Oracle: Visit this page to find out How to delete the archive logs in Oracle after backup, how to delete the expired archive log
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmarchi.htm