发布时间 : 2024/7/12 20:00:15 星期五 文章数据库读写分离解决方案--DG实施方案范文更新完毕开始阅读9cc50586eef9aef8941ea76e58fafab068dc4422

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;