How To Move The DB Audit Trails To A New Tablespace
In this Document
Goal |
Fix |
References |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 20-FEB-2013***
GOAL
How to move the database audit trail tables( SYS.AUD$ & SYS.FGA_LOG$) to another tablespace using DBMS_AUDIT_MGMT?
FIX
1) Check the current tablespace of the audit trail tables:
SQL> SELECT table_name, tablespace_name FROM dba_tables
WHERE table_name IN ('AUD$', 'FGA_LOG$') ORDER BY table_name; 2
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
AUD$ SYSAUX
FGA_LOG$ SYSAUX
2) Check the current size of two tables:
SEGMENT_NAME SIZE_IN_MEGABYTES
------------------- -----------------------------
AUD$ 12
FGA_LOG$ .0625
3) Create a new tablespace and make sure that it's size is large enough for the tables that will be moved:
Tablespace created.
4) Move the audit trail tables using procedure DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,--this moves table AUD$
audit_trail_location_value => 'AUDIT_TBS');
END;
/
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,--this moves table FGA_LOG$
audit_trail_location_value => 'AUDIT_TBS');
END;
/
PL/SQL procedure successfully completed.
4) Check whether the tables were moved successfully:
WHERE table_name IN ('AUD$', 'FGA_LOG$') ORDER BY table_name;
TABLE_NAME TABLESPACE_NAME
----------------------- ------------------------------
AUD$ AUDIT_TBS
FGA_LOG$ AUDIT_TBS
NOTE :
=======
The requirement for the introduction of this package came from Audit Vault. Currently it is not supported to use the DBMS_AUDIT_MGMT package on a pre 11gR2(11.2.0.1) instance which is not an Audit Vault source database. Its features include the purge of audit records and can be used to move the audit tables AUD$ and FGA_LOG$ to another tablespace.
Audit Trails with dbms_audit_mgmt, which has been officially introduced/supported in Oracle 11g R2.
REFERENCES
NOTE:1299033.1 - Master Note For Oracle Database AuditingNOTE:731908.1 - New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information
NOTE:804624.1 - Known Issues When Using: DBMS_AUDIT_MGMT
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20747382/viewspace-2130683/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- how to move a MediaWiki wiki from one server to anotherServer
- How to Add a New Disk new partition in centos7CentOS
- ORACLE AUDITOracle
- 題解:CF1970E1 Trails (Easy)AI
- mysqlalchemy audit extensionMySql
- audit by user by table
- Oracle Audit setupOracle
- ncurses皮膚庫:new_panel(),doupdate(),show_panel(),hide_panel(),move_panel(),del_panel()...IDE
- Oracle OCP(48):UNDO TABLESPACEOracle
- MySQL 5.7 InnoDB Tablespace EncryptionMySql
- WPF mvvm canvas move elements via mouse down, up and move eventsMVVMCanvas
- AUDIT審計(2)
- MySQL審計auditMySql
- LeetCode—283—Move ZeroesLeetCode
- Tablespace表空間刪除
- oracle 分割槽表move和包含分割槽表的lob moveOracle
- fluentd 推送 mariadb audit log
- ORACLE AUDIT審計(1)Oracle
- 2.2.6 Overview of Common Audit ConfigurationsView
- linux監控工具auditLinux
- SQL Server 審計(Audit)SQLServer
- offline tablespace 的幾種方式 (轉)
- WPF Image zoomin zoomout moveOOM
- How to ssh
- new self()與new static()
- mysql5.7 General tablespace使用說明MySql
- alter tablespace ts_name autoextend_clause
- 【TABLESPACE】Oracle表空間最佳實踐Oracle
- alter table move與shrink space
- Office365 OneDrive Geo Move
- 12C 線上MOVE
- SAP Move to Rise是什麼意思? SAP Move的五條路徑是什麼?
- [20190530]oracle Audit檔案管理.txtOracle
- How to find dependency
- 2.6.8.2 UNDO_TABLESPACE 初始化引數
- unlimited tablespace許可權的授予和回收MIT
- 【TABLESPACE】Oracle 表空間結構說明Oracle
- New
- 每週一算:Move ZerosROS