oracle11g默认开启了审计功能占用了大量的资源
RAC关闭审计
1、修改前做好备份
[oracle@fcdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Sep 25 16:35:26 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA1/centerdb/spfilecenterdb
                                                 .ora
SQL>

create pfile='/tmp/pfile0925' from spfile='+DATA1/centerdb/spfilecenterdb.ora'

2、在任意一个节点执行
alter system set audit_trail=NONE scope=spfile sid='centerdb1';
alter system set audit_trail=NONE scope=spfile sid='centerdb2';

3、修改2个节点备份下来的pfile文件中的audit_trail='NONE'
*.audit_trail='db'
centerdb1.audit_trail='NONE'
centerdb2.audit_trail='NONE'
4、使用修改后的参数文件启动2个实例
startup pfile='/tmp/pfile0925';

5、2个节点都创建spfile文件
create spfile='+DATA1/centerdb/spfilecenterdb.ora' from pfile='/tmp/pfile0925';

6、重启实例即可并检查
[oracle@fcdb1 tmp]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora....b1.inst application    0/5    0/0    ONLINE    ONLINE    fcdb1
ora....b2.inst application    0/5    0/0    ONLINE    ONLINE    fcdb2
ora....erdb.db application    0/0    0/1    ONLINE    ONLINE    fcdb2
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    fcdb1
ora....B1.lsnr application    0/5    0/0    ONLINE    ONLINE    fcdb1
ora.fcdb1.gsd application    0/5    0/0    ONLINE    ONLINE    fcdb1
ora.fcdb1.ons application    0/3    0/0    ONLINE    ONLINE    fcdb1
ora.fcdb1.vip application    0/0    0/0    ONLINE    ONLINE    fcdb1
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    fcdb2
ora....B2.lsnr application    0/5    0/0    ONLINE    ONLINE    fcdb2
ora.fcdb2.gsd application    0/5    0/0    ONLINE    ONLINE    fcdb2
ora.fcdb2.ons application    0/3    0/0    ONLINE    ONLINE    fcdb2
ora.fcdb2.vip application    0/0    0/0    ONLINE    ONLINE    fcdb2

8、查看审计功能是否关闭
节点1：
[oracle@fcdb1 tmp]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Sep 25 16:45:46 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter audi

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/centerdb
                                                 /adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      NONE
ok已经为NONE了

节点2：
[oracle@fcdb2 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Sep 25 16:46:43 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter audi;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/centerdb
                                                 /adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      NONE
SQL>
ok，节点2也已经改为NONE了。
此时审计功能已经关闭了。观察一段时间是不是发现负载下降了许多呢？

ITPub博客

11gRAC关闭审计功能

最新文章