oracle審計(jì)清理

審計(jì)遷移
1、本地創(chuàng)建備份表
create tablespace TSP_AUDBAK datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;

create table aud_bak tablespace TSP_AUDBAK as select * from aud$;

2、創(chuàng)建dblink
create public database link dblink_aud
connect to audqy identified by audqy
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.232.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)';

select * from dual@dblink_aud;
2、遠(yuǎn)端創(chuàng)建備份表
create tablespace TSP_AUDBAK datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;
alter tablespace TSP_AUDBAK add datafile '+DATA' size 32g;

create table sys.aud_bak tablespace tsp_audbak as select * from aud_bak@dblink_aud;



審計(jì)清理
1、查詢
select segment_name,bytes/1024/1024 size_in_megabytes from dba_segments where segment_name='AUD$';
select table_name, tablespace_name from dba_tables where table_name='AUD$' order by table_name;

2、截?cái)郃UD
truncate table aud$;

3、再次查詢并確認(rèn)
select segment_name,bytes/1024/1024 size_in_megabytes from dba_segments where segment_name='AUD$';