Oracle DG常用视图与运维护常用操作

墨墨导读：本文来自墨天轮（www.modb.pro）读者投稿，作者对DG常用视图与运维常用操作进行解读，分享至此，希望对大家有帮助。

1、查看备库状态

SQL> select open_mode,database_role,db_unique_name from v$database;

2、将备库置与应用日志模式状态

SQL> alter database recover managed standby database using current logfile disconnect from session;

3、取消备库的自动恢复

SQL> alter database recover managed standby database cancel;

4、打开实时应用状态模式

SQL> alter database recover managed standby database using current logfile disconnect;

5、查看日志应用到哪个组

SQL> select max(SEQUENCE#) from v$archived_log where applied=‘YES’

6、主库和备库之间角色切换
6.1 主库切换为备库

alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby with session shutdown;-- 主库有会话连接的时候
shutdown immediate
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;

6.2 从库切换为主库

alter database commit to switchover to primary;
shutdown immediate;
startup
alter system switch logfile;

7.备库自动使用主库传过来的日志进行恢复

alter database recover automatic standby database;
<