In previous Oracle versions there were many different ways to setup auditing and separate auditing trails for components. There were also various layouts to the information provided within those audit trails. Oracle 12c introduces a new auditing framework where all auditing is written to a single repository and accessed by a single view. This framework is more secure and provides audit data in a single format. This option comes standard with Oracle Enterprise Edition, requires no additional license and is installed by default.

The new framework also allows you capture application context values and audit records from other sources such as:

• Oracle Database Real Application Security
• RMAN
• Oracle Database Vault
• Oracle Label Security
• Oracle Data Mining
• Oracle Data Pump
• Oracle SQL*Loader Direct Load
• Consolidating all these audit records into a single unified audit trail table.

The goal of this session is to briefly highlight the benefits of moving to the Unified Audit Trail (UAT) and provide a real-life example of steps taken to move from auditing as it was in pre-12c database versions to the Pure Mode unified auditing. We will review the default mixed-mode and the pure mode auditing, as well as the considerations and steps in switching modes. The major portion of this session will be on setting up managing audit records in the new framework and steps to assure you capture at least the same type of records as in your pre-12c environment.  The final part of the session will show how to setup policies for other resources utilizing RMAN and Data Pump examples.