ORA-00328 on Standby after 10.2.0.2 -> 10.2.0.3 upgrade

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