ORA-00600 - [qosdExpStatRead: expcnt mismatch] while taking EXPORT backups

 

Recently faced an issue on 12.2 database version, Export jobs were failing with below error.

This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 1976
ORA-06512: at "SYS.DBMS_STATS", line 52343
ORA-06512: at "SYS.DBMS_STATS", line 52567
ORA-06512: at "SYS.KUPW$WORKER", line 28772
ORA-06512: at "SYS.KUPW$WORKER", line 3265
ORA-06512: at "SYS.KUPW$WORKER", line 13063
ORA-06512: at "SYS.KUPW$WORKER", line 2311

Find the Incorrect data

SQL> with b as (
  select count(*) cnt,objn,snapshot_id from sys.exp_stat$ es group by objn,snapshot_id)
  select * from sys.exp_obj$ a, b where a.objn=b.objn and a.snapshot_id=b.snapshot_id and  a.EXP_CNT <> b.CNT;

Fix the data

SQL> update sys.exp_obj$ a set exp_cnt=(select count(*) from sys.exp_stat$ b where a.objn=b.objn and a.snapshot_id=b.snapshot_id) where a.objn=305314;

SQL> commit;
Commit complete.

Export backups should be successful now !