| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
