可能是由于不正当重启,我的oracle数据库在重启完之后报错:
ORA-03113 end-of-file on communication channel
尝试了各种方法无果之后,还原数据库到某个时间点:
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
SQL> recover database until time '2016-11-05 12:00:00'
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
重启数据库,OK,问题解决。