7: text of failing SQL statement: begin dbms_rcvman . translateDatabase ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 7618
RMAN-06031: could not translate database keyword
解决方案:
应用针对 Bug 9577583 的 Patch 9577583
Ref: Note 9577583.8 False ORA-942 or other errors when multiple schemas have identical object names.?
4. BUG 10635701 - BACKUP OF FRA CONSUMES 15GB OF PGA AND FAIL WITH ORA-4030
RMAN 在备份大量文件时,会由于消耗过多内存而失败,并出现 ORA-4030。错误出现在heap(堆)KSFQ,其中包含带有注释“KSFQ Buffers”的块。影响 11.2.0.1 和 11.2.0.2,已在 11.2.0.3 中修复
症状:
RMAN 跟踪信息显示以下 function(函数)中出错。
dbms_backup_restore.validationvalidate,带有类似下文的跟踪行:
krmxrpc - channel t1 kpurpc2 err=4030 db=target proc=SYS.DBMS_BACKUP_RESTORE.VALIDATIONVALIDATE
失败进程的调用堆栈:
kghalf <- ksfqbalo <- ksfqbcre <- ksfqxc <- ksfqxcrx <- ksfqxcre <- krbrvv
分配的内存为 KSFQ的 heap(堆),其中 KSFQ heap(堆)包含带有注释“KSFQ Buffers”的块。该信息会被转储到错误 ORA-4030 生成的跟踪文件中
以下文件中的错误: /cihcissdb028/dump01/oracle/dxls/udump/diag/rdbms/dxls/dxls/incident/incdir_68404/dxls_ora_27140_i68404.trc:
ORA-04030: out of process memory when trying to allocate 824492 bytes (pga heap,kco buffer)
ORA-04030: out of process memory when trying to allocate 1052684 bytes (KSFQ heap,KSFQ Buffers)
解决方案:
应用 Patch 10635701, 这个问题没有办法绕过。影响 11.2.0.1 和 11.2.0.2,已在 11.2.0.3 中包括修复。
Ref: Note 10635701.8 RMAN backup many files consumes lots of PGA / fails with ORA-4030
5. BUG 12370722 - CATUPGRD.SQL HANGS WITH ARCH ERROR ORA-600 [KRR_HIGHEST_SCN_TIM_8]
升级到 11.2.0.2 之后,归档进程持续引发 ORA_0600 [krr_highest_scn_tim_8]。升级之后在 11.2.0.2 中报错;影响升级,导致停机,解决方法是清除联机重做日志。此问题已在 11.2.0.3 中修复。
以下列出的 Bug,其症状类似于父 bug 12370722
Bug 11872889: ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KRR_HIGHEST_SCN_TIM_8]
Bug 12534566: DATABASE OPEN FAILED ORA-00600 [KRR_HIGHEST_SCN_TIM_8]
Bug 11062394: ORA-600 [KRR_HIGHEST_SCN_TIM_8] REPORTED BY AN ARCHIVER PROCESS
所有这些 Bug 均已关闭,与以下 Bug 重复:
Bug 12370722: CATUPGRD.SQL HANGS WITH ARCH ERROR ORA-600 [KRR_HIGHEST_SCN_TIM_8]
症状:
查找错误:
?运行 Oracle 版本 11.2.0.2
?数据库近期从 10.2(或 10.1)升级到 11.2.0.2,为确认这一点,11.2.0.2 alert log 应显示“ALTER DATABASE OPEN MIGRATE”。
归档进程定期(例如每分钟)报错 ORA-00600:[krr_highest_scn_tim_8],然后终止,调用堆栈如下:
-> ksbrdp -> krsv_abs -> ksbabs -> kcrrwk -> kcrrwkx -> krse_arc_driver -> krse_arc_driver_cor -> krse_arc_spool -> krr_highest_scn_tim -> ora600:[krr_highest_scn_tim_8]
或者
尝试打开数据库的进程报错 ORA-00600:[krr_highest_scn_tim_8],调用堆栈如下:
-> adbdrv -> kcfopd -> kcttsc -> krsq_arch_to_force_ -> krse_arc_driver -> krse_arc_driver_cor -> krse_arc_spool -> krr_highest_scn_tim -> ora600:[krr_highest_scn_tim_8]
或者
执行 alter system archive log all; 的进程报错 ORA-00600:[krr_highest_scn_tim_8],调用堆栈如下:
-> kkyasy -< krsq_arch_all_or_next -> krsq_arch_one_log -> krse_arc_driver->krse_arc_driver_core -> krse_arc_spool -> krr_highest_scn_tim -> ora600:[krr_highest_scn_tim_8]
一个特定联机重做日志未归档,以下查询会显示未归档的日志序列号:
SQL> select sequence# from v$log where archived='NO' and status = 'CURRENT';
错误:
RMAN-00571: =======================================================
RMAN-00569: =========== ERROR MESSAGE STACK FOLLOWS ===========
RMAN-00571: =======================================================
RMAN-03009: failure of sql command on default channel at 05/20/2011 01:26:24
RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
ORA-00600: internal error code, arguments: [krr_highest_scn_tim_8], [], [], [], [], [], [], [], [], [], []
Workaround:
为防止出现 ORA-00600:[krr_highest_scn_tim_8],请在开始升级到 11.2.0.2 之后,不要返回并使用 Oracle 版本 10