[oracle@localhost ~]$ sqlplus sys as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 8 09:39:36 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter password: Connected to an idle instance. SQL> startupORACLE instance started. Total System Global Area 1653518336 bytesFixed Size 2213896 bytesVariable Size 973080568 bytesDatabase Buffers 671088640 bytesRedo Buffers 7135232 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 4889Session ID: 1 Serial number: 5 SQL> alter database clear logfile group 2;ERROR:ORA-03114: not connected to ORACLE
SQL> connEnter user-name: sys as sysdbaEnter password:Connected to an idle instance.SQL> alter database clear logfile group 2;alter database clear logfile group 2*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;alter system set "_allow_resetlogs_corruption"=true scope=spfile*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0警報文件節選Errors in file /oracle/oracle/diag/rdbms/test/test/trace/test_m000_4452.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: '/oracle/oracledata/test/redo02.log'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory
Additional information: 3Instance terminated by USER, pid = 4442