一、报错
有个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