在rman备份过程中，数据文件增长可能会导致ORA-00600 [krbockstat-nrblks]

最新推荐文章于 2023-06-05 19:02:49 发布

crazycat123456

最新推荐文章于 2023-06-05 19:02:49 发布

阅读量194

点赞数

文章标签：数据库

本文记录了一次在凌晨进行数据库备份时遇到的ORA-00600错误，该错误源于一个已知的Oracle内部bug，当数据文件在RMAN备份过程中增长时，可能会导致此问题。尽管此错误会导致备份失败，但数据库本身不受影响。解决方案是在10.2.0.4和11.1版本中修复了此bug，或者作为临时解决办法，可以重新启动备份操作。

摘要由CSDN通过智能技术生成

今天凌晨对数据库进行备份，结果却出现一个600错误，查阅metalink后发现是一个bug，而且说只要备份不失败，则对数据库和数据库的备份都没有任何影响。在这里记录一下吧。[@more@]

Backup Fails With ORA-00600 [krbockstat-nrblks] If Datafile Grows During RMAN Backup
Doc ID: Note:415798.1 Type: PROBLEM
Last Revision Date: 15-MAR-2007 Status: MODERATED

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms

- ORA-00600 [krbockstat-nrblks] reported while taking Backups using RMAN

- Error reported in alert log and trace file generated

- The below mentioned call stack is seen in the trace file.

krbockstat krbb1ef krbbtgb krbbpc krbibpc pevm_icd_call_commo pfrinstr_ICAL
pfrrun_no_tool pfrrun plsql_run pricar pricbr prient2 prient kkxrpc kporpc

Cause
- The error is due to internal oracle Bug 5742127

Abstract: BACKUP SOMETIMES FAILS WITH INTERNAL ERROR IF DATAFILE
GROWS DURING BACKUP

- RMAN backup fails with internal error when datafile grows during backup with
compatible >= 10.2 and datafile is a locally managed datafile.

- No impact to database functionality or corruptions due to this bug,except failing of RMAN backup.

- Fixed In Ver: 10.2.0.4 and 11.1
Solution
- The bug 5742127 is fixed in V10.2.0.4 and V11.1

- Workaround is to restart the backup operation .And also moving to above patchsets
will resolve the issue.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25016/viewspace-982875/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25016/viewspace-982875/