V $ archived_log View

 

 1. Query Method

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. Description of the status parameter

Status = A available, indicating that the archived log file is valid

Status = u unavailable, indicating that the archived log file is invalid

Status = D deleted, indicating that the archived log has been deleted

Status = x expired, indicating that the archived log is deleted by the user using the operating system command

3. manually move archived logs

Today, one of the archived logs is moved to another directory and then moved back. The status of the log file is changed to X.

Solution: Move the log to the corresponding location. Run crosscheck archivelog all in RMAN.

 

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/20151105_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/20151105_17/o%mf_%16_6x3tqoo6 _. Arc recid = 8 stamp = 751375605

Validation succeeded for archived log

Archive log filename =/APP/Oracle/flash_recovery_area/test/archivelog/20151105_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/20151105_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/20151105_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/20151105_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/20151105_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/20151105_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/20151105_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/20151105_17/o1_mf_1_24_6x3xmfm2 _. Arc recid = 16 stamp = 751378541