oracle00312,【Oracle】ORA-00313 ORA-00312问题解决（无备份）

db02:/home/oracle$

export ORACLE_SID=bjltjcpt2

db02:/home/oracle$

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 14 08:07:29 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

startup

ORACLE instance started.

Total System Global Area  922849280 bytes

Fixed Size                  2226816 bytes

Variable Size             864028032 bytes

Database Buffers           50331648 bytes

Redo Buffers                6262784 bytes

Database mounted.

ORA-00313: open failed for members of log group 7 of thread 2

ORA-00312: online log 7 thread 2: '+REDOSSD/bjltjcpt/onlinelog/group_7.log'

ORA-17503: ksfdopn:2 Failed to open file

+REDOSSD/bjltjcpt/onlinelog/group_7.log

ORA-15173: entry 'bjltjcpt' does not exist in directory '/'

SQL> select status from v$instance;

STATUS

------------

MOUNTED

SQL> select group#,thread#,members,status from v$log;

GROUP#    THREAD#    MEMBERS STATUS

---------- ---------- ---------- ----------------

1          1          1 INACTIVE

2          1          1 INACTIVE

3          1          1 INACTIVE

4          1          1 INACTIVE

5          1          1 INACTIVE

6          1          1 CURRENT

7          2          1 CURRENT

8          2          1 INACTIVE

9          2          1 INACTIVE

10          2          1 INACTIVE

11          2          1 INACTIVE

12          2          1 INACTIVE

12 rows selected.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

SQL>

alter database clear logfile group 1;

Database altered.

SQL>

alter database clear logfile group 2;

Database altered.

SQL>

alter database clear logfile group 3;

Database altered.

SQL>

alter database clear logfile group 4;

Database altered.

SQL>

alter database clear logfile group 5;

Database altered.

SQL> alter database clear logfile group 6;

alter database clear logfile group 6

*

ERROR at line 1:

ORA-01624: log 6 needed for crash recovery of instance bjltjcpt1 (thread 1)

ORA-00312: online log 6 thread 1: '+REDOSSD/bjltjcpt/onlinelog/group_6.log'

SQL> alter database clear logfile group 7;

alter database clear logfile group 7

*

ERROR at line 1:

ORA-01624: log 7 needed for crash recovery of instance bjltjcpt2 (thread 2)

ORA-00312: online log 7 thread 2: '+REDOSSD/bjltjcpt/onlinelog/group_7.log'

SQL>

alter database clear logfile group 8;

Database altered.

SQL>

alter database clear logfile group 9;

Database altered.

SQL>

alter database clear logfile group 10;

Database altered.

SQL>

alt