我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！ 由于博客中有大量代码，通过页面浏览效果更佳。

本文转自朋友的真实案例分享。

案例：troubleshooting rman backup ORA-00600[ktsitbs_info1]/ORA-25027 after upgrade 11.2.0.4 to 19c cdb

该案例来自东区某金融客户的一次11.2.0.4升级到19.18 cdb，升级过程非常顺利，数据库也运行正常，已经在跑业务了。但是在对升级的19c cdb搭建dg或者备份的时候出现了ORA-00600[ktsitbs_info1]/ORA-25027。

大致的操作如下：

1. starts as a non-cdb 11.2.0.4 database
2. Upgraded to non-cdb 19c database
3. Generate xml file with DBMS_PDB.DESCRIBE
4. Create pluggable database nocopy
5. Run noncdb_to_pdb.sql and open pdb

报错trace关键信息如下：

ORA-00600: internal error code, arguments: [ktsitbs_info1], [23], [], [], [], [], [], [], [], [], [], []2023-08-05 18:23:57.675*:KRB:krbb.c@11063:krbbhdr(): directory block; filled=3 pr->count_krbpr=15 pr->size_krbpr=336 pr->offset_krbpr=28
2023-08-05 18:23:57.676*:KRB:krb.c@6788:krbDiskBufsizf(): ; stripe_size=0 stripe_disk=0 *bufsize=0 *bufcnt=0
2023-08-05 18:23:57.676*:KRB:krbd.c@866:krbdralc(): obtained ksfq context (0): 0x0x7ffff22d78f8
2023-08-05 18:23:57.676*:KRB:krbd.c@868:krbdralc(): ; pkrbdc->bufsize_krbdc=1048576 pkrbdc->bufcnt_krbdc=4
2023-08-05 18:23:57.676*:KRB:krbb.c@8384:krbbtgb(): Done with auxiliary thread, nxtblk: 00x7fffee733ab8, end: 00x7fffee733ab8
2023-08-05 18:23:57.676*:KRB:krbo.c@381:krboinit(): Entering; fno=61
2023-08-05 18:23:57.676*:KRB:krbo.c@428:krboinit(): Calling ktsitbs_info for; ox->tsno_krbox=23 ox->pdb_krbox=1

23是tablespace no，奇怪的是明明已经是pdb 3了，但是报错的pdb居然是1 root 。

该报错对于的代码如下：

@ if (ox->isrdf_krbox && kcfidu())
@ {
@ ox->cangetcurr_krbox = TRUE;
@ .
@ KRBTRC1("krboinit - Calling ktsitbs_info for", tsn);
@ ktsitbs_info(tsn, &tbsinfo);
@ .
@ ktsitbs_info only when database is open read-write.
@ Do you still want me to change that check to:
@ if (kcfido() && sgafinco_bit() &&!sgafincc_bit())

以为是shared pool的问题，flush shared pool之后报错依旧。这时判断很有可能是转换cdb的时候出现了问题。查看dba_pdbs发现新转换的pdb的guid居然是0。

翻阅mos文档，没有发现具体bug和原因，但是有一篇几乎现象一致的文章GUID of the new PDB is shows Wrong Value (Doc ID 2882993.1)

解决方案为：

ALTER PLUGGABLE DATABASE PDB1 CLOSE;
ALTER PLUGGABLE DATABASE PDB1 UNPLUG INTO '/u01/app/oradata/pdb/pdb1.xml';
DROP PLUGGABLE DATABASE PDB1 KEEP DATAFILES;
CREATE PLUGGABLE DATABASE PDB1 AS CLONE USING '/u01/app/oradata/pdb/pdb1.xml' NOCOPY;
ALTER PLUGGABLE DATABASE PDB1 OPEN;
ALTER PLUGGABLE DATABASE PDB1 SAVE STATE;

该案例给的启发时，当升级到19c或者12c版本时，涉及non-cdb to cdb转换，需要检查一下pdb的guid，如果guid为0，则很有可能会遇到备份上的问题。

------------------作者介绍-----------------------

姓名：黄廷忠 现就职：Oracle中国高级服务团队 曾就职：OceanBase、云和恩墨、东方龙马等 电话、微信、QQ：18081072613

个人博客: (http://www.htz.pw)

CSDN地址: (https://blog.csdn.net/wwwhtzpw)

博客园地址: (https://www.cnblogs.com/www-htz-pw)

故障处理：troubleshooting rman backup ORA-00600[ktsitbs_info1]/ORA-25027 after upgrade 11.2.0.4 to 19c cd_2d