Home » Server Options » Data Guard » switch over failure (10.2.0.3)
switch over failure [message #399334] Tue, 21 April 2009 11:58
hianyzikvalaki
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
startup

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?

Regards,

hnyvk

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


Current Time: Sun Dec 11 04:02:16 CST 2016

Total time taken to generate the page: 0.09403 seconds