Sun Exadata X2-2 Rman L1 backup Ora-00600 krbbsThrottle
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：
|
|
|||
|
Bug 17025461 - ORA-600 [krbbsThrottle_ zero_total_size] on RMAN backup (Doc ID 17025461.8) |
To Bottom |
||
|
Modified:14-Mar-2014 Type:PATCH |
|
|
Bug 17025461 ORA-600 [krbbsThrottle_ zero_total_size] on RMAN backup This note gives a brief overview of bug 17025461. Affects:
Fixed:
|
查询Oracle Metalink，结果2：
|
Bug 9835218 - OERI[krbbsThrottle_ zero_total_size] from Exadata RMAN Incremental backup (Doc ID 9835218.8) |
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:
|
Product (Component) |
Oracle Server (Rdbms) |
|
Range of versions believed to be affected |
Versions >= 11 but BELOW 12.1 |
|
Versions confirmed as being affected |
|
|
Platforms affected |
Generic (all / most platforms affected) |
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
Symptoms: |
Related To: |
|
|
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.
|
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support. |
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.