oracle dataguard switchover,[ORACLE DATAGUARD] switchover的过程

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS

--------------------

TO STANDBY

2.将主库设置为standby role

alter database commit to switchover to physical standby;

shutdown immediate;

startup mount;

3.将standby转为primary

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;

NAME  DB_UNIQUE_NAME OPEN_MODE      DATABASE_ROLE

--------- ------------------------------ -------------------- ----------------

ORCL  sty MOUNTED      PHYSICAL STANDBY

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

alter database commit to switchover to primary;

alter database open;

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;

NAME  DB_UNIQUE_NAME OPEN_MODE      DATABASE_ROLE

--------- ------------------------------ -------------------- ----------------

ORCL  sty READ WRITE      PRIMARY

4.原来的primary库上执行：

alter database recover managed standby database disconnect from session;

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;

NAME  DB_UNIQUE_NAME OPEN_MODE      DATABASE_ROLE

--------- ------------------------------ -------------------- ----------------

ORCL  pri MOUNTED      PHYSICAL STANDBY

本文出自 “三国冷笑话” 博客，请务必保留此出处http://myhwj.blog.51cto.com/9763975/1789388

[ORACLE DATAGUARD] switchover的过程

标签：dataguard   switchover

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://myhwj.blog.51cto.com/9763975/1789388