ON CALL DBA SUPPORT

— Database blog

RMAN-06059: expected archived log not found

Posted by ssgottik on 17/06/2011

RMAN-06059: expected archived log not found while taking archive log backup

 RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 06/16/2011 06:02:47

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file /arch/db/dwprod/arch_ORCL_533835433_1_145891.arc

ORA-27037: unable to obtain file status

HPUX-ia64 Error: 2: No such file or directory

Additional information: 3

The possible reason for the above error is that recovery catalog may be out of synch or that particular archivelog got deleted.

How to overcome this?

CASE1: If the recovery catalog is out of synch:

ORCL: oracle] $rman target sys/***** catalog rman/******@RCCATALOG

Recovery Manager: Release 11.2.0.2.0 – Production on Thu Jun 16 13:19:23 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to target database: ORCL (DBID=3983796265)

Connected to recovery catalog database

RMAN>SQL “ALTER SYSTEM ARCHIVE LOG CURRENT”;

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

RMAN>RESYNC CATALOG;

starting full resync of recovery catalog

full resync complete

CASE2: IF THE ARCHIVE LOG IS DELETED:

ORCL:oracle]$rman target sys/***** catalog rman/******@RCCATALOG

RMAN>crosscheck copy of archivelog all;

Once the crosscheck command is executed successfully, we have to take the full backup of the database.

Thanks and Regards,

Satish.G.S

 

 

Advertisements

3 Responses to “RMAN-06059: expected archived log not found”

  1. Bhavani said

    Can we take backup database plus archivelog now….

    • ssgottik said

      No you cannt, you have to do CROSSCHECK ARCHIVELOG ALL (if the archive log is really missing).

      If the archive is still present and still you are getting this error , than you have to resynch the catalog.

      Thanks,
      Satish.G.S

  2. gowri shankar. said

    very useful..RMAN>crosscheck copy of archivelog all;

    solved our issue. thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: