Error: RMAN-06059 (RMAN-6059)Bye, Aron
Text: expected archived log not found, lost of archived log compromises
Cause: The archived log was not found. The repository thinks it does
exist. If the archived log has in fact been lost and there is no
backup, then the database is no longer recoverable across the
point in time covered by the archived log. This may occur because
the archived log was removed by an outside utility without
updating the repository.
Action: If the archived log has been removed with an outside utility and
the archivelog has already been backed up, then you can
synchronize the repository by running CROSSCHECK ARCHIVELOG ALL.
If the archivelog has not been previously backed up, then you
should take a full backup of the database and archivelogs to
preserve recoverability. Previous backups are not fully
delete expired archivelog all ;removes entries ( marks them as deleted ) in RMAN
Here the TAR explaination. With the command REPORTI am not surprised about such a *** answer from oracle support.
NEED BACKUP (see one of my first posts) will
only be listed the DATAFILES that require backup.
Archived log wont' be listed. (phone call with
So RMAN does not have infromation about that archivedThe question is not "Should I do a backup?" but rather "Will my restore work?"
As per documentation, after delteing expired logs,
this compromises availability of recovery !!
HENCE it is strongly recomended after you delete
expired Archivelogs to take a new FULL Database
Now I try to restore
RMAN> list backup of database summary; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- ------------------- ------- ------- ---------- --- 19142 B F A SBT_TAPE 23.03.2006 11:09:38 1 1 NO TAG20060323T110859 19167 B F A SBT_TAPE 23.03.2006 11:11:29 1 1 NO TAG20060323T111043 RMAN> list backup of archivelog all summary; RMAN> list archivelog all; specification does not match any archive log in the recovery catalog
RMAN> restore validate database; Starting restore at 23.03.2006 11:29:07 channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:16 channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:26 Finished restore at 23.03.2006 11:30:02 RMAN> startup force mount Oracle instance started database mounted RMAN> restore database; Starting restore at 23.03.2006 11:31:18 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:15 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:26 Finished restore at 23.03.2006 11:32:14 RMAN> recover database; Starting recover at 23.03.2006 12:27:45 starting media recovery unable to find archive log archive log thread=1 sequence=3 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/23/2006 12:36:16 RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 165418
RMAN RESTORE VALIDATE - does only verify if thewell, this is sad.
files can be restored from backup.
It does not check for missing logs !!!
Also as stated beforewell, it does not know about the existence, but it should exist a report command to report its absence...delete expired archivelog all ;removes entries ( marks them as deleted ) in RMAN
reporsitory, so RMAN does not know anomore about the
existence of this file !!Hence it is not checked !!
If there is missing logs, it MUST have been a rmannot an accurate answer. you could for example have deleted backups, either with "delete backup", "delete copy", "delete archivelog all", etc...
crosscheck before and : delete expired archivelogs!!
RMAN always expects at 'backup archivelog' allthis is still disappointing answer. If you "backup archivelog all delete input", you do not have your backup on disks. If you then "delete obsolete recovery window of 7 days" and want to restore database until 2 weeks ago, the validate is still useless.
archivelogs available for backup
If one archivelog is missing ( deleted.. ) RMAN will
report an error