9 Replies Latest reply on Apr 30, 2014 2:59 PM by Hemant K Chitale

    ORA-00312 cannot be archived redo shipment archive

    A. Uyanik

      Dear Oracle fanatics,

       

      Weve got a site which seems to give us the following error sporadically , is there anyone with the same experience and/or know how what to do or perhaps any leads to where to search would be very welcome.

       

      Many thanks in advance !!

       


      It should not be related to privileges or disk space as seen below :

       

      sppaxdb02 # df -h

      Filesystem             size   used  avail capacity  Mounted on

      /                           187G    32G   156G    17%    /

      /dev                      187G    32G   156G    17%    /dev

      /flashback             295G   138G   155G    48%    /flashback

      /zdbase/data1       266G   112G   151G    43%    /zdbase/data1

      /zdbase/index1     172G    50G   121G    30%    /zdbase/index1

      /zdbase/system     49G    30G    18G    63%    /zdbase/system

      proc                     0K     0K     0K     0%    /proc

      ctfs                      0K     0K     0K     0%    /system/contract

      mnttab                 0K     0K     0K     0%    /etc/mnttab

      objfs                    0K     0K     0K     0%    /system/object

      swap                    58G   368K    58G     1%    /etc/svc/volatile

      /platform/sun4v/lib/libc_psr/libc_psr_hwcap2.so.1

                             187G    32G   156G    17%    /platform/sun4v/lib/libc_psr.so.1

      /platform/sun4v/lib/sparcv9/libc_psr/libc_psr_hwcap2.so.1

                             187G    32G   156G    17%    /platform/sun4v/lib/sparcv9/libc_psr.so.1

      fd                       0K     0K     0K     0%    /dev/fd

      swap                    58G    64K    58G     1%    /tmp

      swap                    58G    48K    58G     1%    /var/run

      sppaxdb02 #

       

      sppaxdb02 # ls -lhart

      total 43734

      drwxr-xr-x   4 root     root         512 Oct 15  2013 ..

      drwxr-xr-x   5 oracle   dba          512 Oct 16  2013 MVF2

      -rw-r-----   1 oracle   dba          21M Apr 29 07:36 bkupcontrolfile.ctl

      drwxr-xr-x   3 oracle   dba          512 Apr 29 07:36 .

      -rw-r-----   1 oracle   dba          96K Apr 29 07:36 bkupspfile.ora

      sppaxdb02 #

       

      Alert and tracefile sample below :

       

      Archived Log entry 71728 added for thread 1 sequence 52098 ID 0x7e57cb8 dest 10:

      Tue Apr 29 08:48:00 2014

      Errors in file /var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc:

      ORA-00314: log 13 of thread 1, expected sequence# 52100 doesn't match 52098

      ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'

      Tue Apr 29 08:48:00 2014

      RFS[11]: Selected log 13 for thread 1 sequence 52100 dbid -91217615 branch 787868464

      Tue Apr 29 08:48:01 2014

       

       

      "/var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc" 63 lines, 2458 characters

      Trace file /var/oracle/data/logs/impax/diag/diag/rdbms/mvf2/MVF/trace/MVF_arc1_2071.trc

      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

      With the Partitioning, Data Mining and Real Application Testing options

      ORACLE_HOME = /opt/oracle/current

      System name:    SunOS

      Node name:      sppaxdb02

      Release:        5.10

      Version:        Generic_147147-26

      Machine:        sun4v

      Instance name: MVF

      Redo thread mounted by this instance: 1

      Oracle process number: 31

      Unix process pid: 2071, image: oracle@sppaxdb02 (ARC1)

       

       

       

       

      *** 2013-10-15 13:27:44.362

      *** SESSION ID:(311.1) 2013-10-15 13:27:44.362

      *** CLIENT ID:() 2013-10-15 13:27:44.362

      *** SERVICE NAME:() 2013-10-15 13:27:44.362

      *** MODULE NAME:() 2013-10-15 13:27:44.362

      *** ACTION NAME:() 2013-10-15 13:27:44.362

       

       

      Redo shipping client performing standby login

      OCISessionBegin failed. Error -1

      .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges

      '

      OCISessionBegin failed. Error -1

      .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges

      '

      *** 2013-10-15 13:27:44.706 4595 krsu.c

      Logged on to standby successfully

      Client logon and security negotiation successful!

      DDE rules only execution for: ORA 312

       

       

      *** 2014-01-23 10:15:48.476

      ----- START Event Driven Actions Dump ----

      ---- END Event Driven Actions Dump ----

      ----- START DDE Actions Dump -----

      Executing SYNC actions

      ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----

      Successfully dispatched

      ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----

      Executing ASYNC actions

      ----- END DDE Actions Dump (total 0 csec) -----

      ORA-00322: log 13 of thread 1 is not current copy

      ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'

      DDE rules only execution for: ORA 312

       

       

      *** 2014-04-29 08:48:00.534

      ----- START Event Driven Actions Dump ----

      ---- END Event Driven Actions Dump ----

      ----- START DDE Actions Dump -----

      Executing SYNC actions

      ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----

      Successfully dispatched

      ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----

      Executing ASYNC actions

      ----- END DDE Actions Dump (total 0 csec) -----

      ORA-00314: log 13 of thread 1, expected sequence# 52100 doesn't match 52098

      ORA-00312: online log 13 thread 1: '/usr/mvf/data/dbase/redo/redo_stdby13.log'

       

       

      *** 2014-04-29 08:48:01.444

      krsk_srl_purge_abandoned: No longer purgable SRL log 13 B-787868464.T-1.S-52100

       

       

      ORA-16038: log 9 sequence# 20395 cannot be archived

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

      ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'

               1

       

       

      ORA-16038: log 9 sequence# 20467 cannot be archived

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

      ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'

               1

       

       

      MESSAGE_TEXT

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

             CNT

      ----------

       

       

      ORA-16038: log 9 sequence# 20530 cannot be archived

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

      ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'

               1

       

       

      ORA-16038: log 9 sequence# 20665 cannot be archived

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

      ORA-00312: online log 9 thread 1: '/usr/mvf/data/dbase/redo/redo09.log'

       

       

      MESSAGE_TEXT

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

             CNT

      ----------

               1

       

      172 rows selected.