ORA-03113: end-of-file on communication channel

来源:互联网 发布:java asm demo 编辑:程序博客网 时间:2024/04/27 15:00
SQL> conn / as sysdba
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

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> recover database until time '2013-07-05'
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

0 0