Article Content
Article Number | 000029915 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: All Platform (DB): Oracle 11.x, 12.x |
Issue | The Oracle database audits certain SQL commands and connections and logs this information into audit files (.aud) on the Linux file system. These files accumulate over time and should periodically be cleaned up to regain disk space. Because of certain audit requirements, attempts to archive or purge these files using normal commands may fail. For example, using a typical tar command would result in a too many arguments error. This RSA Knowledge Base Article explains how to use the tar command to create a gzipped tar file of the audit files without error. |
Resolution | To create a gzipped tar file of the .aud files in the audit directory, follow these steps:
The .aud files are located in the directory specified by the audit_file_dest parameter. Login to SQL*Plus as SYSDBA
The default value is $ORACLE_HOME/admin/{SID}/adump. (in this example, $ORACLE_HOME/admin/AVDB/adump.) NOTE: Audit logs may also be found in $ORACLE_HOME/product/{version}/db_1/rdbms/audit.
As the oracle or root user
|