Home > TroubleShooting > RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

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

Symptoms

Starting backup at 01-FEB-10
current log archived
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 02/01/2010 09:45:23
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +SG_DG/sgptqa/archivelog/2010_01_31/thread_1_seq_8972.6485.709712185
ORA-17503: ksfdopn:2 Failed to open file +SG_DG/sgptqa/archivelog/2010_01_31/thread_1_seq_8972.6485.709712185
ORA-15012: ASM file ‘+SG_DG/sgptqa/archivelog/2010_01_31/thread_1_seq_8972.6485.709712185’ does not exist

Fixed

1. Perform a crosscheck, run the following command from within RMAN:

RMAN> change archivelog all crosscheck;

2. Perform a full backup of the database at this point.

RMAN> run{
2> allocate channel ch1 type disk;
3> sql ‘alter system archive log current’;
4> backup
5> format ‘/bkuppool/oracle/bkup/databases/sgptqa/bkup_%d_%s_%p_%t.dat’
6> database plus archivelog;
7> delete obsolete;
8> }
9>
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=257 instance=sgptqa1 device type=DISK

sql statement: alter system archive log current

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

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: