My Oracle Support Banner

Database Can Not Startup With Error "Control file sequence number mismatch!" (Doc ID 2411155.1)

Last updated on AUGUST 04, 2018

Applies to:

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


1. Instance startup failed at OPEN phase, but no obvious errors in alert log:


Thu May 31 15:23:20 2018
Starting ORACLE instance (normal)
****************** Large Pages Information *****************


Thu May 31 15:23:37 2018
ARC3 started with pid=41, OS id=15059
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
System state dump requested by (instance=1, osid=15002), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/oracle/diag/rdbms/xpbd/xpbd1/trace/xpbd1_diag_14925.trc
USER (ospid: 15002): terminating the instance <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 15002 terminate the instance...
Dumping diagnostic data in directory=[cdmp_20180531152337], requested by (instance=1, osid=15002), summary=[abnormal instance termination].
Instance terminated by USER, pid = 15002


2. Find the related trace file and find following error in the trace file:


Error: kccpb_sanity_check_2
Control file sequence number mismatch! <<<<<<<<< Control file sequence number mismatch!
fhcsq: 25038565 bhcsq: 3481437667 cfn 8
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
----- End of Abridged Call Stack Trace -----

*** 2018-05-31 15:23:37.560
USER (ospid: 15002): terminating the instance  <<<<<<<<<<<<<<<  Instance was terminated by ospid:15002
ksuitm: waiting up to [5] seconds before killing DIAG(14925) 





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.