Recovery Manager (RMAN)

RMAN-06059: expected archive log not found


         RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
         

         ORA-19625: error identifying file /archlogpath/archsid_nnnn.arc
         

         ORA-27037: unable to obtain file status
         

         IBM AIX RISC System/6000 Error: 2: No such file or directory

Compare archive logs in RMAN to ones on disk


         list archivelog all;
         

         list archivelog like '/archlogpath/archsid_n%.arc';
         

         List of Archived Log Copies
         

         Key Thrd Seq S Low Time Name
         

         ------- ---- ------- - --------- ----
         

          nnnnnn 1 nnnn A dd-MON-yy /archlogpath/archsid_nnnn.arc
         

         ...
         

         host 'ls -l /archlogpath';

Delete all missing archive logs

DO NOT do crosscheck archivelog all with tape backups or archived logs, only disk backups or logs, where RMAN can successfully verify the existence of the files. Otherwise all backups or archived logs will become EXPIRED.


         list expired archivelog all;
         

         specification does not match any archive log in the recovery catalog
         

         

         crosscheck archivelog like '/archlogpath/archsid_n%.arc';
         

         crosscheck archivelog all;
         

         

         list expired archivelog all;
         

         List of Archived Log Copies
         

         Key Thrd Seq S Low Time Name
         

         ------- ---- ------- - --------- ----
         

          nnnnnn 1 nnnn X dd-MON-yy /archlogpath/archsid_nnnn.arc
         

         ...
         

         

         delete expired archivelog all;
         

         Do you really want to delete the above objects (enter YES or NO)?

Prev: Page 1 Next: Tablespace

Home > Computers > Databases > Oracle > RMAN > RMAN > RMAN

Viewing mobile website page. Switch to WML or Full HTML