RDBPROD: Logging all access to a database using RMU/SET AUDIT and Logminer
(Doc ID 736865.1)
Last updated on JULY 18, 2018
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2.1 and later
HP OpenVMS Itanium
HP OpenVMS VAX
HP OpenVMS Alpha
This article describes a way to log every SELECT, INSERT, UPDATE and DELETE to a database. For auditing the SELECTs, the OpenVMS audit journal file is used via the functionality of RMU/SET AUDIT. However, the actual data selected is not available as this functionality does not exist in RMU/SET AUDIT. For INSERT, UPDATE and DELETE, the Rdb Logminer (static or continuous) is used, where the data inserted, updated or deleted is available. For this procedure, Oracle Rdb 7.2.1 or higher is required, since the username is not available to Rdb Logminer in earlier releases. For older versions of Oracle Rdb, see the procedure described in RDBPROD: How to Track Ownership of All Changes within a Database using Logminer.
For this procedure, to ensure there is no performance impact on the original database, all logging data is stored in a separate database, which should be located on disk(s) separate from the original database.
The procedure demonstrated below uses an example database with 2 simple tables.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!