v$archived_log视图

 

 1 查询方法

SQL> set lines 200

SQL> col name for a100

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

Session altered.

SQL> select name,completion_time,status from v$archived_log;

2 参数Status的解释

STATUS=A Available，表示归档日志文件有效

STATUS=U Unavailable，表示归档日志文件无效

STATUS=D Deleted，表示归档日志已经被删除

STATUS=X eXpired，表示归档日志被用户使用操作系统的命令删除了

3 手工移动归档日志

今天，将其中一个归档日志移动其他目录，再移回来。日志文件的Status就变成了X。

处理方法：将日志移动相应的位置。再在Rman中运行：crosscheck archivelog all。

 

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=84 devtype=DISK

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_15_6x3s7xyc_.arc recid=7 stamp=751374078

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_16_6x3tqoo6_.arc recid=8 stamp=751375605

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_17_6x3tqs9w_.arc recid=9 stamp=751375609

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_18_6x3tqycj_.arc recid=10 stamp=751375614

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_19_6x3tr29k_.arc recid=11 stamp=751375618

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_20_6x3trfbf_.arc recid=12 stamp=751375629

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_21_6x3trkbm_.arc recid=13 stamp=751375633

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_22_6x3xg7hs_.arc recid=14 stamp=751378375

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_23_6x3xm1t4_.arc recid=15 stamp=751378529

validation succeeded for archived log

archive log filename=/app/oracle/flash_recovery_area/TEST/archivelog/2011_05_17/o1_mf_1_24_6x3xmfm2_.arc recid=16 stamp=751378541