ASM删除archivelog

amwdnuff

ASM删除archivelog



Oracle ASM删除归档日志
一、查询当前归档路径
$export ORACLE_SID=rac1
$sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 20 23:43:59 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +FLASHBACK_DISK/rac/archivelog
Oldest online log sequence     30
Next log sequence to archive   31
Current log sequence           31

确定当前归档目录的路径为“+FLASHBACK_DISK/rac/archivelog”。

二、asmcmd命令行删除指定archivelog
$export ORACLE_SID=+ASM1
$asmcmd
ASMCMD>
ASMCMD> ls        
FLASHBACK_DISK/
RAC_DISK/
ASMCMD>
ASMCMD>
ASMCMD> cd +FLASHBACK_DISK/rac/archivelog
ASMCMD> ls
1_69_726504737.dbf
1_70_726504737.dbf
2010_08_08/
2010_09_20/
2010_09_21/
2_28_726504737.dbf
2_29_726504737.dbf
ASMCMD> rm 1_69_726504737.dbf
ASMCMD> rm 2_28_726504737.dbf
ASMCMD> rm 2_29_726504737.dbf

三、从RMAN中校验并删除过期归档
$export ORACLE_SID=rac1
$rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 21 00:43:04 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: RAC (DBID=2314486753)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=rac1 devtype=DISK
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/1_11_726504737.dbf recid=2 s**p=726512010
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/1_12_726504737.dbf recid=4 s**p=726512121
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/1_13_726504737.dbf recid=8 s**p=727096441
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/1_14_726504737.dbf recid=10 s**p=727110648
validation failed for archived log
archive log filename=+FLASHBACK_DISK/rac/archivelog/1_69_726504737.dbf recid=12 s**p=730255226
validation succeeded for archived log
archive log filename=+FLASHBACK_DISK/rac/archivelog/1_70_726504737.dbf recid=13 s**p=730255273
validation succeeded for archived log
archive log filename=+FLASHBACK_DISK/rac/2_1_726504737.dbf recid=1 s**p=726498306
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/2_2_726504737.dbf recid=3 s**p=726500578
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/2_3_726504737.dbf recid=5 s**p=726500687
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/2_4_726504737.dbf recid=6 s**p=726515975
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/2_5_726504737.dbf recid=7 s**p=727096438
validation failed for archived log
archive log filename=+RAC_DISK/rac/archive/2_6_726504737.dbf recid=9 s**p=727098115
validation failed for archived log
archive log filename=+FLASHBACK_DISK/rac/archivelog/2_28_726504737.dbf recid=11 s**p=730250879
validation failed for archived log
archive log filename=+FLASHBACK_DISK/rac/archivelog/2_29_726504737.dbf recid=14 s**p=730250935
Crosschecked 14 objects

RMAN> delete noprompt expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=rac1 devtype=DISK
List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
2       1    11      X 08-AUG-10 +RAC_DISK/rac/archive/1_11_726504737.dbf
4       1    12      X 08-AUG-10 +RAC_DISK/rac/archive/1_12_726504737.dbf
8       1    13      X 08-AUG-10 +RAC_DISK/rac/archive/1_13_726504737.dbf
10      1    14      X 08-AUG-10 +RAC_DISK/rac/archive/1_14_726504737.dbf
12      1    69      X 20-SEP-10 +FLASHBACK_DISK/rac/archivelog/1_69_726504737.dbf
3       2    2       X 08-AUG-10 +RAC_DISK/rac/archive/2_2_726504737.dbf
5       2    3       X 08-AUG-10 +RAC_DISK/rac/archive/2_3_726504737.dbf
6       2    4       X 08-AUG-10 +RAC_DISK/rac/archive/2_4_726504737.dbf
7       2    5       X 08-AUG-10 +RAC_DISK/rac/archive/2_5_726504737.dbf
9       2    6       X 15-AUG-10 +RAC_DISK/rac/archive/2_6_726504737.dbf
11      2    28      X 30-AUG-10 +FLASHBACK_DISK/rac/archivelog/2_28_726504737.dbf
14      2    29      X 20-SEP-10 +FLASHBACK_DISK/rac/archivelog/2_29_726504737.dbf
deleted archive log
archive log filename=+RAC_DISK/rac/archive/1_11_726504737.dbf recid=2 s**p=726512010
deleted archive log
archive log filename=+RAC_DISK/rac/archive/1_12_726504737.dbf recid=4 s**p=726512121
deleted archive log
archive log filename=+RAC_DISK/rac/archive/1_13_726504737.dbf recid=8 s**p=727096441
deleted archive log
archive log filename=+RAC_DISK/rac/archive/1_14_726504737.dbf recid=10 s**p=727110648
deleted archive log
archive log filename=+FLASHBACK_DISK/rac/archivelog/1_69_726504737.dbf recid=12 s**p=730255226
deleted archive log
archive log filename=+RAC_DISK/rac/archive/2_2_726504737.dbf recid=3 s**p=726500578
deleted archive log
archive log filename=+RAC_DISK/rac/archive/2_3_726504737.dbf recid=5 s**p=726500687
deleted archive log
archive log filename=+RAC_DISK/rac/archive/2_4_726504737.dbf recid=6 s**p=726515975
deleted archive log
archive log filename=+RAC_DISK/rac/archive/2_5_726504737.dbf recid=7 s**p=727096438
deleted archive log
archive log filename=+RAC_DISK/rac/archive/2_6_726504737.dbf recid=9 s**p=727098115
deleted archive log
archive log filename=+FLASHBACK_DISK/rac/archivelog/2_28_726504737.dbf recid=11 s**p=730250879
deleted archive log
archive log filename=+FLASHBACK_DISK/rac/archivelog/2_29_726504737.dbf recid=14 s**p=730250935
Deleted 12 EXPIRED objects

RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=rac1 devtype=DISK
validation succeeded for archived log
archive log filename=+FLASHBACK_DISK/rac/archivelog/1_70_726504737.dbf recid=13 s**p=730255273
validation succeeded for archived log
archive log filename=+FLASHBACK_DISK/rac/2_1_726504737.dbf recid=1 s**p=726498306
Crosschecked 2 objects

RMAN>