【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> alter database clear logfile group 11;
Database altered.
SQL> alter database clear logfile group 12;
Database altered.
SQL> select group#,thread#,members,status from v$log;
GROUP# THREAD# MEMBERS STATUS
---------- ---------- ---------- ----------------
1 1 1 UNUSED
2 1 1 UNUSED
3 1 1 UNUSED
4 1 1 UNUSED
5 1 1 UNUSED
6 1 1 CURRENT
7 2 1 CURRENT
8 2 1 UNUSED
9 2 1 UNUSED
10 2 1 UNUSED
11 2 1 UNUSED
12 2 1 UNUSED
12 rows selected.
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database clear unarchived logfile group 6;
alter database clear unarchived 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 open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SQL> shutown immediate
SP2-0734: unknown command beginning "shutown im..." - rest of line ignored.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
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 'group_7.log' does not exist in directory 'onlinelog'
SQL>
recover database until cancel;
ORA-00279: change 14966658777392 generated at 11/10/2016 02:30:11 needed for thread 1
ORA-00289: suggestion : +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-00280: change 14966658777392 for thread 1 is in sequence #816
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '+FRA/bjltjcpt/archive_log/1_816_925645456.dbf'
ORA-17503: ksfdopn:2 Failed to open file +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-15173: entry '1_816_925645456.dbf' does not exist in directory 'archive_log'
ORA-00308: cannot open archived log '+FRA/bjltjcpt/archive_log/1_816_925645456.dbf'
ORA-17503: ksfdopn:2 Failed to open file +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-15173: entry '1_816_925645456.dbf' does not exist in directory 'archive_log'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/bjltjcpt/datafile/system.510.925642071'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/bjltjcpt/datafile/system.510.925642071'
SQL> arhchive log list;
SP2-0734: unknown command beginning "arhchive l..." - rest of line ignored.
SQL> archivelog list;
SP2-0734: unknown command beginning "archivelog..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/bjltjcpt/archive_log
Oldest online log sequence 871
Next log sequence to archive 871
Current log sequence 871
SQL>
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> alter system set "_allow_terminal_recovery_corruption"=true scope=spfile;
System altered.
SQL> shutdown abort
ORACLE instance shut down.
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 'group_7.log' does not exist in directory 'onlinelog'
SQL>
recover database until cancel;
ORA-00279: change 14966658777392 generated at 11/10/2016 02:30:11 needed for thread 1
ORA-00289: suggestion : +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-00280: change 14966658777392 for thread 1 is in sequence #816
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '+FRA/bjltjcpt/archive_log/1_816_925645456.dbf'
ORA-17503: ksfdopn:2 Failed to open file +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-15173: entry '1_816_925645456.dbf' does not exist in directory 'archive_log'
ORA-00308: cannot open archived log '+FRA/bjltjcpt/archive_log/1_816_925645456.dbf'
ORA-17503: ksfdopn:2 Failed to open file +FRA/bjltjcpt/archive_log/1_816_925645456.dbf
ORA-15173: entry '1_816_925645456.dbf' does not exist in directory 'archive_log'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/bjltjcpt/datafile/system.510.925642071'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [kclchkblk_4], [3484], [2992720189], [3484], [2992718134], [], [], [], [], [], [], []
Process ID: 11468884
Session ID: 432 Serial number: 3
SQL>
startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
db01:/u01/app/oracle/product/11.2.0/db_1/dbs$sqlplus / as sysdba
db01:/u01/app/oracle/product/11.2.0/db_1/dbs$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 14 14:44:20 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.
Database opened.
SQL>
set pages 200 lines 200
SQL>
select group#,thread#,members,archived,status from v$log;
GROUP# THREAD# MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
1 1 1 YES INACTIVE
2 1 1 NO CURRENT
3 1 1 YES UNUSED
4 1 1 YES UNUSED
5 1 1 YES UNUSED
6 1 1 YES UNUSED
7 2 1 YES INACTIVE
8 2 1 YES UNUSED
9 2 1 YES UNUSED
10 2 1 YES UNUSED
11 2 1 YES UNUSED
12 2 1 YES UNUSED
12 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select group#,thread#,members,archived,status from v$log;
GROUP# THREAD# MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
1 1 1 YES ACTIVE
2 1 1 YES ACTIVE
3 1 1 YES ACTIVE
4 1 1 YES ACTIVE
5 1 1 NO CURRENT
6 1 1 YES INACTIVE
7 2 1 YES INACTIVE
8 2 1 YES ACTIVE
9 2 1 NO CURRENT
10 2 1 YES UNUSED
11 2 1 YES UNUSED
12 2 1 YES UNUSED
12 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select group#,thread#,members,archived,status from v$log;
GROUP# THREAD# MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
1 1 1 YES INACTIVE
2 1 1 YES INACTIVE
3 1 1 NO CURRENT
4 1 1 YES INACTIVE
5 1 1 YES INACTIVE
6 1 1 YES INACTIVE
7 2 1 YES INACTIVE
8 2 1 YES ACTIVE
9 2 1 YES ACTIVE
10 2 1 NO CURRENT
11 2 1 YES UNUSED
12 2 1 YES UNUSED
12 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select group#,thread#,members,archived,status from v$log;
GROUP# THREAD# MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
1 1 1 NO CURRENT
2 1 1 YES INACTIVE
3 1 1 YES ACTIVE
4 1 1 YES ACTIVE
5 1 1 YES ACTIVE
6 1 1 YES ACTIVE
7 2 1 YES INACTIVE
8 2 1 YES ACTIVE
9 2 1 YES ACTIVE
10 2 1 YES ACTIVE
11 2 1 NO CURRENT
12 2 1 YES UNUSED
12 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select group#,thread#,members,archived,status from v$log;
GROUP# THREAD# MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
1 1 1 YES INACTIVE
2 1 1 YES INACTIVE
3 1 1 YES INACTIVE
4 1 1 YES INACTIVE
5 1 1 NO CURRENT
6 1 1 YES INACTIVE
7 2 1 YES INACTIVE
8 2 1 YES ACTIVE
9 2 1 YES ACTIVE
10 2 1 YES ACTIVE
11 2 1 YES ACTIVE
12 2 1 NO CURRENT
12 rows selected.
資料庫恢復成功後，建議邏輯備份全庫或者匯出重要資料，重建資料庫進行恢復還原。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30327022/viewspace-2128579/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle EXPDP自動備份緩慢問題解決Oracle
- oracle relog損壞！ORA-00313 ORA-00312Oracle
- TSM + Oracle備份出現問題Oracle
- TSM無法備份故障解決（續）
- 解決linux crontab備份mysql失敗的問題LinuxMySql
- nbu恢復oracle，使用與源備份端不同使用者問題解決Oracle
- Oracle rman 備份與恢復 臨時表空間的檔案問題解決Oracle
- 解決ORACLE無法啟動安裝的問題Oracle
- netbakcup備份時遇到 status 59: access to the client was not allowed 問題解決client
- Oracle RMAN 備份控制檔案報錯問題Oracle
- Oracle備份和恢復常見問題解答Oracle
- oracle備份出了問題，請教大俠看看！！！Oracle
- TSM備份時提示認證失敗(Authentication failure)問題的解決AI
- 解決一次RMAN遲遲不能開始備份的問題
- gmail無法訪問問題解決--FGWAI
- Oracle 解決鎖表問題Oracle
- oracle 鎖問題的解決Oracle
- 終於解決了《====》記一次mysql熱備份xtrabackup（沒有解決問題）MySql
- Oracle 解決like中無法匹配下劃線的問題Oracle
- Oracle資料庫備份、災備的23個常見問題Oracle資料庫
- rman 備份中ORA-19809、ORA-19804問題解決
- 解決無法使用VI的問題
- 解決ASM無法啟動問題ASM
- SaaS無法解決“關鍵”問題
- ORA-00313, ORA-00312, ORA-27037 in Standby DatabaseDatabase
- 解決「問題」，不要解決問題
- 解決Oracle序列跳號問題Oracle
- JDBC Oracle executeUpdate 卡死問題解決JDBCOracle
- 解決問題oracle學習篇Oracle
- 解決oracle中not like效率問題Oracle
- oracle壞塊問題的解決Oracle
- NBU備份windows系統資料庫無法產生備份日誌情況解決Windows資料庫
- 解決：ORACLE 11G使用exp無法導空出表問題Oracle
- oracle 10g asm windows 無法找到磁碟 的問題解決Oracle 10gASMWindows
- netbakcup備份時遇到 status 6: the backup failed to back up the requested files 問題解決AI
- 手動刪除了歸檔日誌後，rman備份出現問題解決
- ORA-00313 ORA-00312 redo日誌報錯處理
- 【DataGuard】ORA-00313, ORA-00312, ORA-27037 in Standby DatabaseDatabase