Re: Large sys.aud$
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: Tom.Terrian.ctr@xxxxxxx
- Date: Mon, 8 Dec 2008 14:36:32 +0100
Depending on your company's budget you have available for this, you may
consider giving Oracle Audit Vault a shot. It does just that.
Stefan
=========================
Stefan P Knecht
Senior Consultant
Systems Engineering
OPITZ CONSULTING Schweiz GmbH
Seestrasse 97
CH-8800 Thalwil
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxxxxxxxxx
http://www.opitz-consulting.ch
OCP 9i/10g SCSA SCNA
=========================
On Mon, Dec 8, 2008 at 1:32 PM, Terrian, Thomas J Mr CTR DLA J6DIB <
Tom.Terrian.ctr@xxxxxxx> wrote:
> All, we have a requirement to keep 1 year worth of audit records. I am
> kicking around the idea of hourly moving all of the sys.aud$ records
> from each production database to a central database. That way it would
> keep sys.aud$ small for each database.
>
> However, this will have its own set of complications......I would have
> to build new dba_audit views on the central database (in order to have a
> database name field), what happens when the structure of sys.aud$
> changes between database versions, etc.
>
> Has anyone tackled something like this already?
>
> Another option would be to forget about the repository database idea
> .....instead hold 1 months worth of data online for each database and
> storing the other 11 months offline somewhere (maybe use RMAN for
> this?).
>
> Again, any ideas?........
>
> Thanks,
> Tom Terrian
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
