[oracle@oracle-one RHYS]$ ls -ltr total 4898536 -rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo02.log -rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo01.log -rw-r-----. 1 oracle oinstall 5251072 Aug 27 13:22 users01.dbf -rw-r-----. 1 oracle oinstall 524296192 Aug 27 13:22 arch_tbs01.dbf -rw-r-----. 1 oracle oinstall 209723392 Aug 27 13:22 statspack.dbf -rw-r-----. 1 oracle oinstall 262152192 Aug 27 13:22 undotbs3.dbf -rw-r-----. 1 oracle oinstall 1688215552 Aug 27 13:30 test.dbf -rw-r-----. 1 oracle oinstall 67117056 Aug 27 13:33 temp01.dbf -rw-r-----. 1 oracle oinstall 31465472 Aug 27 13:38 undotbs1.dbf -rw-r-----. 1 oracle oinstall 629153792 Aug 27 13:40 sysaux01.dbf -rw-r-----. 1 oracle oinstall 1457528832 Aug 27 13:40 system01.dbf -rw-r-----. 1 oracle oinstall 9846784 Aug 27 13:40 control01.ctl -rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:40 redo03.log [oracle@oracle-one RHYS]$ mv redo01.log redo01.log_bak [oracle@oracle-one RHYS]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 27 17:15:07 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 405020672 bytes Fixed Size 2213816 bytes Variable Size 260048968 bytes Database Buffers 138412032 bytes Redo Buffers 4345856 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 1935 Session ID: 1 Serial number: 5 SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oracle-one RHYS]$ 查看alert日志如下： Errors in file /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_lgwr_1915.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log' ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_lgwr_1915.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_1935.trc: ORA-00313: open failed for members of log group 1 of thread ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log' USER (ospid: 1935): terminating the instance due to error 313 2013-08-27 17:15:22.637000 +08:00 Instance terminated by USER, pid = 1935 adrci> SQL> startup mount; ORACLE instance started. Total System Global Area 405020672 bytes Fixed Size 2213816 bytes Variable Size 260048968 bytes Database Buffers 138412032 bytes Redo Buffers 4345856 bytes Database mounted. SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --