ASM Archive destination is full. [ID 351547.1]

rongshiyuan發表於2013-06-09
ASM Archive destination is full. [ID 351547.1]

In this Document
Symptoms
Cause
Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

1) Archive destination is full.

2) Archive files are being stored in ASM.


Cause

The ASM diskgroup is running out of space.

Solution

1) On the Regular database identify the archivelogs to be deleted and generated a SQL
dynamic script. with the alter diskgroup drop file '' command as
follow:
==================================================================
spool rmarchive_asm.sql
set linesize 300

select 'alter diskgroup DISK_GROUP1 drop file ' || '''' || name ||'''' || ';' from V$ARCHIVED_LOG;

spool off
==================================================================

2) Then execute the rmarchive_asm.sql script. in the +ASM Instance, which contains statements like these:
==================================================================
alter diskgroup DISK_GROUP1 drop file '+DISK_GROUP1/v10gasm//1_1809_563453055.dbf' ;

alter diskgroup DISK_GROUP1 drop file '+DISK_GROUP1/v10gasm//1_1810_563453055.dbf' ;

alter diskgroup DISK_GROUP1 drop file '+DISK_GROUP1/v10gasm//1_1811_563453055.dbf' ;

alter diskgroup DISK_GROUP1 drop file '+DISK_GROUP1/v10gasm//1_1812_563453055.dbf' ;
==================================================================

$ export ORACLE_SID=+ASM

$ sqlplus "/as sysdba"

SQL> @ rmarchive_asm.sql
==================================================================



3) The archivelogs will be removed and the space will be release therefore the archiver process will be able
to archive again in the ASM diskgroup.


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-763566/,如需轉載,請註明出處,否則將追究法律責任。

相關文章