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> l ist 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 !----------
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> l ist 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 !----------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-746573/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-746573/