Home » Server Options » Data Guard » switch over failure (
switch over failure [message #399334] Tue, 21 April 2009 11:58
Messages: 1
Registered: April 2009
Junior Member
Hi Guys,

I have a problem.

At this time i have primary (live) db and a standby (standby) db

I can switch over the pimary to the standby and the standby to primary with this way:

On primary DB:

alter database commit switchover to standby with session shutdown;
shutdown immediate;
startup mount
recover managed standby database disconnect from session;

And on standby DB:

alter database recover standby managed standby database cancel;
alter databse commit to switchover tp primary with session shutdown;
shutdown immediate

Everything is working (logshipping and all)

But if i want to switch back that the old primary will be again the new primari, i can't.

I uploaded what get i back from sql when i check the dataguard status

Anybody has any ideas?



Previous Topic: problem in switchover
Next Topic: Oracle replication system
Goto Forum:

Current Time: Wed Oct 26 12:26:19 CDT 2016

Total time taken to generate the page: 0.13521 seconds