ORA-01093错误解决
来源:互联网 发布:淘宝怎么激活支付宝 编辑:程序博客网 时间:2024/04/30 00:00
环境是RAC+RAC的DG的10.2.0.5环境
当时是把主备库打开,想启动MRP进程(实时应用),但是执行语句时出现1093错误:
SQL> alter database recover managed standby database ;
alter database recover managed standby database
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
SQL> !oerr ora 1093
01093, 00000, "ALTER DATABASE CLOSE only permitted with no sessions connected"
// *Cause: There is at least one more session other than the current one
// logged into the instance. ALTER DATABASE CLOSE is not permitted.
// *Action: Find the other sessions and log them out and resubmit the command
上面说的很清楚:原因是多于一个的会话连接当前数据库实例。ALTER DATABASE CLOSE is not permitted;
解决办法是退出该会话;
字面意思没有很懂,当我查看主备库状态时发现备库处于只读状态:
SQL> select open_mode from gv$database;
OPEN_MODE
----------
READ ONLY
READ ONLY
哎,粗心误大事啊,启动实时应用备库需要在mount状态下的;
解决办法是,把备库启动到mount状态下,再执行:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 1273516 bytes
Variable Size 96469332 bytes
Database Buffers 226492416 bytes
Redo Buffers 2920448 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
ok,问题解决,其实就是要注意启用MRP,备库要处于MOUNT状态下进行
(注意:Oracle 10g,要在mount状态下,才能开启MRP。然而11g在open就可以)
- ORA-01093错误解决
- ORA-04091错误解决
- ora-14404错误解决
- ORA-00381 错误解决
- ORA-00257 错误解决
- ORA-27125错误解决
- 解决ORA-00020错误
- 解决ORA-01031错误
- ORA-01407 错误解决
- ORA-1555错误解决
- 解决ORA-00020错误 .
- 解决ORA-01779错误
- ora-01207错误解决
- ORA-16038错误解决
- ORA-3136 错误解决
- ORA-12560 错误解决
- ORA-16038错误解决
- ORA-1200错误解决
- Java学习--多线程中使用匿名类
- 守护进程及实现
- js 控制div 横向 纵向 移动
- 黑马程序员_银行业务调度系统
- 迷你开源运维系统--欢庆世界杯!!
- ORA-01093错误解决
- Java内存管理
- php之单例模式
- Java并发编程 基础概念
- Junit4新断言 assertThat
- 后台“待回复询盘”提醒功能实现
- 推荐命门&运营商的数据质量高
- iOS————使用NSdate获取播放时间
- android adb 命令发送 keyevent