解决delete archivelog all无法彻底删除归档日志的问题

最近在因归档日志暴增，使用delete archivelog all貌似无法清除所有的归档日志，到底是什么原因呢？

1、演示环境

SQL> select * from v$version where rownum<2;

BANNER

----------------------------------------------------------------

Oracle Database 10g Release 10.2.0.3.0 - 64bit Production

SQL> select inst_id,instance_name from gv$instance; -->两节点RAC

INST_ID INSTANCE_NAME

---------- ----------------

1 GOBO4A

2 GOBO4B

SQL> show parameter db_recovery   -->+REV,使用了ASM 存储方式

NAME                                 TYPE        VALUE

------------------------------------ ----------- -------------

db_recovery_file_dest                string      +REV

db_recovery_file_dest_size           big integer 1G  

SQL> select flashback_on from v$database;  -->数据库未开启闪回特性，也就是说尽管指定了闪回区，未启用闪回特性

                                  -->相应的，归档日志充满整个闪回区时，闪回区空间并不会被重用

FLASHBACK_ON

------------------

NO

2、查看及清除现有的归档日志文件  

oracle@bo2dbp:~> export ORACLE_SID=+ASM1

oracle@bo2dbp:~> asmcmd

ASMCMD> cd +REV/GOBO4/ARCHIVELOG

ASMCMD> ls

2012_10_08/

....

arch_795194241_1_10.arc

arch_795194241_1_100.arc

....

oracle@bo2dbp:~> export ORACLE_SID=GOBO4A

oracle@bo2dbp:~> rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Nov 29 16:23:15 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: GOBO4 (DBID=921286879)

#下面通过使用rman backup archivelog方式来删除所有的归档日志文件

RMAN> backup format '/install_source/rman_bak/arch_%d_%U'

2> archivelog all delete input;

Starting backup at 29-NOV-12

current log archived

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1058 instance=GOBO4A devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=139 recid=214 stamp=797450261

input archive log thread=1 sequence=140 recid=215 stamp=797450292

input archive log thread=1 sequence=141 recid=216 stamp=797450308

input archive log thread=1 sequence=142 recid=218 stamp=797450347

input archive log thread=1 sequence=143 recid=219 stamp=797450372

input archive log thread=1 sequence=144 recid=220 stamp=797450409

channel ORA_DISK_1: starting piece 1 at 29-NOV-12

channel ORA_DISK_1: finished piece 1 at 29-NOV-12

查看本栏目更多精彩内容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/