Home > Administration with ASM > Procedure to Fix ASM Disk Full caused by number of archived logs

Procedure to Fix ASM Disk Full caused by number of archived logs

– Suppose the ASM diskgroup and database are SG_DG and sgcmsqa respectively

1. Start ASMCMD

export ORACLE_SID=+ASM1;export ORACLE
asmcmd

2. Change to ARCHIVELOG ( suppose the ASM diskgroup and database are SG_DG and sgcmsqa respectively)

ASMCMD> cd +SG_DG/SGCMSQA/ARCHIVELOG

ASMCMD> ls -la
Type  Redund  Striped  Time             Sys  Name
Y    2010_01_30/
Y    2010_01_31/
Y    2010_02_01/

3. Delete archived logs under 2010_01_30/

ASMCMD> cd 2010_01_30/
ASMCMD> rm *
You may delete multiple files and/or directories.
Are you sure? (y/n) y

ASMCMD> pwd
+SG_DG/SGCMSQA/ARCHIVELOG/2010_01_30
ASMCMD> ls
ASMCMD-08002: entry ‘2010_01_30’ does not exist in directory ‘+SG_DG/SGCMSQA/ARCHIVELOG/’

ASMCMD> cd +SG_DG/SGCMSQA/ARCHIVELOG
ASMCMD> ls
2010_01_31/
2010_02_01/

4. Perform archived log crsscheck by RMAN, otherwise the next RMAN backup fails with following errors

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 10:41:43
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +SG_DG/sgcmsqa/archivelog/2010_01_30/thread_1_seq_9177.5387.709605763
ORA-17503: ksfdopn:2 Failed to open file +SG_DG/sgcmsqa/archivelog/2010_01_30/thread_1_seq_9177.5387.709605763
ORA-15012: ASM file ‘+SG_DG/sgcmsqa/archivelog/2010_01_30/thread_1_seq_9177.5387.709605763′ does not exist

$ ORACLE_SID=sgcmsqa1;export ORACLE_SID
$ rman target /

Recovery Manager: Release 11.1.0.7.0 – Production on Mon Feb 1 10:46:41 2010
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: SGCMSQA (DBID=2240214422)
RMAN> change archivelog all crosscheck;

5. Perform a full database up immediately

RMAN> run{
2> allocate channel ch1 type disk;
3> sql ‘alter system archive log current’;
4> backup
5> format ‘/bkuppool/oracle/bkup/databases/sgcmsqa/bkup_%d_%s_%p_%t.dat’
6> database plus archivelog;
7> delete obsolete;
8> }
9>



Advertisements
  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: