Switchover的步骤

设abc为primary，xyz为physical standby

on abc:

SQL>alter database commit to switchover to physical standby;

SQL>shutdown immediate;

on xyz:

SQL>alter database commit to switchover to primary;

SQL>shutdown immediate;

on abc:

SQL>startup nomount;

SQL>alter database mount standby database;

SQL>recover managed standby database disconnect;第一次启动的话就使用archive文件来apply吧，后面再using current logfile disconnect

on xyz:

SQL>startup

这时候身为新备机的abc上面的v$database信息可能还没有来得及更新，需要xyz上面执行一下alter system switch logfile来进行一下同步。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/473120/viewspace-910413/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/473120/viewspace-910413/