1 啟動數(shù)據(jù)庫報錯

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 10380

Session ID: 32 Serial number: 24360

跟蹤日志錯誤提示如下：

[oracle@dg1 trace]$ tail -200f /u01/app/oracle/diag/rdbms/cndba/cndba/trace/alert_cndba.log

Errors in file /u01/app/oracle/diag/rdbms/cndba/cndba/trace/cndba_ora_10380.trc:

ORA-16014: log 3 sequence# 3 not archived, no available destinations

ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/cndba/redo03.log'

2017-07-31T11:01:26.938354+08:00

USER (ospid: 10380): terminating the instance due to error 16014

2017-07-31T11:01:26.997422+08:00

System state dump requested by (instance=1, osid=10380), summary=[abnormal instance termination].

System State dumped to trace file /u01/app/oracle/diag/rdbms/cndba/cndba/trace/cndba_diag_10313_20170731110126.trc

2017-07-31T11:01:27.081110+08:00

2 解決辦法：

錯誤信息提示：archive log 無法歸檔，而且報錯信息看出是 redo03.log該日志文件被損壞了。

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1426063360 bytes

Fixed Size 8792776 bytes

Variable Size 889193784 bytes

Database Buffers 520093696 bytes

Redo Buffers 7983104 bytes

Database mounted.

Database opened.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 PDBCNDBA READ WRITE NO

5 PDBCNDBA2 READ WRITE NO

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

https://www.cndba.cn/leo1990/article/2031

版權(quán)聲明：本文為博主原創(chuàng)文章，未經(jīng)博主允許不得轉(zhuǎn)載。

總結(jié)

以上是生活随笔為你收集整理的oracle00312,oracle 启动 报ORA-16014 和 ORA-00312的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。