备份与恢复

ORA-03113: 通信通道的文件结尾

时间:2014-7-13 17:26:19  作者:solgle  来源:www.solgle.com  查看:1823  评论:0
内容摘要:重启linux服务器后,启动数据库报错,报ORA-03113错误,启动监听lsnrctl start连接到数据库C:\Users\user>sqlplus...
重启linux服务器后,启动数据库报错,报ORA-03113错误,估计又是数据块损坏,但这里因为有日志,所以采用恢复来解决
本文出自:http://www.solgle.com/news/?139.html
 
---启动监听lsnrctl start连接到数据库
C:\Users\user>sqlplus sys/**********@os_orcl as sysdba;
 
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 28 16:38:42 2014
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             838864872 bytes
Database Buffers          402653184 bytes
Redo Buffers                8892416 bytes
Database mounted.
ORA-03113: 通信通道的文件结尾
进程 ID: 2281
会话 ID: 18 序列号: 37
 
SQL>exit
...
 
C:\Users\user>sqlplus sys/**********@os_orcl as sysdba;
 
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 28 16:38:42 2014
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup mount;
ORACLE instance started.
 
Total System Global Area 1252663296 bytes
Fixed Size                  2252824 bytes
Variable Size             838864872 bytes
Database Buffers          402653184 bytes
Redo Buffers                8892416 bytes
Database mounted.
SQL> exit
 
 
--恢复数据库
C:\Users\user>rman target=sys/**********@os_orcl nocatalog;
 
恢复管理器: Release 11.2.0.1.0 - Production on 星期日 9月 28 16:39:49 2014
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
已连接到目标数据库: orcl (DBID=1370340464, 未打开)
使用目标数据库控制文件替代恢复目录
 
RMAN> recover database;
 
启动 recover 于 28-9月 -14
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=1 设备类型=DISK
 
正在开始介质的恢复
介质恢复完成, 用时: 00:00:00
 
完成 recover 于 28-9月 -14
 
RMAN> alter database open;
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: alter db 命令 (在 09/28/2014 16:38:28 上) 失败
ORA-03113: 通信通道的文件结尾
进程 ID: 2281
会话 ID: 18 序列号: 37
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: 未连接到 ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: alter db 命令 (在 09/28/2014 16:38:28 上) 失败
ORA-03113: 通信通道的文件结尾
进程 ID: 2281
会话 ID: 18 序列号: 37
 
---尝试不完全恢复
RMAN> recover database until time "to_date('2014-09-28 16:30:00','yyyy-mm-dd 
 
hh24:mi:ss')";
 
启动 recover 于 28-9月 -14
使用通道 ORA_DISK_1
 
正在开始介质的恢复
介质恢复完成, 用时: 00:00:00
 
完成 recover 于 28-9月 -14
 
RMAN> alter database open resetlogs;
 
数据库已打开
 
RMAN> exit
 
 
恢复管理器完成。
 
success...

 
标签:ORA-03113 通信通道的文件结尾 

solgle.com 版权所有,欢迎分享!!!

相关文章
    相关评论
       Copyright © 2013-2020 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
    Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1