Wrong System Date Can Lead to ORA-00600 [kcm_headroom_warn_1] (Doc ID 2147012.1)

Last updated on JULY 21, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

...
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
 read 47814 KB redo, 3171 data blocks need recovery
Started redo application at
 Thread 1: logseq 18936, block 47431
Recovery of Online Redo Log: Thread 1 Group 3 Seq 18936 Reading mem 0
  Mem# 0: /home/oracle/app/oracle/dev1/redo03.log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 18937 Reading mem 0
  Mem# 0: /home/oracle/app/oracle/dev1/redo01.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 18938 Reading mem 0
...
  Mem# 0: /home/oracle/app/oracle/dev1/redo02.log
Completed redo application of 33.06MB
Completed crash recovery at
 Thread 1: logseq 18938, block 306, scn 10191908075373
 3171 data blocks read, 3171 data blocks written, 47814 redo k-bytes read
************************************************************
Warning: The SCN headroom for this database is only -52488 hours!                                                                                    <<<<<<<<<<<<<<<<    PAST TIME SET due to OS system change.
************************************************************

followed by:


ORA-00600: internal error code, arguments: [kcm_headroom_warn_1], [], [], [], [], [], [], [], [], [], [], []

Changes

 System clock changed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms