|switch over failure [message #399334]
||Tue, 21 April 2009 11:58
Registered: April 2009
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;
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;
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?