ASM Archive destination is full. [ID 351547.1]
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.7This 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 SQLdynamic script. with the alter diskgroup
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OGG - No Valid Default Archive Destination Directory Found for Thread #Hivethread
- Oracle 10G Archive Destination 理解Oracle 10gHive
- ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]REMHive
- ORA-16009: remote archive log destination must be a STANDBY databaseREMHiveDatabase
- Oracle ocp 1Z0 053 Q563(archive-log destination)OracleHive
- 如何破解cuteftp4.2 full.FTP
- How to Manually Determining and Resolving Archive Gaps in ASM [ID 1271114.1]HiveASM
- 如何在SAP Server Side JavaScript裡消費destinationServerIDEJavaScript
- Identify If A Disk/Part Is Still Used By ASM,Used by ASM Or Used by ASM_603210.1IDEASM
- Android Transform + ASM 初探AndroidORMASM
- Checking for Oracle archive log corruption [ID 1268590.1]OracleHive
- ORA-16047: DGID mismatch between destination setting and target databaseDatabase
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- Duplicate database from non ASM to ASM to a different host [ID 382669.1]DatabaseASM
- SSIS display null in destination fileNull
- Swift iOS : ArchiveSwiftiOSHive
- 更改Archive ModeHive
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- ASM條帶揭密----_asm_stripesize、_asm_stripewidth引數的設定和影響ASM
- ORA-15097 Cannot Shutdown ASM if OCR is Located in ASM (Doc ID 984663.1)ASM
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- standby_archive_dest和log_archive_dest_n區別Hive
- log_archive_dest與log_archive_dest_n區別Hive
- 11g feature: Flashback Data Archive Guide. (Doc ID 470199.1)HiveGUIIDE
- ABAP和Java的destination和JNDIJava
- Oracle Flashback Data ArchiveOracleHive
- Flashback Data Archive RequirementsHiveUIREM
- ASM - Scalability and Limits [ID 370921.1]ASMMIT
- Archive Log Files Created With Permission Bit 440 Instead Of 640 [ID 458901.1]Hive
- [leetcode] 1436. Destination CityLeetCode
- asm files,asm directories,asm templatesASM
- Ten examples of git-archiveGitHive
- MySQL Archive儲存引擎MySqlHive儲存引擎
- git archive命令詳解GitHive
- oracle archive歸檔初步OracleHive
- ASM Installation Logs Location. [ID 1349705.1]ASM
- Master Note For ASM For OS Administrators [ID 1345562.1]ASTASM