问题学习:MMON进程trace Auto-DBFUS slave failed

一、报错

有个DBA朋友遇到如下问题,观察MOS整理
现象MMON进程trace一直报错 MMON trace file shows repeated entries:
***KEWFDBFUS: Auto-DBFUS slave failed, return Code: 2***KEWFDBFUS: Auto-DBFUS slave failed, return Code: 2***KEWFDBFUS: Auto-DBFUS slave failed,

return Code: 2***KEWFDBFUS: Auto-DBF US slave failed, return Code: 2***KEWFDBFUS: Auto-DBFUS slave failed, return Code: 2 ······

 

 

二、问题处理

 

参考
Enq: FU - Contention Wait MMON trace file shows repeated entries "auto-DBFUS slave" (Doc ID 2671019.1)    
Oracle Database - Enterprise Edition - Version 10.2.0.4 and later

enq: FU - contention. MMON trace file shows repeated entries "auto-DBFUS slave"

CAUSE
Auto-DBFUS slave failed
Auto-DBFUS slave failed

1.MOS文章的意思就是Oralce使用DBFUS的自动功能失败了,然后禁用这个功能就能避免MMON进程trace一直报错;
2.这个参数禁用有什么影响?
 SWRF功能是用于将awr数据导出,导入到其他数据库中,这个功能基本不使用,可以关闭,无太大影响,无需重启生效;
3.如何关闭

SOLUTION _swrf_mmon_dbfus TRUE Enable
/disable SWRF MMON DB Feature Usage select a.ksppinm,b.ksppstvl,a.ksppdesc from x$ksppi a,x$ksppcv b where a.indx=b.indx and a.ksppinm like _swrf_mmon_dbfus%; alter system set "_swrf_mmon_dbfus"=false; 4.对DBFUS感兴趣的朋友可以看看如下链接 https://wenku.baidu.com/view/d33bc6d43186bceb18e8bb04.html
到了11g,AWR报告导出完全可以使用另一种更为简便的方式

@$ORACLE_HOME/rdbms/admin/awrextr.sql 导出awr

@$ORACLE_HOME/rdbms/admin/awrload.sql 导入awr

 

问题学习:MMON进程trace Auto-DBFUS slave failed

上一篇:linux配置mysql环境变量


下一篇:Docker:5 扩展学习之安装mysql并且将数据挂载到本地磁盘