dg常用指令

太过爱你忘了你带给我的痛 2022-02-19 06:49 172阅读 0赞

启动备用数据库  
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;