Oracle数据库服务器异常关机,重新启动数据库服务器之后就开始抛异常了,启动数据库报“ORA-03113: end-of-file on communication channel”错误,SQL> startupORACLE instance started.Total System Global Area 1553305600 bytesFixed Size 2213656 bytesVariable Size 1224739048 bytesDatabase Buffers 318767104 bytesRedo Buffers 7585792 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 11126Session ID: 1512 Serial number: 115
工具/原料
sqlplus
方法/步骤
1
连接数据库,启动数据库到mount状态sqlplus / as sysdbasql>startup mount
2
查看日志组状态SQL> select * from v$log;
3
尝试归档日志SQL> alter database open resetlogs 1;
4
使用不完全恢复数据库SQL> alter database open resetlogs;
5
尝试失败之后,恢复数据库到指定时间点SQL> recover database until time '2014-11-16'
6
关闭数据库SQL> shutdown immediate
7
再次启动数据库,发现已经可以正常启动。SQL> startup