1. Home
  2. Knowledge Base
  3. Security
  4. Oracle GoldenGate and Audit Vault working together!

Oracle GoldenGate and Audit Vault working together!

The Oracle GoldenGate Integrated Extract process will capture changes from the transaction logs (in the case of Oracle database, the redo log files) and then these are written to GoldenGate trail files in XML format.

Oracle Audit Vault and Database Firewall Transaction Log collector will forward transaction log records from generated XML files to the Audit Vault Server.

We can view the before and after values changed in the Data Modification Before-After Values report.

The Oracle database version needs to be 12.2.0.1 and higher and we can also capture and view the before and after values for DDL operations in the database as well.

Source: AVDF Release 20 Administrators Guide

In the Oracle GoldenGate Extract parameter file add the line

OUTPUTFORMAT XML _AUDIT_VAULT

EXTRACT ext1

USERIDALIAS oggadmin

OUTPUTFORMAT XML _AUDIT_VAULT

EXTTRAIL ./dirdat/lt

SOURCECATALOG pdb1

TABLE HCM.*;

Stop and start the extract ext1.

Connected as AVDF_ADM user , select the target DB01 and add an Audit Trail of type Transaction Log

Enter the full path of the GoldenGate trail files for the Audit Trail Location

Perform an UPDATE statement in the DB01 database

SQL> update hcm.employees set last_name=’Connor’ where employee_id=250;

1 row updated.

SQL> commit;

Commit complete.

Verify the GoldenGate extract process has captured the change

GGSCI (db01) 1> stats ext1 latest

Sending STATS request to EXTRACT EXT1 …

Start of Statistics at 2021-04-27 13:38:19.

Output to ./dirdat/lt:

Extracting from PDB1.HCM.EMPLOYEES to PDB1.HCM.EMPLOYEES:

*** Latest statistics since 2021-04-27 13:38:10 ***

Total inserts 0.00

Total updates 1.00

Total deletes 0.00

Total upserts 0.00

Total discards 0.00

Total operations 1.00

End of Statistics.

Connect as AVDF_AUD user and run the Data Modification Before-After Values report

We can see the UPDATE statement showing the old and new values for the LAST_NAME column.

Updated on June 22, 2021

Was this article helpful?

Related Articles

Leave a Comment