1 2 Previous Next 20 Replies Latest reply: Jan 3, 2013 10:09 PM by ericksco RSS

    RMAN-06059: expected archived log not found

    Jcgo-Oracle
      Hi All,

      11.2.0.3 database....

      I have run

      RMAN> crosscheck archivelog all;

      and also:

      RMAN> delete archivelog all;
      still get the above error when running:


      RMAN> backup database plus archivelog;

      Starting backup at 07-FEB-12
      current log archived
      using channel ORA_DISK_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup plus archivelog command at 02/07/2012 02:40:28
      RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

      ********

      is this a BUG?

      thanks
        • 1. Re: RMAN-06059: expected archived log not found
          NikolayIvankin
          >
          RMAN> crosscheck archivelog all;
          RMAN> backup database plus archivelog;
          Could it be, that someone ore something deletes archivelog between these two steps?
          • 2. Re: RMAN-06059: expected archived log not found
            sybrand_b
            No, it is not a bug. You ran 'delete archivelog all', you are trying to backup the database including the archivelogs Oracle still knows of, which were already deleted by you.

            If you would have run

            delete archivelog all;

            crosscheck archivelog all;

            delete expired archivelog all;

            backup database plus archivelog

            Oracle would not have complained.
            Recoverability though would still have been compromised.

            backup database plus archivelog skip inaccessible should do.

            -----------
            Sybrand Bakker
            Senior Oracle DBA
            • 3. Re: RMAN-06059: expected archived log not found
              John Stegeman
              is this a BUG?
              Dunno.

              Have you tried

              RMAN> change archivelog all crosscheck;

              Which is suggested [url http://www.shutdownabort.com/errors/RMAN-06059.php]here (the first Google result returned for rman-06059)?

              John
              • 4. Re: RMAN-06059: expected archived log not found
                NikolayIvankin
                sybrand_b wrote:
                No, it is not a bug. You ran 'delete archivelog all', you are trying to backup the database including the archivelogs Oracle still knows of, which were already deleted by you.
                Disagree, if a person deletes archivelog by RMAN, then RMAN renews info about deleted archivelogs in controlfile or catalog db.
                • 5. Re: RMAN-06059: expected archived log not found
                  Jcgo-Oracle
                  In response to Nikolay and Sybrand:

                  1). I had tried other steps prior to this post, sorry should have mentioned:

                  I had run CROSSCHECK even before running the backup command, and that error still came up.
                  CROSSCHECK is supposed to check archivelogs and record/validate against control file...but for some reason, its looking for logs that arent there...
                  • 6. Re: RMAN-06059: expected archived log not found
                    Jcgo-Oracle
                    Sybrand.

                    Ran the skip inaccessible option and see this output:

                    m1s3kvs_.arc not found or out of sync with catalog
                    skipping inaccessible file /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_280_7m1s3kvs_.arc
                    archived log /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_281_7m1s4f91_.arc not found or out of sync with catalog
                    skipping inaccessible file /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_281_7m1s4f91_.arc
                    archived log /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_282_7m1s6vfl_.arc not found or out of sync with catalog
                    skipping inaccessible file /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_282_7m1s6vfl_.arc
                    archived log /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_283_7m1solr2_.arc not found or out of sync with catalog
                    skipping inaccessible file /u02/fast_recovery_area/REFAPEXP/archivelog/2012_02_07/o1_mf_2_283_7m1solr2_.arc

                    ************
                    Now question is how to sync all of these logs...
                    • 7. Re: RMAN-06059: expected archived log not found
                      19426
                      After

                      crosscheck archivelog all;

                      the appropriate delete command is

                      delete EXPIRED archivelog all;

                      That removes non-existing archivelogs on disk from the controlfile/recovery catalog. Without 'expired' all archivelogs are deleted, including those still valid.
                      • 8. Re: RMAN-06059: expected archived log not found
                        Jcgo-Oracle
                        Oradba,

                        Ran those 2 commands...same result:

                        mf2_285_7m1t3mdr_.arc RECID=525 STAMP=774586899
                        Deleted 7 EXPIRED objects


                        RMAN>

                        RMAN>

                        RMAN>

                        RMAN> sql 'alter system switch logfile'
                        2> ;

                        sql statement: alter system switch logfile

                        RMAN> backup database plus archivelog;


                        Starting backup at 07-FEB-12
                        current log archived
                        using channel ORA_DISK_1
                        using channel ORA_DISK_2
                        RMAN-00571: ===========================================================
                        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                        RMAN-00571: ===========================================================
                        RMAN-03002: failure of backup plus archivelog command at 02/07/2012 03:03:19
                        RMAN-06059: expected archived log not found, loss of archived log compromises re
                        coverability
                        • 9. Re: RMAN-06059: expected archived log not found
                          NikolayIvankin
                          is it RAC instance?
                          • 10. Re: RMAN-06059: expected archived log not found
                            sybrand_b
                            You deleted them, didn't you?
                            So, if you don't have another backup, they are gone.

                            Sorry

                            ----------------
                            Sybrand Bakker
                            Senior Oracle DBA
                            • 11. Re: RMAN-06059: expected archived log not found
                              CKPT
                              Hi,
                              RMAN> delete archivelog all;
                              still get the above error when running:
                              What error message you are having while executing the above command?

                              When archive log files deleted from OS knowingly/unknowingly Still v$archived_log shows you the archive log location,
                              So find out which archives are missing.

                              Run RMAN> delete expired archivelog all;

                              When you do not have archives (or) you do not have a copy of archives, Strongly Recommended to take FULL Backup
                              • 12. Re: RMAN-06059: expected archived log not found
                                Shivananda Rao
                                If the archive is deleted from OS level and if its an unbacked archive, then RMAN would not proceed with the backup.
                                You need to uncatalog the particular missing archive. But it is recommended to take full backup.
                                RMAN>change archivelog sequence <sequence#> uncatalog;
                                • 13. Re: RMAN-06059: expected archived log not found
                                  Jcgo-Oracle
                                  RMAN> delete expired archivelog all;

                                  released channel: ORA_DISK_1
                                  allocated channel: ORA_DISK_1
                                  channel ORA_DISK_1: SID=64 instance=refcdr1 device type=DISK
                                  specification does not match any archived log in the repository

                                  RMAN> backup archivelog all;

                                  Starting backup at 15-FEB-12
                                  current log archived
                                  using channel ORA_DISK_1
                                  RMAN-00571: ===========================================================
                                  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                                  RMAN-00571: ===========================================================
                                  RMAN-03002: failure of backup command at 02/15/2012 00:42:15
                                  RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
                                  ORA-19625: error identifying file /u02/arch2_781_764210170.dbf
                                  ORA-27037: unable to obtain file status
                                  Linux-x86_64 Error: 2: No such file or directory
                                  Additional information: 3

                                  RMAN>
                                  • 14. Re: RMAN-06059: expected archived log not found
                                    Jcgo-Oracle
                                    just fyi...I have taken at least data files backup...
                                    I am stumped at this point....


                                    Not sure if this matters, but this is RAC with SCAN...
                                    STILL should not matter....
                                    1 2 Previous Next