dg常用指令

启动备用数据库
SQL> STARTUP NOMOUNT;
SQL> Alter DATABASE MOUNT STANDBY DATABASE;
SQL> Alter DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

关闭备用数据库
SQL> Alter DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> SHUTDOWN IMMEDIATE;

主备数据库切换
正常切换：（即主备服务器均可用的情况下，需维护主服务器的情况下）：
主服务器：
SQL> alter database commit to switchover to physical standby;
SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
SQL> Alter DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

备用服务器：
SQL> alter database commit to switchover to primary;
SQL> shutdown immediate;
SQL> startup

非正常切换：（即主服务器宕机的情况）：
备用服务器：
SQL> Alter DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
SQL> Alter DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

启动redo应用
SQL> alter database recover managed standby database disconnect from session;
数据库已更改。

暂停应用
通过下列语句暂停redo应用。
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
数据库已更改。

启动redo real-time apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

standby数据库启动到管理恢复模式：
shutdown immediate;
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect session;

standby数据库启动到只读模式
shutdown immediate;
startup nomount;
alter database mount standby database;
alter database open read only;

standby数据库从管理模式切换到只读模式
recover managed standby database cancel;
alter database open read only;

standby从只读模式切换到管理恢复模式：
recover managed standby database disconnect session;