Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle XML Audit Trail - Purpose of adx_<SID>.txt

700063Aug 17 2009 — edited Aug 20 2009
Hi,

I am using Oracle 11.1.0.7.0 and Oracle 10.2.0.4 (with 8609347 patch on Windows) and I need to implement a custom script for XML audit trial archiving and management- using oracle audit vault and its features is not an option for me.

Scripts needs to be able to copy an XML audit trail file from admup directory after Oracle is finished writing to it.

In the adump directory, next to the audit trail files there is a file adx_<SID>.txt with following format of its content:

Format:
<Path to audit files direcotry>
<audit log file name>
<Path to audit files direcotry>
<audit log file name>


Example:
/u01/app/oracle/product/10.2.0/admin/DB01/adump
ora_28693.xml
/u01/app/oracle/product/10.2.0/admin/DB01/adump
ora_28760.xml


I would like to know what is the purpose of the adx_<SID>.txt file.
- Is it only some kind of a log file? (It is not used by an Oracle instance and if there are inconsistencies between this file and actual content of the adump directory it will make no harm to the running DB instance)
- Is it some sort of a state file? (It is used by an Oracle instance and its content is essential for the correct operations od the DB instance)

Is it OK to delete audit trail files listed in the adx_<SID>.txt which are not open by a running Oracle DB instance anymore?


Thanks

-----
XML audit trail default location and file name format below:
-----

XML audit trail default directory path example: /u01/app/oracle/product/10.2.0/admin/<InstanceName> /adump
XML audit trial file name format: db01_ora_4457_1.xml (<InstanceName>_<ProcessName>_<ProcessID>_<SerialNo>.<Extension>)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2009
Added on Aug 17 2009
2 comments
1,331 views