现象:
kcrrwkx: nothing to do (start) *** 2012-05-07 22:28:35.989 kcrrwkx: nothing to do (end) *** 2012-05-07 22:29:35.995 kcrrwkx: nothing to do (end) *** 2012-05-07 22:30:36.007 kcrrwkx: nothing to do (end) *** 2012-05-07 22:31:36.014 kcrrwkx: nothing to do (end) *** 2012-05-07 22:32:36.023 kcrrwkx: nothing to do (end) *** 2012-05-07 22:33:36.029 tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2 kcrrwkx: nothing to do (end) *** 2012-05-07 22:34:41.039 kcrrwkx: nothing to do (end) *** 2012-05-07 22:35:41.048 kcrrwkx: nothing to do (end)
问题类型:
ORACLE系统BUG
解决办法:
1. This message has zero impact, and can be ignored. Except that the trace files will be consuming disk space, which can be manually removed or running a cron job to clean up.
2. The one-off patch for fixing this issue is also available for some platforms. Check metalink.oracle.com --> patches & updates --> simple search --> fill the patch number as : 4883174 and choose your correct OS . Down load the patch for10.2.0.1 or 10.2.0.2 as per your database version.
问题原因:
CauseThe archive trace files generation is caused by
Bug 4883174 ARCHIVE PRODUCES TO MANY LOG ENTRIES ''KCRRWKX: NOTHING TO DO (END)
Fixed in11gand possible in10.2.0.3
Please note that these one-off patches are not regression tested and hence you are advised to apply it on a testserver before applying it on a production box. Please follow the patch readme for installing this patch.
ReferencesBug 4883174 - Archive Produces To Many Log Entries ''Kcrrwkx: Nothing To Do (End)
Bug 5117016 - Libserver10.A Incorrectly Located In $Oracle_Home/Rdbms/Lib/
参考: