released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK
List of Archived Log Copies for database with db_unique_name TEST
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
1 1 2 X 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2012_03_23
\O1_MF_1_2_7PQYKCLL_.ARC
2 1 3 X 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2012_03_23
\O1_MF_1_3_7PQYKGH3_.ARC
3 1 4 X 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2012_03_23
\O1_MF_1_4_7PQYKKFQ_.ARC
4 1 5 X 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2012_03_23
\O1_MF_1_5_7PQYKQTW_.ARC
5 1 6 X 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2012_03_23
\O1_MF_1_6_7PQYKSX0_.ARC
这里会提示你是否删除:
Do you really want to delete the above objects (enter YES or NO) y
deleted archived log www.2cto.com
archived log file name=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2
012_03_23\O1_MF_1_2_7PQYKCLL_.ARC RECID=1 STAMP=778681261
deleted archived log
archived log file name=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2
012_03_23\O1_MF_1_3_7PQYKGH3_.ARC RECID=2 STAMP=778681262
deleted archived log
archived log file name=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2
012_03_23\O1_MF_1_4_7PQYKKFQ_.ARC RECID=3 STAMP=778681265
deleted archived log
archived log file name=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2
012_03_23\O1_MF_1_5_7PQYKQTW_.ARC RECID=4 STAMP=778681272
deleted archived log
archived log file name=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\TEST\ARCHIVELOG\2
012_03_23\O1_MF_1_6_7PQYKSX0_.ARC RECID=5 STAMP=778681274
Deleted 5 EXPIRED objects
查看闪回区使用状态
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 11.99 0 1224
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected
方法2:直接在rman下删除归档日志
delete archivelog all completed before 'sysdate';
这个命令是把当前日期之前的全部删掉 www.2cto.com
可以指定删除几天之前的,比如删除七天之前的
delete archivelog all completed before 'sysdate-7';
RMAN> delete archivelog all completed before 'sysdate';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK
List of Archived Log Copies for database with db_unique_name TEST
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
6 1 7 A 23-MAR-12
Name: D:\APP\ADMINISTRATOR\FAST_