Symptom
Database has been crashed after an archiver stuck caused by a free space issue.
The alert log shows the following or similar entries:
...
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance SID - Archival Error. Archiver continuing.
Mon Mar 30 09:01:38 2020
Completed checkpoint up to RBA [0x8436.2.10], SCN: 3668470681
Thread 1 cannot allocate new log, sequence 33849
Private strand flush not complete
...
...
Mon Mar 30 09:14:41 2020
minact-scn: useg scan erroring out with error e:12751
Mon Mar 30 09:23:24 2020
Errors in file /oracle/SID/saptrace/diag/rdbms/sid_primary/SID/trace/SID_arc2_50544.trc (incident=84648):
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 50478'
Incident details in: /oracle/SID/saptrace/diag/rdbms/sid_primary/SID/incident/incdir_84648/SID_arc2_50544_i84648.trc
Mon Mar 30 09:23:54 2020
Killing enqueue blocker (pid=50478) on resource CF-00000000-00000000 by (pid=50544)
by killing session 331.1
Killing enqueue blocker (pid=50478) on resource CF-00000000-00000000 by (pid=50544)
by terminating the process
ARC2 (ospid: 50544): terminating the instance due to error 2103
...
and the database cannot be started afterwards:
...
Mon Mar 30 09:25:07 2020
ALTER DATABASE MOUNT
sculkget: failed to lock /oracle/SID/112_64/dbs/lkSID_PRIMARY exclusive
sculkget: lock held by PID: 50478
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 50478
ORA-1102 signalled during: ALTER DATABASE MOUNT...
...
Read more...
Environment
- Oracle 11g or higher
Product
Keywords
archive failed, ORA-00494, ORA-09968, ORA-1102, terminating the instance, free space, archiver stuck , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.