ORACLE DG 操作

DG启动

SQL> STARTUP MOUNT;

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  DISCONNECT FROM SESSION;

或（一般我用这个）

SQL > STARTUP;

SQL>recover managed standby database using current logfile disconnect;

DG关闭

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL>SHUTDOWN IMMEDIATE;

---

主备切换

---

• PRI切换为DG

 alter database commit to switchover to physical standby;

主库有会话连接的时候

alter database commit to switchover to physical standby with session shutdown;

shutdown immediate

startup nomount

alter database mount standby database;

alter database recover managed standby database disconnect from session;

• DG切换为PRI

alter database commit to switchover to primary;

shutdown immediate; 

startup

alter system switch logfile;

• DG打开只读实时应用模式

alter database recover managed standby database cancel; 

alter database open;

alter database recover managed standby database using current logfile disconnect;

• 检查切换状态

select open_mode,database_role,db_unique_name from v$database;