Alert Log shows Error ORA-600 [kewrspbr_2: Wrong Last Partition] (Doc ID 2549611.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• ORA-00600 [kewrspbr_2: wrong last partition] in the alert log with following tracefile:
  Main Stack:
  kewrsap_split_all_partitions <- kewrasbd_auto_split_by_dbid
  <- kewrapsd_auto_purge_split_dbid <- kewraps_auto_purge_slave <- kebm_slave_cb
  <- kebm_slave_main <- ksvrdp_int <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain
  <- main
   
• M000 trace file shows following message:
  
  ObjectName: Name=delete from WRM$_DATABASE_INSTANCE dbinst where dbinst.dbid = :dbid and NOT EXISTS (select 1 from WRM$_SNAPSHOT snap where snap.dbid = :dbid and snap.instance_number = dbinst.instance_number and snap.startup_time = dbinst.startup_time) and dbinst.startup_time < (select max(startup_time) from WRM$_DATABASE_INSTANCE where dbid = :dbid and instance_number = dbinst.instance_number and startup_time < (cast(SYSTIMESTAMP as TIMESTA

   

Cause

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