oracle 11g adg 中取消审计,禁用Oracle 11gR2 DataGuard默认审计功能

12.修改备库审计参数

alter system set audit_trail=none scope=spfile;

13.停止备库数据库

shutdown immediate;

14.启动备库数据库

startup;

15.检查备库审计参数设置是否正确

SQL> show parameter audit_trail;

NAME TYPE VALUE

-------------------------------- ----------- ------------------------------

audit_trail string NONE

16.查看审计表数据，应该和主库一致

SQL> select count(*) from SYS.AUD$;

COUNT(*)

----------

21545536

17.启用备库实时应用

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect FROM SESSION;

18.开启主库传输进程

alter system set LOG_ARCHIVE_DEST_STATE_2=enable scope=both;

19.主库手动切换日志

alter system switch logfile;

20.检查主库归档传输状态

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

select SEQUENCE#,first_time,next_time,APPLIED,DELETED,THREAD# from v$archived_log order by SEQUENCE#,THREAD#;

21.检查备库归档应用状态

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

select SEQUENCE#,first_time,next_time,APPLIED,DELETED,THREAD# from v$archived_log order by SEQUENCE#,THREAD#;