Just few thoughts since no one replied.
Your sure didn't miss any standby specific in patchset readme?
You can try to recover standby over this log using normal recovery.
You might want to recreate control file (as normal and try to recover
manually or as standby). Copy over the online log - maybe it got
corrupted.
I would open an SR right away.
On 2/16/07, Patrick Hurley <patrick_at_nominet.org.uk> wrote:
> Hello,
>
> The subject says it all after applying 10.2.0.3 patchset the standby will
> not perform managed recovery.
>
> Upgraded with the following steps:
>
> 1. shutdown standby
>
> 2. upgraded oracle software on standby
>
> 3. shutdown primary
>
> 4. upgraded oracle software on primary
>
> 5. ran catupgrd.sql on primary
>
> 6. ran utlrp.sql on primary
>
> 7. opened primary
>
> 8. opened standby mount
>
> 9. tried to start managed recovery - failed ORA-00328
>
> 10. switched archive logs on primary a couple of times
>
> 11. tried to start managed recovery - failed ORA-00328
>
> exact error message is:
>
> ORA-00328: archived log ends at change 863136893, need later change
> 863139334
> ORA-00334: archived log:
> '/var/opt/oracle/LNUXNOM/arch/arch_2_124_596622143.arc'
> Thu Feb 15 13:30:54 2007
>
> Managed Standby Recovery not using Real Time Apply
>
> Recovery interrupted!
> Thu Feb 15 13:30:57 2007
> SUCCESS: diskgroup DATA4 was dismounted
> Thu Feb 15 13:30:57 2007
> Errors in file /opt/oracle/product/admin/NOM/bdump/lnuxnom1_mrp0_9296.trc:
> ORA-00328: archived log ends at change 863136893, need later change
> 863139334
> ORA-00334: archived log:
> '/var/opt/oracle/LNUXNOM/arch/arch_2_124_596622143.arc'
> Thu Feb 15 13:30:57 2007
> MRP0: Background Media Recovery process shutdown (LNUXNOM1)
>
> Maybe we've been foolish, can anyone explain what we should have done or
> what we can do to fix my standby? - creating a standby controlfile from
> primary is possibly the way to go.
>
> Thanks
>
> Patrick Hurley
> Nominet
> http://blog.nominet.org.uk/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Best regards,
Alex Gorbachev
http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 17 2007 - 12:48:17 CST
