日志不得应用情况切换强制standby改变状态为primary
日志不得应用情况切换备库为主库
备库运行如下:
alter database recover managed standby database disconnect from session;
alter database commit to switchover to primary
日志反应如下:
Maximum wait for role transition is 15 minutes.
2016-09-07 12:57:20.653000 +08:00
Switchover: Media recovery is still active
Database not available for switchover
End-Of-REDO archived log file has not been recovered
Database not available for switchover
End-Of-REDO archived log file has not been recovered
2016-09-07 12:57:22.681000 +08:00
Database not available for switchover
End-Of-REDO archived log file has not been recovered
Database not available for switchover
End-Of-REDO archived log file has not been recovered
下面将STANDBY数据库切换为PRIMARY数据库:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
或
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
SELECT DATABASE_ROLE FROM V$DATABASE;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
这样备库可切换成primary 了
https://blog.csdn.net/u010719917/article/details/52458546
最新文章
- Android自动化学习笔记之MonkeyRunner:官方介绍和简单实例
- HTML基础—插曲
- MySql指令集
- linux的cgroup控制
- php 调用 java 接口
- NTP服务器地址及IP
- windows实用技巧
- 1195: [HNOI2006]最短母串 - BZOJ
- Linux Shell脚本之自动修改IP
- 【POJ2773】Happy 2006 欧几里德
- [WPF疑难]避免窗口最大化时遮盖任务栏
- JavaScript(5)——DOM
- linux文件权限查看及修改-chmod ------入门的一些常识
- Python基础:七、注释
- linux下使用nmon工具对服务器性能进行检测
- centos7下安装docker(17.3docker监控---cAdvisor)
- AJAX跨域问题以及解决思路(更新中)
- 构建一个Vue项目
- Redis-五种数据类型解析
- 编译的java工程压缩上传到linux服务器上后,中文的类名显示乱码