Oracle dg 状态校验
2024-10-16 00:00:42
查看主库状态:
select open_mode,protection_mode,database_role,switchover_status from v$database; OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
-------------------- ----------------------------- ------------------------ ------------------------
READ WRITE MAXIMUM PERFORMANCE PRIMARY TO STANDBY 查看备库状态:
select open_mode,protection_mode,database_role,switchover_status from v$database; OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------------------- ----------------------------- ------------------------ ------------------------
READ ONLY WITH APPLY MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED 检查主备两边的序号
select max(sequence#) from v$log; 备库执行,查看是否有数据未应用
select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#; select SEQUENCE#,FIRST_TIME,NEXT_TIME ,APPLIED from v$archived_log order by 1;
最新文章
- JavaScript中Array类型方法总结
- gridview自定义排序
- grunt-replace和grunt-include-replace问题
- android 通知栏 notifcation
- easyui datagrid使用(好)
- 数列 COGS1048:[Citric S2] 一道防AK好题
- 1.进入debug模式(基础知识列表)
- Python3学习之一环境搭建
- Findbugs初探-使用idea获取findbugs插件
- Windows7 32位机上,OpenCV中配置GPU操作步骤
- iOS KVO &; KVC
- 还是回文(dp)
- Spring + Spring MVC + Hibernate项目开发集成(注解)
- WPF 杂谈——自定义控件
- Linux 文件API
- RPC框架学习总结
- 基于Python的多线程模块Threading小结
- python接口自动化测试十一:传参数:data与json
- Spring Security ——AuthenticationProvider
- Redis---Hash(字典)
热门文章
- c++内存分布之虚函数(单一继承)
- 【LeetCode】951. Flip Equivalent Binary Trees 解题报告(Python)
- DP? (hdu3944)
- CSS实现鼠标移入时图片的放大效果以及缓慢过渡
- Feign动态调用,结合Ribbon
- Reproducing Kernel Hilbert Space (RKHS)
- CapstoneCS5265|TYPEC转HDMI 4K60HZ转换方案设计|CS5265功能介绍
- 编写Java程序,利用List维护用户信息
- 大厂必问的Spring面试题
- Hadoop Jobhistory配置启用