ORA-03113: end-of-file on communication channel
来源:互联网 发布:prod.env.js 编辑:程序博客网 时间:2024/05/16 05:27
SQL> startup
ORACLE instance started.
Total System Global Area 1252663296 bytes
Fixed Size 2227944 bytes
Variable Size 704643352 bytes
Database Buffers 536870912 bytes
Redo Buffers 8921088 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 8117
Session ID: 191 Serial number: 3
网上分析,可能由于昨晚数据库强制关闭,导致文件状态可能不一致,因为正常关闭数据库会同步校验各文件,使得重新启动的时候文件时间点一致。解决方案如下
启动DB
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
直接reset不成功
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
1 1 112 52428800 512 1 NO
INACTIVE 3826382 16-JUL-13 3857158 17-JUL-13
3 1 114 52428800 512 1 NO
CURRENT 3886899 17-JUL-13 2.8147E+14
2 1 113 52428800 512 1 NO
INACTIVE 3857158 17-JUL-13 3886899 17-JUL-13
SQL> alter database open resetlogs 2;
alter database open resetlogs 2
*
ERROR at line 1:
ORA-02288: invalid OPEN mode
恢复数据库
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until time '2013-07-05'
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
成功。
0 0
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- 遇到ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113 end-of-file on communication channel 问题解决
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113end-of-file on communication channel解决
- ORA-03113: end-of-file on communication channel 解决方法
- ORA-03113: end-of-file on communication channel解决方法
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- Struts2学习-4(补充之CDATA)
- STM32学习--定时器功能差异
- Android ToolFor9Ge-关于图片和控件的工具类
- c#学习笔记之七 如何用FileStream对象读取一个文本
- C语言编程之数据库 -- sqlite3
- ORA-03113: end-of-file on communication channel
- python 发送邮件,支持邮件内容定义
- 广度遍历与深度遍历
- data, size, elemSize, step, depth in Mat class
- 是否同一棵二叉搜索树
- HDU 5950 Recursive sequence(矩阵快速幂)
- Android IntentService用法
- QT开发环境搭建
- PAT A 1001