用户系统DataGurd 备库出现ORA-00600错误。
Thu Mar 26 06:57:31 2020
Errors in file /u01/app/oracle/diag/rdbms/wmsrpt/wmsrpt/trace/wmsrpt_mrp0_9109582.trc (incident=528267):
ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [87], [66], [62], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/wmsrpt/wmsrpt/incident*.trc
MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/diag/rdbms/wmsrpt/wmsrpt/trace/wmsrpt_mrp0_9109582.trc:
ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [87], [66], [62], [], [], [], []
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 600
Thu Mar 26 06:57:35 2020
Trace dumping is performing id=[cdmp_20200326065735]
Recovery interrupted!
Thu Mar 26 06:57:37 2020
Sweep Incident[528267]: completed
Thu Mar 26 06:57:42 2020
Recovered data files to a consistent state at change 16451234763882
Errors in file /u01/app/oracle/diag/rdbms/wmsrpt/wmsrpt/trace/wmsrpt_mrp0_9109582.trc:
ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [87], [66], [62], [], [], [], []
Errors in file /u01/app/oracle/diag/rdbms/wmsrpt/wmsrpt/trace/wmsrpt_mrp0_9109582.trc:
ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [87], [66], [62], [], [], [], []
Thu Mar 26 07:04:35 2020
根据Metalink方法进行解决。
Metalink Doc ID: 751787.1
Solution
Use the hidden parameter _max_io_size that can be used to set the size of the individual read buffers allocated by recovery.
So set this parameter to 4194304 (ie 4Mb) in the init.ora/spfile then that should be good enough to
function as a workaround and allow recovery.
_max_io_size=4194304
As a fix apply the one of available for your version of oracle ,if not check with Oracle support if a one off can be made available via a backport
评论已关闭。