Oraclue

Oracle internals, debugging and undocumented features

Poor man Audit Vault

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 

Advertisements

4 responses to “Poor man Audit Vault

  1. Doug Burns February 19, 2009 at 7:55 pm

    “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…”

    Your memory serves you well.

  2. oraclue February 19, 2009 at 10:22 pm

    Thanks Doug.I am glad that you are reading this blog.

    Miladin

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: