Oracle DataGuard主备库切换

最新推荐文章于 2025-03-17 17:58:34 发布

cuanyanjie8781

最新推荐文章于 2025-03-17 17:58:34 发布

阅读量275

点赞数

文章标签：数据库 shell

.1.1 查看主库状态

SQL> SELECT OPEN_MODE, DATABASE_ROLE, SWITCHOVER_STATUS, FORCE_LOGGING, DATAGUARD_BROKER, GUARD_STATUS FROM V$DATABASE;

1.1.2 切换到备库

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

1.1.3 启动到mount状态

SQL> STARTUP MOUNT

1.2 备库，切换成主库并启动到open

1.2.1 查看备库状态

SQL> SELECT OPEN_MODE, DATABASE_ROLE, SWITCHOVER_STATUS, FORCE_LOGGING, DATAGUARD_BROKER, GUARD_STATUS FROM V$DATABASE;

1.2.2 切换到主库

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

1.2.3 数据库open

SQL> ALTER DATABASE OPEN;

1.3 新的备库启动日志应用

1.3.1 备库mount状态直接启动日志应用

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

1.3.2 备库切换到open状态，启用Real-time query
A physical standby database instance cannot be opened if Redo Apply is active on a mounted instance of that database. Use the following SQL statements to stop Redo Apply, open a standby instance read-only, and restart Redo Apply:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29108856/viewspace-2141153/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29108856/viewspace-2141153/