[Translated from mos] The asm archive path is full, mosasm

[Translated from mos] The asm archive path is full, mosasm

The asm archiving path is full.

Reference Original:
ASM Archive destination is full. (Doc ID 351547.1)

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

Symptoms:
1) The Archiving path is full.
2) archive files are stored in asm.

Cause:
The asm disk space is exhausted.

Solution:

1) edit the following script in the database instance:
========================================================== ======================================
Spool rmarchive_asm. SQL
Set linesize 300

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

Spool off
========================================================== ======================================

---> Note: The preceding query for V $ ARCHIVED_LOG does not contain the where condition. Add the where condition on your own.

2) execute this rmarchive_asm. SQL In the asm instance, for example:
========================================================== ======================================
Alter diskgroup DISK_GROUP1 drop file '+ DISK_GROUP1/v10gasm // 4101809_563453055.dbf ';

Alter diskgroup DISK_GROUP1 drop file '+ DISK_GROUP1/v10gasm // 4101810_563453055.dbf ';

Alter diskgroup DISK_GROUP1 drop file '+ DISK_GROUP1/v10gasm // 4101811_563453055.dbf ';

Alter diskgroup DISK_GROUP1 drop file '+ DISK_GROUP1/v10gasm // 4101812_563453055.dbf ';
========================================================== ======================================

$ Export ORACLE_SID = + ASM

$ Sqlplus "/as sysdba"

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

3) The archived log will be removed and the space will be released. Therefore, the archiving process can be archived in the asm disk group.