Cause: This Errors May Occur after a switchover Physical Standby database, and it is due to Oracle Bug 8895202.
Solution: Apply the patch where this issue is fixed , Patch 8895202 or Patch Sets >= 11.2.0.2 or Patch Bundles >= 11.1.0.7. If Your database version is >=11.2.0.2 then just change the parameter _ktb_debug_flags to 8. There is no danger in keeping _ktb_debug_flags=8. It gets only activated by invalid scn in itl.
After change the parameter analyze the object which has been affected.
bash-4.3$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 26 14:31:11 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> alter system set "_ktb_debug_flags"=8 scope=both sid='*';
System altered.
SQL> EXIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
bash-4.3$
bash-4.3$
ORA-01555 caused by SQL statement below (SQL ID: 89w0nk4mvs89k, Query Duration=0 sec, SCN: 0x0b0e.183c53aa):
Dump continued from file: /u01/app/oracle/diag/rdbms/erpdcdb/erpdcdb1/trace/erpdcdb1_ora_7798850.trc
ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 5041023 (ORA 600 [ktbdchk1: bad dscn]) ========
----- Beginning of Customized Incident Dump(s) -----
[ktbdchk] -- ktbgcl4 -- bad dscn
dependent scn: 0x0b0e.6ada21f5 recent scn: 0x0b0e.183bdd5c current scn: 0x0b0e.183bdd5c
----- End of Customized Incident Dump(s) -----
ANALYZE TABLE TABLE_NAME VALIDATE STRUCTURE CASCADE;
Dump continued from file: /u01/app/oracle/diag/rdbms/erpdcdb/erpdcdb2/trace/erpdcdb2_ora_5767956.trc
ORA-00600: internal error code, arguments: [2663], [2830], [698760342], [2830], [1792623805], [], [], [], [], [], [], []
========= Dump for incident 2720876 (ORA 600 [2663]) ========
*** 2017-09-26 13:52:19.908
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=2pbup9vshvk0u) -----
ANALYZE TABLE TABLE_NAME VALIDATE STRUCTURE CASCADE;
Solution: Apply the patch where this issue is fixed , Patch 8895202 or Patch Sets >= 11.2.0.2 or Patch Bundles >= 11.1.0.7. If Your database version is >=11.2.0.2 then just change the parameter _ktb_debug_flags to 8. There is no danger in keeping _ktb_debug_flags=8. It gets only activated by invalid scn in itl.
After change the parameter analyze the object which has been affected.
bash-4.3$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 26 14:31:11 2017
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> alter system set "_ktb_debug_flags"=8 scope=both sid='*';
System altered.
SQL> EXIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
bash-4.3$
bash-4.3$
ORA-01555 caused by SQL statement below (SQL ID: 89w0nk4mvs89k, Query Duration=0 sec, SCN: 0x0b0e.183c53aa):
Dump continued from file: /u01/app/oracle/diag/rdbms/erpdcdb/erpdcdb1/trace/erpdcdb1_ora_7798850.trc
ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 5041023 (ORA 600 [ktbdchk1: bad dscn]) ========
----- Beginning of Customized Incident Dump(s) -----
[ktbdchk] -- ktbgcl4 -- bad dscn
dependent scn: 0x0b0e.6ada21f5 recent scn: 0x0b0e.183bdd5c current scn: 0x0b0e.183bdd5c
----- End of Customized Incident Dump(s) -----
ANALYZE TABLE TABLE_NAME VALIDATE STRUCTURE CASCADE;
Dump continued from file: /u01/app/oracle/diag/rdbms/erpdcdb/erpdcdb2/trace/erpdcdb2_ora_5767956.trc
ORA-00600: internal error code, arguments: [2663], [2830], [698760342], [2830], [1792623805], [], [], [], [], [], [], []
========= Dump for incident 2720876 (ORA 600 [2663]) ========
*** 2017-09-26 13:52:19.908
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=2pbup9vshvk0u) -----
ANALYZE TABLE TABLE_NAME VALIDATE STRUCTURE CASCADE;
Thanks for the post. Foued
ReplyDeleteThis information you provided in the blog that is really unique I love it!! Thanks for sharing such a great blog Keep posting..
ReplyDeleteOracle Training in Gurgaon
Oracle Institute in Gurgaon
Oracle Course in Gurgaon
In my Oracle Exam I got 97% marks just studying one month. Dumpspass4sure is such authentic platform which helped me in my final exam with Pass4sure Oracle Study guide. That study guide is really combined with high efficiency of experienced team. That’s why I got my successful result. Provided demo questions on that website helped me to analyze the quality of study material in that amazing study guide. All my success is because of that stunning study guide and astonishing platform.
ReplyDeleteMy experience with DumpsSure real 1Z0-061 exam dumps has been good because I have achieved good points in the exam. Material provided by BrainDumps is authentic and easy to understand. Whenever I will take a course I will use their material.
ReplyDeleteActual Oracle Exam Dumps Questions Answers
Oracle 1Z0-1065 dumps showed me the way to definite success and gave me solid knowledge of the field. I am thankful to Exam4lead.com for doing such a useful job for IT candidates. I might not be able to pass my exam without taking help from 1Z0-1065 dumps.
ReplyDeletehttps://www.exam4lead.com/oracle.html
Respect and I have a dandy proposal: Whole House Renovation Checklist Pdf home renovation youtube
ReplyDelete