SAP Knowledge Base Article - Preview

3053736 - Database crash and oracle startup problem after archival stuck error

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

SAP NetWeaver all versions

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.