rman 刪除所有過期歸檔

1、SQL> select name from v$archived_log;

NAME
--------------------------------------------------------------------------------
/arch1/arch_1_5_766706446.log
/arch1/arch_1_6_766706446.log
/arch1/arch_1_7_766706446.log
/arch1/arch_1_8_766706446.log
/arch1/arch_1_9_766706446.log
/arch1/arch_1_10_766706446.log
/arch1/arch_1_11_766706446.log
/arch1/arch_1_12_766706446.log
/arch1/arch_1_13_766706446.log
/arch1/arch_1_14_766706446.log
/arch1/arch_1_15_766706446.log

NAME
--------------------------------------------------------------------------------
/arch1/arch_1_16_766706446.log
/arch1/arch_1_17_766706446.log
/arch1/arch_1_19_766706446.log
/arch1/arch_1_18_766706446.log
/arch1/arch_1_20_766706446.log
/arch1/arch_1_21_766706446.log
/arch1/arch_1_22_766706446.log
/arch1/arch_1_23_766706446.log


上面日誌有的是過期的（expired）.


2、使用rman 查詢和刪除過期的歸檔
[oracle@yitai ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 16 15:12:45 2012

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

connected to target database: CUUG (DBID=1247937484)


RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK
validation failed for archived log
archive log filename=/arch1/arch_1_5_766706446.log recid=1 stamp=796830677
validation failed for archived log
archive log filename=/arch1/arch_1_6_766706446.log recid=2 stamp=796830677
validation failed for archived log
archive log filename=/arch1/arch_1_7_766706446.log recid=3 stamp=796831908
validation failed for archived log
archive log filename=/arch1/arch_1_8_766706446.log recid=4 stamp=796832094
validation failed for archived log
archive log filename=/arch1/arch_1_9_766706446.log recid=5 stamp=796832102
validation failed for archived log
archive log filename=/arch1/arch_1_10_766706446.log recid=6 stamp=796832363
validation failed for archived log
archive log filename=/arch1/arch_1_11_766706446.log recid=7 stamp=796832371
validation failed for archived log
archive log filename=/arch1/arch_1_12_766706446.log recid=8 stamp=796832381
validation failed for archived log
archive log filename=/arch1/arch_1_13_766706446.log recid=9 stamp=796832394
validation failed for archived log
archive log filename=/arch1/arch_1_14_766706446.log recid=10 stamp=796832401
validation failed for archived log
archive log filename=/arch1/arch_1_15_766706446.log recid=11 stamp=796832410
validation failed for archived log
archive log filename=/arch1/arch_1_16_766706446.log recid=12 stamp=796832415
validation failed for archived log
archive log filename=/arch1/arch_1_17_766706446.log recid=13 stamp=796832422
validation failed for archived log
archive log filename=/arch1/arch_1_18_766706446.log recid=15 stamp=796833242
validation failed for archived log
archive log filename=/arch1/arch_1_19_766706446.log recid=14 stamp=796833242
validation failed for archived log
archive log filename=/arch1/arch_1_20_766706446.log recid=16 stamp=796833245
validation failed for archived log
archive log filename=/arch1/arch_1_21_766706446.log recid=17 stamp=796833408
validation failed for archived log
archive log filename=/arch1/arch_1_22_766706446.log recid=18 stamp=796835220
validation succeeded for archived log
archive log filename=/arch1/arch_1_23_766706446.log recid=19 stamp=796835527
Crosschecked 19 objects

RMAN> list expired archivelog all;   #列出過期的歸檔


List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
1       1    5       X 16-OCT-12 /arch1/arch_1_5_766706446.log
2       1    6       X 16-OCT-12 /arch1/arch_1_6_766706446.log
3       1    7       X 16-OCT-12 /arch1/arch_1_7_766706446.log
4       1    8       X 16-OCT-12 /arch1/arch_1_8_766706446.log
5       1    9       X 16-OCT-12 /arch1/arch_1_9_766706446.log
6       1    10      X 16-OCT-12 /arch1/arch_1_10_766706446.log
7       1    11      X 16-OCT-12 /arch1/arch_1_11_766706446.log
8       1    12      X 16-OCT-12 /arch1/arch_1_12_766706446.log
9       1    13      X 16-OCT-12 /arch1/arch_1_13_766706446.log
10      1    14      X 16-OCT-12 /arch1/arch_1_14_766706446.log
11      1    15      X 16-OCT-12 /arch1/arch_1_15_766706446.log
12      1    16      X 16-OCT-12 /arch1/arch_1_16_766706446.log
13      1    17      X 16-OCT-12 /arch1/arch_1_17_766706446.log
15      1    18      X 16-OCT-12 /arch1/arch_1_18_766706446.log
14      1    19      X 16-OCT-12 /arch1/arch_1_19_766706446.log
16      1    20      X 16-OCT-12 /arch1/arch_1_20_766706446.log
17      1    21      X 16-OCT-12 /arch1/arch_1_21_766706446.log
18      1    22      X 16-OCT-12 /arch1/arch_1_22_766706446.log


RMAN> delete noprompt expired archivelog all; #刪除過期的歸檔

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
1       1    5       X 16-OCT-12 /arch1/arch_1_5_766706446.log
2       1    6       X 16-OCT-12 /arch1/arch_1_6_766706446.log
3       1    7       X 16-OCT-12 /arch1/arch_1_7_766706446.log
4       1    8       X 16-OCT-12 /arch1/arch_1_8_766706446.log
5       1    9       X 16-OCT-12 /arch1/arch_1_9_766706446.log
6       1    10      X 16-OCT-12 /arch1/arch_1_10_766706446.log
7       1    11      X 16-OCT-12 /arch1/arch_1_11_766706446.log
8       1    12      X 16-OCT-12 /arch1/arch_1_12_766706446.log
9       1    13      X 16-OCT-12 /arch1/arch_1_13_766706446.log
10      1    14      X 16-OCT-12 /arch1/arch_1_14_766706446.log
11      1    15      X 16-OCT-12 /arch1/arch_1_15_766706446.log
12      1    16      X 16-OCT-12 /arch1/arch_1_16_766706446.log
13      1    17      X 16-OCT-12 /arch1/arch_1_17_766706446.log
15      1    18      X 16-OCT-12 /arch1/arch_1_18_766706446.log
14      1    19      X 16-OCT-12 /arch1/arch_1_19_766706446.log
16      1    20      X 16-OCT-12 /arch1/arch_1_20_766706446.log
17      1    21      X 16-OCT-12 /arch1/arch_1_21_766706446.log
18      1    22      X 16-OCT-12 /arch1/arch_1_22_766706446.log
deleted archive log
archive log filename=/arch1/arch_1_5_766706446.log recid=1 stamp=796830677
deleted archive log
archive log filename=/arch1/arch_1_6_766706446.log recid=2 stamp=796830677
deleted archive log
archive log filename=/arch1/arch_1_7_766706446.log recid=3 stamp=796831908
deleted archive log
archive log filename=/arch1/arch_1_8_766706446.log recid=4 stamp=796832094
deleted archive log
archive log filename=/arch1/arch_1_9_766706446.log recid=5 stamp=796832102
deleted archive log
archive log filename=/arch1/arch_1_10_766706446.log recid=6 stamp=796832363
deleted archive log
archive log filename=/arch1/arch_1_11_766706446.log recid=7 stamp=796832371
deleted archive log
archive log filename=/arch1/arch_1_12_766706446.log recid=8 stamp=796832381
deleted archive log
archive log filename=/arch1/arch_1_13_766706446.log recid=9 stamp=796832394
deleted archive log
archive log filename=/arch1/arch_1_14_766706446.log recid=10 stamp=796832401
deleted archive log
archive log filename=/arch1/arch_1_15_766706446.log recid=11 stamp=796832410
deleted archive log
archive log filename=/arch1/arch_1_16_766706446.log recid=12 stamp=796832415
deleted archive log
archive log filename=/arch1/arch_1_17_766706446.log recid=13 stamp=796832422
deleted archive log
archive log filename=/arch1/arch_1_18_766706446.log recid=15 stamp=796833242
deleted archive log
archive log filename=/arch1/arch_1_19_766706446.log recid=14 stamp=796833242
deleted archive log
archive log filename=/arch1/arch_1_20_766706446.log recid=16 stamp=796833245
deleted archive log
archive log filename=/arch1/arch_1_21_766706446.log recid=17 stamp=796833408
deleted archive log
archive log filename=/arch1/arch_1_22_766706446.log recid=18 stamp=796835220
Deleted 18 EXPIRED objects

#刪除了18個歸檔

------Good Luck !----------