Home » Server Options » Data Guard » PHYSICAL STANDBY SWITCHOVER PROBLEM (oracle 9i R2, Standard edition, Suse linux)
PHYSICAL STANDBY SWITCHOVER PROBLEM [message #407883] Fri, 12 June 2009 03:30 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Hi friends
We have an Oracle 9i r2 Standard edition database. Since this version does not support Data Guard, I am manually copying the archived log files from production db to the physical standby db.
The log files are applying to the standby db. But when I tried to do a switch over it says the following
startup nomount;
alter database mount standby database;
alter database commit to switchover to primary with session shutdown;
*
ERROR at line 1:
ORA-16139: media recover required


how can I get this proble solved?
Thanks in advance
Re: PHYSICAL STANDBY SWITCHOVER PROBLEM [message #407993 is a reply to message #407883] Fri, 12 June 2009 15:25 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Already standard edition not support dataguard; then why your trying to failover??

by

Babu
Re: PHYSICAL STANDBY SWITCHOVER PROBLEM [message #408036 is a reply to message #407993] Sat, 13 June 2009 03:12 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
I am not using Data Guard features, I am doing the transfer and apply of archived logs manually. The logs are applying properly, but when I tried to swith over to primary this error happens
Saju
Previous Topic: Primary and standby issues
Next Topic: How to create Physical standby database and steps for dataguard
Goto Forum:
  


Current Time: Sat Dec 10 04:57:19 CST 2016

Total time taken to generate the page: 0.08129 seconds