ORA-16014 ORA-00312 while bringing up database
(Doc ID 2115062.1)
Last updated on DECEMBER 06, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
++ DB currently in mount stage and while bring up in OPEN mode facing ORA-03113:
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 20052
Session ID: 661 Serial number: 5
++ When going through alert log we see DB terminating due to archival issue
Errors in file /opt/oracle/app/oracle/diag/rdbms/stbydb3/stbydb3/trace/stbydb3_ora_47516.trc:
ORA-16014: log 1 sequence# 1 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u02/oradata/stbydb3/redo01.log'
Wed Mar 02 17:28:23 2016
ARC1 started with pid=21, OS id=47526
USER (ospid: 47516): terminating the instance due to error 16014
System state dump requested by (instance=1, osid=47516), summary=[abnormal instance termination].
++ Problematic log is part of database LSTBYDB3 itself which facing archiving
name #3: /u02/oradata/stbydb3/redo01.log
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x19000 seq: 0x00000001 hws: 0x4 bsz: 512 nab: 0x53 flg: 0x0 dup: 1
Archive links: fwrd: 2 back: 0 Prev scn: 0x0000.00000000
Low scn: 0x0002.4574ba13 03/01/2016 14:29:46
Next scn: 0x0002.4574bb46 03/01/2016 14:29:55
Compatibility Vsn = 186646528=0xb200000
Db ID=3146476263=0xbb8b6ae7, Db Name='LSTBYDB3'
Control Seq=905350111=0x35f68bdf, File size=102400=0x19000
File Number=1, Blksiz=512, File Type=2 LOG
Format ID is 2
redo log key is 894a8dc04d6d24cf3581f60492a7aef
redo log key flag is 5
descrip:"Thread 0001, Seq# 0000000001, SCN 0x00024574ba13-0x00024574bb46"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|