Database Parameter _ktb_debug_flags in 11.2.0.2

Former Member · ‎2014 Jun 26

HI Folks,

Could Anyone Please explain the importance of Database Parameter _ktb_debug_flags in 11.2.0.2 . This parameter has been recommended

Early Watch Report of ECC System.

Regards,

Sharma TVK

Former Member · ‎2014 Jun 26

Hi Kamesh,

Please execute DBverfiy and check whether below message appear in the logs

ORA-1555 / ORA-600 [ktbdchk1: bad dscn] / ktbGetDependentScn / Dependent scn violations as the block ITL has higher COMMIT SCN than block SCN

If yes, then refer to SAP note 2005311 and set the parameter _ktb_debug_flags.

This is a dynamic parameter and can be set online using the command

alter system set "_ktb_debug_flags"=8; ( As per SAP note 1431798 - Oracle 11.2.0: Database Parameter Settings)

This is a known bug in Oracle 11.2.0.2 if you have Oracle data guard configured.

Hope this helps.

Regards,

Deepak Kori

S_Sriram · ‎2014 Jun 26

This message was moderated.

divyanshu_srivastava3 · ‎2014 Jun 26

Hi Sharma,

I read this online that this parameter is designed to heal blocks having invalid dependent scn’s on switchover operations.

This is an hidden parameter and it's dynamic in nature.

Regards,

Divyanshu