Miladin Modrakovic's Blog: Oraclue

Everyone knows how to enable database auditing .That’s for sure.But to make auditors happy is another story.One of the requirements is that all these data  from the source should be  stored somewhere else.. but not on source ..

If you have plenty of money you can get  Oracle audit wault.But if you don’t   than you make your own audit wault  using Oracle Streams.I called it Poor man audit wault.There is metalink note DML and DDL Auditing Using Streams which explains this into detail.

I run into this presentation many months ago and again today..  What trigger my attention is that  if I correctly remember audit vault use same technology beneath  to offload data and load into vault data warehouse database…

Principle is simple.Streams capture process run of different database .Not on the one where redo is generated.This feature is called Downstream capture.Redo logs are transfered to different database and mined by capture process.All auditing work can be offloaded to downstrem database.

Metalink Note: 316893.1

and also :

https://www.dbguide.net/servlet/com.util.DownloadServlet?file=%2F20060316%2F1142486648994.pdf&filename=DDL+DML%BF%A1+%B4%EB%C7%D1+%B0%A8%BB%E7.pdf