This discussion is archived
3 Replies Latest reply: Nov 26, 2012 2:17 AM by DB RSS

challenge in Production DB and DR

DB Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points