SunExadataX2-2RmanL1backupOra-00600krbbsThrottle

2014-06-10 在点检Sun Exadata X2-2 一体机时,在预警文件中出现以下错误： Mon Jun 09 22:19:29 2014 Errors in file/u01/app/oracle/diag/rdbms/mcsdb/MCSDB2/trace/MCSDB2_ora_13405.trc (incident=449691): ORA-00600: internal errorcode, arguments: [k

2014-06-10 在点检Sun Exadata X2-2 一体机时,在预警文件中出现以下错误：

Mon Jun 09 22:19:29 2014

Errors in file/u01/app/oracle/diag/rdbms/mcsdb/MCSDB2/trace/MCSDB2_ora_13405.trc (incident=449691):

ORA-00600: internal errorcode, arguments: [krbbsThrottle_ zero_total_size], [90790400], [120070512], [],[], [], [], [], [], [], [], []

Incident details in:/u01/app/oracle/diag/rdbms/mcsdb/MCSDB2/incident/incdir_449691/MCSDB2_ora_13405_i449691.trc

Mon Jun 09 22:19:49 2014

Dumping diagnostic data indirectory=[cdmp_20140609221949], requested by (instance=2, osid=13405),summary=[incident=449691].

Mon Jun 09 22:19:49 2014

Use ADRCI or SupportWorkbench to package the incident.

See Note 411.1 at My OracleSupport for error and packaging details.

Deleted Oracle managed file+RECO_DM01/mcsdb/backupset/2014_06_09/nnndn1_tag2014_06_09_incre1_bak_df_0.560.849820325

Mon Jun 09 22:19:50 2014

Sweep [inc][449691]:completed

Sweep [inc2][449691]:completed

查询Oracle Metalink，结果1：

查询Oracle Metalink，结果2：

Bug 9835218 OERI[krbbsThrottle_ zero_total_size] fromExadata RMAN Incremental backup

This note gives a brief overview of bug9835218.
The content was last updated on:28-JUN-2013
Click here fordetails of each of the divs below.

Affects:

Fixed:

his issue is fixed in

• 12.1.0.1 (Base Release)
• 11.2.0.2 (Server Patch Set)
• 11.2.0.1 Bundle Patch 6 for Exadata Database

Description

An Exadata/SAGE RMAN INCREMENTAL LEVEL 1 backup throws this internal error:

  ORA-600 [krbbsThrottle_ zero_total_size] [total] [done]

indicating that blocks backed up [done] is greater then expected [total]

blocks.

Workaround

 Specify a backup set piece size MAXPIECESIZE large enough to create just

 one backup piece.

References

Bug:9835218 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the divs in this article

临时对策:重新执行Rman L0 备份

2014-06-12 重新执行L0备份后，在执行L1 增量备份成功。

2014-06-13 Oracle 官方给予的解释：

Based on our findings, we are suspecting Bug 17025461 : EXADATA: ORA-600 [KRBBSTHROTTLE_ ZERO_TOTAL_SIZE] ON RMAN INCREMENTAL LEVEL 1 for this issue.

Possible Workaround:
1) Don't set auto-extend on for datafiles. Create larger datafiles to account for space expansion.
If that is not possible, reduce the possiblity of auto-extending datafiles (by specifying extend size larger value).

翻译：不要设置自动扩展上的数据文件。创建更大的数据文件要占空间扩展。如果这是不可能的减少的可能性的自动扩展数据文件 （通过指定扩展规模较大的值）

2) Use higher value of MAXPIECESIZE to prevent possibility of hitting this bug.

翻译：配置Rman使用更高价值的 MAXPIECESIZE，防止击中这个 bug 的可能性

3) Also setting _disable_cell_optimized_backups=TRUE, may help in avoiding the bug.

翻译：也可设置 _disable_cell_optimized_backups = TRUE，可能有助于避免 bug

The patch is available for 11.2.0.3BP17 and the issue is fixed in version 12.2.