问题描述:今天做实验把日志文件redo02.log删除,然后把另一个日志组redo02.log复制过来恢复,发现开机报错。
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 641732440 bytes
Database Buffers 419430400 bytes
Redo Buffers 5554176 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5136
Session ID: 1 Serial number: 5
SQL> select open_mode from v$database;
ERROR:
ORA-03114: not connected to ORACLE
开始以为是因为复制过来的日志没有online,打算把他online,但提示not connected to ORACLE
alcer_orcl.log日志如下:
Sun Feb 21 10:28:12 2016
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5148.trc:
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_5148.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/orcl/redo02.log'
Instance terminated by USER, pid = 5136