• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

June 26, 2020 by techgoeasy Leave a Comment

Sometimes our RMAN archive log backups hit with 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 option 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 it.

When the missing archive can be ignored or not needed

If the archive log is not needed, we can delete it from 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/[email protected]
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 with out any issues.

I hope you like this article on RMAN-06059 and it helps in resolving the issue. Please do provide me 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 performs in the background
oracle recovery manager :Recovery Manager(RMAN) is a backup and recovery utility provided by Oracle. it comes with database installation and make the jobs easy for DBA’s
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 ,shutdown using alert log
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmarchi.htm

Filed Under: Oracle, Oracle Database Tagged With: archivelog, RMAN

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us