墨墨导读:本文来自墨天轮(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 logfil