Data Guard

How to Resolve Standby ORA-00600 [3020]

Posted on
ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed Nov 21 18:32:12 2018 Errors in file /oracle/admin/ORCL/bdump/orcl_mrp0_4589393.trc: ORA-00600: internal error code, arguments: [3020], [1786773511], [1], [37836], [320123], [72], [], [] ORA-10567: Redo is inconsistent with data block (file# 854, […]

How to Resolve ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated

Posted on
STATSPACK ORA-00001 Login as PERFSTAT and took a snapshot like the following statement. But it failed with ORA-00001. SQL> exec statspack.snap(i_snap_level=>5); BEGIN statspack.snap(i_snap_level=>5); END; * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated ORA-06512: at “PERFSTAT.STATSPACK”, line 1361 ORA-06512: at “PERFSTAT.STATSPACK”, line 2442 ORA-06512: at “PERFSTAT.STATSPACK”, line 91 ORA-06512: at line 1 This is […]