Physical Standby Error ORA-00328: archived log ends at change,ORA-00334:
695680Jun 26 2009 — edited Jul 19 2011Hi,
Product: EBS 12.0.4
Database: 10g R2
Plateform: RHEL AS 4.6
I have changed the role of Physical Standby database to "Primary" Now the New Primary is ok. On the new Physical Standby (which was primary) logs are shipping but when I try to mount and put it in Recovery mode, it is not doing the recovery.
sql>startup mount;
sql>alter database recover managed standby using current logfile disconnect from session;
error is attached here
*** SERVICE NAME:() 2009-06-26 11:13:25.909
*** SESSION ID:(383.1) 2009-06-26 11:13:25.909
ARCH: Connecting to console port...
*** 2009-06-26 11:13:25.909 60639 kcrr.c
MRP0: Background Managed Standby Recovery process started
*** 2009-06-26 11:13:30.909 1018 krsm.c
Managed Recovery: Initialization posted.
*** 2009-06-26 11:13:30.910 60639 kcrr.c
Managed Standby Recovery not using Real Time Apply
Recovery target incarnation = 2, activation ID = 0
Influx buffer limit = 36427 (50% x 72854)
Successfully allocated 7 recovery slaves
Using 156 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 5965569654754 logseq 50 block 5727
*** 2009-06-26 11:13:32.521
Media Recovery add redo thread 1
*** 2009-06-26 11:13:32.522 1018 krsm.c
Managed Recovery: Active posted.
*** 2009-06-26 11:13:32.532
Media Recovery Log /orahome/flash_recovery_area/UAT1/archivelog/1_50_688834451.dbf
*** 2009-06-26 11:13:32.536 60639 kcrr.c
MRP0: Background Media Recovery terminated with error 328
ORA-00328: archived log ends at change 5965569564452, need later change 5965569654754
ORA-00334: archived log: '/orahome/flash_recovery_area/UAT1/archivelog/1_50_688834451.dbf'
*** 2009-06-26 11:13:32.536
Media Recovery drop redo thread 1
*** 2009-06-26 11:13:33.826 1018 krsm.c
Managed Recovery: Not Active posted.
ORA-00328: archived log ends at change 5965569564452, need later change 5965569654754
ORA-00334: archived log: '/orahome/flash_recovery_area/UAT1/archivelog/1_50_688834451.dbf'
ARCH: Connecting to console port...
*** 2009-06-26 11:13:33.828 60639 kcrr.c
MRP0: Background Media Recovery process shutdown
*** 2009-06-26 11:13:33.828 1018 krsm.c
Can anyone help me how to resolve it?
Regards,
pzdba