Re: ORA-00328 on Standby after 10.2.0.2 -> 10.2.0.3 upgrade
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: patrick@xxxxxxxxxxxxxx
- Date: Sat, 17 Feb 2007 13:48:17 -0500
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@xxxxxxxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
--
Best regards,
Alex Gorbachev
http://www.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
