My Oracle Support Banner

Instance Termination With Error ORA-00600: [2028], [867840] (Doc ID 2448549.1)

Last updated on MARCH 13, 2019

Applies to:

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

Symptoms

Database instance terminated with the ORA-600 [2028] error, as shown here.

. restart of the database didn't faced any error

  Tue Jul 10 06:55:37 2018
  AQPC started with pid=51, OS id=23896
  Starting background process CJQ0
  Completed: ALTER DATABASE OPEN


. Error is because the redo record size is greater than allowed value of  kcrf_max_recsz_ ie 851968
.
from the trace we see max is 851968 but redo record size is 867840 ,hence, the error
  
uword kcrf_max_recsz_ [060028468, 06002846C) = 000D0000

. Around the time we see IO pressure by LGWR

  *** 2018-07-10 03:05:37.033
  Warning: log write elapsed time 1520ms, size 1616KB << 1.5 seconds for 1.5MB IO
  --
  *** 2018-07-10 03:14:53.352
  Warning: log write elapsed time 618ms, size 128KB
  --
  *** 2018-07-10 05:45:25.037
  Warning: log write elapsed time 611ms, size 32KB
  --
  *** 2018-07-10 06:11:19.072
  Warning: log write elapsed time 736ms, size 8KB
  --
  *** 2018-07-10 06:14:45.792
  Warning: log write elapsed time 932ms, size 1028KB << around 1 second for 1MB IO

. redo log groups having different block size ie 512 bytes and 4K

  INST_ID GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ---------- ----------
  1 1 1 74854 629145600 4096 2 YES INACTIVE 4.5520E+12 10-JUL-18 4.5520E+12 10-JUL-18    0
  1 2 1 74855 629145600 4096 2 YES INACTIVE 4.5520E+12 10-JUL-18 4.5520E+12 10-JUL-18    0
  1 3 1 74858 629145600 4096 2 NO CURRENT 4.5520E+12 10-JUL-18 2.8147E+14                    0
  1 4 1 74856 629145600 512 2 YES ACTIVE 4.5520E+12 10-JUL-18 4.5520E+12 10-JUL-18         0
  1 5 1 74857 629145600 512 2 YES ACTIVE 4.5520E+12 10-JUL-18 4.5520E+12 10-JUL-18         0

. group 4 & 5 created later w/ 512bytes block size (looks ct missed to mention block size 4k in the command )

  Sat Mar 31 21:59:06 2018
  ALTER SYSTEM SET db_keep_cache_size=4G SCOPE=SPFILE;
  ALTER DATABASE ADD LOGFILE GROUP 4
('/<path>/redo04a.log'
,'/<path>/redo04b.log') SIZE 600M
  Completed: ALTER DATABASE ADD LOGFILE GROUP 4
('/<path>/redo04a.log'
,'/<path>/redo04b.log') SIZE 600M
  ALTER DATABASE ADD LOGFILE GROUP 5
('/<path>/redo05a.log'
,'/<path>/redo05b.log') SIZE 600M
  Completed: ALTER DATABASE ADD LOGFILE GROUP 5
('/<path>/redo05a.log'
,'/<path>/redo05b.log') SIZE 600M

. Native block size is 512bytes

Errors in file /<path>/trace/<oracle_sid>_dbw0_9426.trc:

ORA-00600: internal error code, arguments: [2028], [867840], [], [], [], [], [], [], [], [], [], []
Tue Jul 10 06:15:22 2018
USER (ospid: 9426): terminating the instance due to error 471

Cause

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
Symptoms
Cause
Solution
References


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