ON CALL DBA SUPPORT

— Database blog

Archive for June, 2011

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

 

 

Posted in RMAN | 3 Comments »