3 Replies Latest reply: Nov 26, 2012 4:17 AM by DB RSS

    challenge in Production DB and DR

    DB
      Dear All,

      I had an challenge in Production DB. 7941 archive log generates before 7940 archive log.

      -rw-r-----   1 oracle     dba        52427776 Nov 11 14:22 archive-ovsd_1_7939.arc
      -rw-r-----   1 oracle     dba        52423680 Nov 11 19:52 archive-ovsd_1_7941.arc
      -rw-r-----   1 oracle     dba        52427776 Nov 11 22:11 archive-ovsd_1_7942.arc
      -rw-r-----   1 oracle     dba        52427776 Nov 12 01:37 archive-ovsd_1_7943.arc
      -rw-r-----   1 oracle     dba        52427776 Nov 12 05:59 archive-ovsd_1_7944.arc
      -rw-r-----   1 oracle     dba        52424704 Nov 12 09:22 archive-ovsd_1_7945.arc
      -rw-r-----   1 oracle     dba        47120384 Nov 12 09:49 archive-ovsd_1_7940.arc
      -rw-r-----   1 oracle     dba        52427776 Nov 12 12:06 archive-ovsd_1_7946.arc
      And also this particular 7940 archive log couldn't apply to the standby both manually and automatically.

      while apply manually it shows the following error:
       Wed Nov 14 11:51:29 2012
      Errors in file /oracle/admin/ovsd/bdump/ovsd_mrp0_29061.trc:
      ORA-00332: archived log is too small - may be incompletely archived
      ORA-00334: archived log: '/archive/standby/ovsd/archive-ovsd_1_7940.arc'
      MRP0: Background Media Recovery terminated with error 332
      Wed Nov 14 11:51:29 2012
      Errors in file /oracle/admin/ovsd/bdump/ovsd_mrp0_29061.trc:
      ORA-00332: archived log is too small - may be incompletely archived
      ORA-00334: archived log: '/archive/standby/ovsd/archive-ovsd_1_7940.arc'
      Recovery interrupted. 
      and also trace file attached
      /oracle/admin/ovsd/bdump/ovsd_mrp0_29061.trc
      Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
      With the Partitioning, OLAP and Oracle Data Mining options
      JServer Release 9.2.0.6.0 - Production
      ORACLE_HOME = /oracle/product/9.2.0
      System name:    HP-UX
      Node name:      drsrv1
      Release:        B.11.11
      Version:        U
      Machine:        9000/800
      Instance name: ovsd
      Redo thread mounted by this instance: 1
      Oracle process number: 15
      Unix process pid: 29061, image: oracle@drsrv1 (MRP0)
      
      *** SESSION ID:(16.1454) 2012-11-14 11:51:23.916
      Background Managed Standby Recovery process started
      Start recovery at thread 1 ckpt scn 666576282 logseq 7940 block 2
      *** 2012-11-14 11:51:29.253
      Managed Recovery: Active posted.
      *** 2012-11-14 11:51:29.274
      Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7940.arc
      ORA-00332: archived log is too small - may be incompletely archived
      ORA-00334: archived log: '/archive/standby/ovsd/archive-ovsd_1_7940.arc'
      Background Media Recovery terminated with error 332
      ORA-00332: archived log is too small - may be incompletely archived
      ORA-00334: archived log: '/archive/standby/ovsd/archive-ovsd_1_7940.arc'
      *** 2012-11-14 11:51:29.285
      Managed Recovery: Not Active posted.
      Background Media Recovery process shutdown
      *** 2012-11-14 11:51:29.286
      Please help me how to solve.

      Thanking you,

      Regards,
      DB

      Edited by: DB on Nov 15, 2012 10:02 AM