Members   Search   Help    Register    Login   Home
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
Report message to a moderator
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
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member

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

by

Babu
Report message to a moderator
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
Report message to a moderator
Previous Topic:Primary and standby issues
Next Topic:How to create Physical standby database and steps for dataguard
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 03:36:00 CST 2009

Total time taken to generate the page: 0.37642 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.