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>)