您好,登錄后才能下訂單哦!
小編給大家分享一下ORA-00313 ORA-00312 redo日志報(bào)錯(cuò)怎么處理,相信大部分人都還不怎么了解,因此分享這篇文章給大家參考一下,希望大家閱讀完這篇文章后大有收獲,下面讓我們一起去了解一下吧!
1、前臺(tái)啟動(dòng)數(shù)據(jù)庫報(bào)錯(cuò)
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 18809
Session ID: 1 Serial number: 50801
2、后臺(tái)alter$ORACLE_SID.log 報(bào)錯(cuò)
alter database open
2017-09-16T21:38:38.117453+08:00
Ping without log force is disabled:
instance mounted in exclusive mode.
Endian type of dictionary set to little
2017-09-16T21:38:38.136378+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_18769.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog12.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog8.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2017-09-16T21:38:38.136457+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_18769.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog12.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog8.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2017-09-16T21:38:38.137207+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_18809.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog8.log'
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog12.log'
2017-09-16T21:38:38.152526+08:00
TT00: Gap Manager starting (PID:19017)
2017-09-16T21:38:38.168038+08:00
USER (ospid: 18809): terminating the instance due to error 313
2017-09-16T21:38:38.253720+08:00
System state dump requested by (instance=1, osid=18809), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_18751_20170916213838.trc
2017-09-16T21:38:38.393632+08:00
Dumping diagnostic data in directory=[cdmp_20170916213838], requested by (instance=1, osid=18809), summary=[abnormal instance termination].
2017-09-16T21:38:39.702685+08:00
Instance terminated by USER, pid = 18809
處理辦法:
清除歸檔日志
alter database clear unarchived logfile group 7;
--alter database clear unarchived logfile group 2;
--alter database clear unarchived logfile group 3;
alter database open;
以上是“ORA-00313 ORA-00312 redo日志報(bào)錯(cuò)怎么處理”這篇文章的所有內(nèi)容,感謝各位的閱讀!相信大家都有了一定的了解,希望分享的內(nèi)容對大家有所幫助,如果還想學(xué)習(xí)更多知識(shí),歡迎關(guān)注億速云行業(yè)資訊頻道!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。