2000元阿里云代金券免费领取，2核4G云服务器仅664元/3年，新老用户都有优惠，立即抢购>>>
阿里云采购季（云主机223元/3年）活动入口：请点击进入>>>，
阿里云学生服务器（9.5元/月）购买入口：请点击进入>>>，
list archivelog all 是列出控制文件中记录的未被rman delete 命令删除的手工删除的日志文件，如果手工删除之后使用list命令对应的日志文件的status为标记为X！
模拟删除日志yangdb_1_192_762800109.log
oracle@rac3:/opt/oracle/yangdb_arch>mv yangdb_1_192_762800109.log /tmp/
crosscheck 命令检查归档日志的信息：
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
validation failed for archived log
archived log file name=/opt/oracle/yangdb_arch/yangdb_1_192_762800109.log RECID=188 STAMP=770308389
validation succeeded for archived log
archived log file name=/opt/oracle/yangdb_arch/yangdb_1_193_762800109.log RECID=189 STAMP=770308806
validation succeeded for archived log
再次使用list archivelog all; mv掉的日志被标记为X。
RMAN> list archivelog all;
List of Archived Log Copies for database with db_unique_name YANGDB
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
188 1 192 X 19-DEC-11 Name: /opt/oracle/yangdb_arch/yangdb_1_192_762800109.log
189 1 193 A 19-DEC-11 Name: /opt/oracle/yangdb_arch/yangdb_1_193_762800109.log
RMAN> list expired archivelog all;
List of Archived Log Copies for database with db_unique_name YANGDB
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
188 1 192 X 19-DEC-11 Name: /opt/oracle/yangdb_arch/yangdb_1_192_762800109.log
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
List of Archived Log Copies for database with db_unique_name YANGDB
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
188 1 192 X 19-DEC-11 Name: /opt/oracle/yangdb_arch/yangdb_1_192_762800109.log
Do you really want to delete the above objects (enter YES or NO)? y
deleted archived log
archived log file name=/opt/oracle/yangdb_arch/yangdb_1_192_762800109.log RECID=188 STAMP=770308389
Deleted 1 EXPIRED objects
删除之后再次查看！已经yangdb_1_192_762800109.log被删除的！
RMAN> list archivelog all;
List of Archived Log Copies for database with db_unique_name YANGDB
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
189 1 193 A 19-DEC-11 Name: /opt/oracle/yangdb_arch/yangdb_1_193_762800109.log
RMAN>
list backup of archivelog all;查看已经备份的归档日志！
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
184 2.50K DISK 00:00:00 19-DEC-11
BP Key: 184 Status: AVAILABLE Compressed: NO Tag: TAG20111219T143310
Piece Name: /opt/oracle/flash_recovery_area/YANGDB/backupset/2011_12_19/o1_mf_annnn_TAG20111219T143310_7gxpo6cf_.bkp
List of Archived Logs in backup set 184
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 192 4388362 19-DEC-11 4388394 19-DEC-11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
185 16.00K DISK 00:00:00 19-DEC-11
BP Key: 185 Status: AVAILABLE Compressed: NO Tag: TAG20111219T144006
Piece Name: /opt/oracle/flash_recovery_area/YANGDB/backupset/2011_12_19/o1_mf_annnn_TAG20111219T144006_7gxq26r4_.bkp
List of Archived Logs in backup set 185
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 193 4388394 19-DEC-11 4388874 19-DEC-11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
191 7.50K DISK 00:00:00 19-DEC-11
BP Key: 191 Status: AVAILABLE Compressed: NO Tag: TAG20111219T144042
Piece Name: /opt/oracle/flash_recovery_area/YANGDB/backupset/2011_12_19/o1_mf_annnn_TAG20111219T144042_7gxq3b2n_.bkp
List of Archived Logs in backup set 191
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 194 4388874 19-DEC-11 4388908 19-DEC-11
RMAN>
