u01下trace大文件-Failed To Record BRR_DBA_Regan_新浪博客

oracle数据库的u01目录使用率异常增长，登陆操作系统后在trace目录下发现主要的大文件为 sid_j000_xxxx.trc的文件。

根据日志内容WARNING: KCBZ_LOG_BLOCK_READ - FAILED TO RECORD BRR FOR在mos上搜索后找到相关文档

Trace Files Generated Having WARNING: kcbz_log_block_read - Failed To Record BRR (文档 ID 2005854.1)解决方案为 SQL> alter system set events '10741 trace name context forever, level 1';

  按照文档这样配置后，不再产生这样的warning。

但是这样的语法在重启后将无效，需要在spfile中写入配置

ALTER SYSTEM SET EVENT = '10741 TRACE NAME CONTEXT FOREVER , LEVEL 1' SCOPE=SPFILE;