星期一, 3月 27, 2017

[轉載]11G ving the Database Audit Trail to a Different Tablespace

 

[轉載]11G ving the Database Audit Trail to a Different Tablespace

ref: https://oracle-base.com/articles/11g/auditing-enhancements-11gr2

 

CONN / AS SYSDBA

 

SELECT table_name, tablespace_name

FROM   dba_tables

WHERE  table_name IN ('AUD$', 'FGA_LOG$')

ORDER BY table_name;

 

TABLE_NAME                     TABLESPACE_NAME

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

AUD$                           SYSTEM

FGA_LOG$                       SYSTEM

 

SQL>

 

Next, create a new tablespace to hold the audit trail.

 

CREATE TABLESPACE audit_aux

  DATAFILE '/u01/app/oracle/oradata/DB11G/audit_aux01.dbf'

  SIZE 1M AUTOEXTEND ON NEXT 1M;

 

Then we move the standard audit trail to the new tablespace.

 

BEGIN

  DBMS_AUDIT_MGMT.set_audit_trail_location(

    audit_trail_type           => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,

    audit_trail_location_value => 'AUDIT_AUX');

END;

/

 

PL/SQL procedure successfully completed.

 

SQL>

 

-- Check locations.

SELECT table_name, tablespace_name

FROM   dba_tables

WHERE  table_name IN ('AUD$', 'FGA_LOG$')

ORDER BY table_name;

 

TABLE_NAME                     TABLESPACE_NAME

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

AUD$                           AUDIT_AUX

FGA_LOG$                       SYSTEM

 

SQL>

Next we move the fine-grained audit trail.

 

BEGIN

  DBMS_AUDIT_MGMT.set_audit_trail_location(

    audit_trail_type           => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,

    audit_trail_location_value => 'AUDIT_AUX');

END;

/

 

PL/SQL procedure successfully completed.

 

SQL>

 

-- Check locations.

SELECT table_name, tablespace_name

FROM   dba_tables

WHERE  table_name IN ('AUD$', 'FGA_LOG$')

ORDER BY table_name;

 

TABLE_NAME                     TABLESPACE_NAME

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

AUD$                           AUDIT_AUX

FGA_LOG$                       AUDIT_AUX

 

SQL>

 

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...