数据库读写分离解决方案--DG实施方案范文

Oracle Data Guard实施方案

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Step 9 Open the new primary database. SQL> ALTER DATABASE OPEN;

Step 10 Back up the new primary database.

Oracle recommends that a full backup be taken of the new primary database.

Step 11 Restart Redo Apply if it has stopped at any of the other physical standby databases in your Data Guard configuration. For example:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE - > DISCONNECT FROM SESSION; 附：

1. 启动到管理模式

SQL>shutdown immediate; SQL>startup nomount;

SQL>alter database mount standby database;

SQL>alter database recover managed standby database disconnect from session; 2.启动到只读方式

SQL>shutdown immediate; SQL>startup nomount;

SQL>alter database mount standby database; SQL>alter database open read only; 3如果在管理恢复模式下到只读模式

SQL> recover managed standby database cancel; SQL> alter database open read only;