5 Replies Latest reply: Oct 26, 2013 4:38 AM by Asif Muhammad RSS

    ORA-00257: archiver error.

    Ankur ...

      Hi Experts,

       

      Again, I need you expert opinions on the issue I'm facing in my EBS production database.

      My database is up and running but I see loads of ORA errors in my alert log file...


      Content of alert logfile:-

      ORA-16038: log 1 sequence# 8950 cannot be archived

      ORA-19502: write error on file "", block number (block size=)
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16014: log 1 sequence# 8950 not archived, no available destinations

      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16038: log 1 sequence# 8950 cannot be archived

      ORA-19502: write error on file "", block number (block size=)
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16014: log 1 sequence# 8950 not archived, no available destinations

      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16038: log 1 sequence# 8950 cannot be archived

      ORA-19502: write error on file "", block number (block size=)
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16014: log 1 sequence# 8950 not archived, no available destinations

      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'
      ORA-16038: log 1 sequence# 8950 cannot be archived

      ORA-19502: write error on file "", block number (block size=)
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01a.log'
      ORA-00312: online log 1 thread 1: '/mnt/PRDdata/trcprd/redo01b.log'

       

      Also my Workflow mailer has stopped with this error:

      " ORA-00257: archiver error. Connect internal only, until freed.. "

       

      The first thing I did after this error was to check the archive destination space

      SQL> archive log list;

      Database log mode              Archive Mode

      Automatic archival             Enabled

      Archive destination            /mnt/PRDarchive/trcprd

      Oldest online log sequence     8960

      Next log sequence to archive   8960

      Current log sequence           8962

       

      SQL> !df -h /mnt/PRDarchive/trcprd

      Filesystem            Size  Used Avail Use% Mounted on

      /dev/mapper/oracle_archive-oracle_archive

                             99G   94G   59M 100% /mnt/PRDarchive

       

      I removed some of the old archives which were already backed up to release some space, and ran

      1. crosscheck archivelog all

      2. delete noprompt expired archivelog all;

      2. crosscheck archivelog all;

       

      Meanwhile my database was scheduled for a hot backup, and it failed with the below error:

      The log file says:-

      RMAN-03009: failure of delete command on dsk_9 channel at 10/25/2013 23:59:49

      ORA-19606: Cannot copy or restore to snapshot control file

       

      Please tell me how do I troubleshoot to know the root cause behind all these activities and how do I fix it.

      Your response will be highly appreciated.

       

      DB Version - 11.2.0.3

      OS Version - RHEL 5, 64bit

      EBS Version- 11.5.10.2

       

      -Thanks

        • 1. Re: ORA-00257: archiver error.
          Asif Muhammad

          Hi,

           

          ORA-16038: log 1 sequence# 8950 cannot be archived

          ORA-19502: write error on file "", block number (block size=)

          Please confirm that after you have released space for archive logs, do you still get the errors that were before reported in the alert log file? And what is the current output of:

          df -h /mnt/PRDarchive/trcprd


          RMAN-03009: failure of delete command on dsk_9 channel at 10/25/2013 23:59:49

          ORA-19606: Cannot copy or restore to snapshot control file

          Please refer the following for cause and solution:

          ORA-19606: Cannot copy or restore to snapshot control file, RMAN-06214

          https://forums.oracle.com/message/3931860


          Thanks &

          Best Regards,



          • 2. Re: ORA-00257: archiver error.
            Ankur ...

            Asif,

             

            Thanks for the quick response.

            Yes I'm, still getting these errors in my alert log file. The current space of archive destination after deleting archived older than two days is:-

             

            $ df -h /mnt/PRDarchive/trcprd/

            Filesystem            Size  Used Avail Use% Mounted o

            /dev/mapper/oracle_archive-oracle_archive

                                   99G   90G  6.1G  91% /mnt/PRDarchive

            • 3. Re: ORA-00257: archiver error.
              Asif Muhammad

              Hi,

               

              Yes I'm, still getting these errors in my alert log file.

               

              Check the output of commands:

              show parameter log_archive dest;

              show parameter log_archive_dest_state;

               

              and apply the values with the same again and check if it resolves the error.

              Reference:

              Step Into Oracle DBA ( SID ): ORA-19502: write error on file, block number (block size=)

               

               

              In addition let us know the status of snapshot control file issue.

               

              Thanks &

              Best Regards

              • 4. Re: ORA-00257: archiver error.
                Ankur ...

                Asif,

                 

                Please find the details you asked. Everything looks in place to me, let me know if I'm missing something here.

                 

                SQL> show parameter log_archive dest;

                NAME                                 TYPE        VALUE

                log_archive_dest_1 string      location=/mnt/PRDarchive/trcprd  mandatory reopen=2

                log_archive_dest_state_1             string      enable

                log_archive_format                   string      TRCPRD_%s_%t_%r.arc

                log_archive_local_first              boolean     TRUE

                log_archive_max_processes            integer     4

                log_archive_min_succeed_dest         integer     1

                log_archive_start                    boolean     FALSE

                log_archive_trace integer     0

                log_archive_dest_2                   string      service="(DESCRIPTION=(ADDRESS

                =(PROTOCOL=TCP)(HOST=192.168.2

                .145)(PORT=1521))(CONNECT_DATA

                =(SERVER=DEDICATED)(SERVICE_NA

                ME=CDCPRD))) TEMPLATE=/mnt/dat

                                                                 a/cdcprddata/standbylog/CDCPRD

                %t_%s_%r.arc ARCH NOREGISTER"

                 

                 

                Many thanks for the pointers provided for "snapshot control file issue ". It has been taken cared now.

                Workaround:

                1. I stopped all the applications.

                2. Took RMAN archive backup.

                3. Deleted all the archives which were backed up.

                4. Started the applications.

                5. Now, taking RMAN hot backup of my database which failed earlier with

                RMAN-03009: failure of delete command on dsk_9 channel at 10/25/2013 23:59:49

                ORA-19606: Cannot copy or restore to snapshot control file

                Right now I do not see the occurrence of the "ORA-16038: log 1 sequence# 8950 cannot be archived". If that happens again, I will re-visit and update the thread with my findings.

                 

                -Thanks

                • 5. Re: ORA-00257: archiver error.
                  Asif Muhammad

                  Hi,

                   

                  Thanks for the outputs and I see the parameters just fine.

                   

                  Nice to hear the issue is not solved.

                   

                  Thanks &

                  Best Regards,