[实验]Data Guard Fail Switch

环境:
VMWARE
      OS:CentOS 5.3
      Primary:Oracle 10.2.0.1.0
      Standby:Oracle 10.2.0.1.0
 
Fail Over Switch 切换过程:
1由于primary database控制文件丢失导致主库无法启动。
2在standby database上执行to primary 的切换。
3SQL CODE:
sqlplus / as sysdba;
alter database recover managed standby database finish force;
alter database commit to switchover to primary;
alter database open; -- 出现如下错误:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
直接shutdown ,然后startup即可
shutdown 后应马上进行全库备份,然后再startup

posted on 2009-04-20 13:42  afant  阅读(254)  评论(0编辑  收藏  举报

导航