ORA-16456: switchover to standby in progress or completed
来源:互联网 发布:sql二进制数据 计算符 编辑:程序博客网 时间:2024/05/29 17:25
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
Database altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
*
ERROR at line 1:
ORA-16456: switchover to standby in progress or completed
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
Database altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
*
ERROR at line 1:
ORA-16456: switchover to standby in progress or completed
备库必须mount状态下,主库open状态
查看备库是
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
阅读全文
0 0
- ORA-16456: switchover to standby in progress or completed
- Switchover to a Physical Standby Database
- 解决ORA-01033: ORACLE initialization or shutdown in progress错误
- 解决ORA-01033: ORACLE initialization or shutdown in progress错误
- ORA-01033: ORACLE initialization or shutdown in progress
- ORA-01033: ORACLE initialization or shutdown in progress 解决办法
- ora-01033:oracle initializationg or shutdown in progress
- ORA-01033: ORACLE initialization or shutdown in progress
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ORA-01033:ORACLE initialization or shutdown in progress错误解决
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ORA-01033: ORACLE initialization or shutdown in progress
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ERROR: ORA-01033: ORACLE initialization or shutdown in progress
- 解决ORA-01033: ORACLE initialization or shutdown in progress错误
- oracle ora-01033:oracle initialization or shutdown in progress问题解决
- ORA-01033: ORACLE initialization or shutdown in progress的解决办法!
- ora-01033:oracle initialization or shutdown in progress 解决方法
- 复现deep compression 的实验
- java数据类型
- 第五周 建立顺序栈算法库
- java知识体系结构图
- MySQL中information_schema
- ORA-16456: switchover to standby in progress or completed
- 开机或解锁屏幕时进入APP,以及屏幕锁屏
- C 语言学习笔记(七)——文件操作(2)
- 第7周【项目4
- 深度学习框架tensorflow环境搭建
- 寄存器的装载和存储
- SSM+maven项目配置文件详解(一)
- 第七周项目四
- repo+git搭建