284.631750213
not found or out of sync with catalog
trying alternate file for archived log of thread 1 with sequence 95
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=77 RECID=1 STAMP=631556992
. . .
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 602
Finished backup at 04-SEP-07
RMAN>
The backup validate command has identified an archived redo log file that is no longer in the
flash recovery area. It may have been archived to tape outside of RMAN, or it may have been
inadvertently deleted (in this case, it appears that the log file was intentionally deleted). Looking
at the datestamp of the log file, we see that it is outside of our recovery window of four days, so
it is not a critical file in terms of recoverability.
454 Oracle Database 11g DBA Handbook
Synchronizing the flash recovery area and the catalog with the crosscheck command is
covered later in this chapter; once we have fixed the cross-reference problem we have just
discovered, we can perform the rest of the validation:
RMAN> backup validate database archivelog all;
Starting backup at 04-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=77 RECID=1 STAMP=631556992
input archived log thread=1 sequence=78 RECID=3 STAMP=631556992
input archived log thread=1 sequence=79 RECID=5 STAMP=631556995
input archived log thread=1 sequence=80 RECID=7 STAMP=631556998
input archived log thread=1 sequence=81 RECID=9 STAMP=631557001
input archived log thread=1 sequence=82 RECID=11 STAMP=631557001
input archived log thread=1 sequence=83 RECID=13 STAMP=631566057
input archived log thread=1 sequence=84 RECID=16 STAMP=631578707
input archived log thread=1 sequence=85 RECID=18 STAMP=631590167
input archived log thread=1 sequence=86 RECID=20 STAMP=631607160
input archived log thread=1 sequence=87 RECID=22 STAMP=631623660
input archived log thread=1 sequence=88 RECID=24 STAMP=631643444
.
Pages:
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698