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#;