Re: seeking advice/suggestions in regards to Oracle auditing

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/11
Message-ID: <01bbff8d$a78e19c0$276993cf@default>#1/1

In Sys.Aud table you have a TIMESTAMP field. You may want to make use of this field. You may want to follow these steps in your shell script

1) get the to_char(SYSDATE, 'YYYY-MM-DD-HH24-MI-SS') into a shell variable
2) Export the data from SYS.AUD$ Table.
3) Use DELETE Statement instead of TRUNCATE 
	DELETE FROM sys.aud$
	WHERE to_char(TIMESTAMP, 'YYYY-MM-DD-HH24-MI-SS') < your_variable;

This Procedure may take more time because of TO_CHAR and DELETE (Instead of TRUNCATE).
Through this procedure, you will not lose any data. It is possible that the records inserted in SYS.AUD$ table between the steps 1 and 2 might be duplicated.

-- 
Vijaya Kumar Vardhineni
Oracle DBA, EDS
Plano, TX

David J DeWolfe <sxdjd_at_orca.alaska.edu> wrote in article
<32D69782.53FB_at_orca.alaska.edu>...


> Hello all;

> 

> We are currently in the process of getting auditing configured in several

> of our 7.2.3 databases. We will be auditing to the database as OS

 auditing


> is not supported under Dec Alpha/Digital Unix. We've done the obvious,

 like 


> moving aud$ out of the system tablespace, and auditing aud$ itself. I

 would 


> appreciate any advice/suggesstions anyone may have in regards to issues

 and 


> concerns with auditing to the database. We do plan to have a process wake

 up 


> and check the % used of the audit tablespace and export/truncate aud$ if

 it has 


> reached a certain level, however, we wondering about audit records being 

> generated after the export and before the truncate and thereby losing

 audit 


> records. We have thought of copying records from aud$ to another table

 and then 


> deleting from aud$ by rowid etc. Again, any thoughts or suggestions would

 be 


> most appreciated.

> 

> TIA

> 

> 

> -- 

> 

> David J. DeWolfe

> Systems Programmer 

> Statewide Office of Information Services

> University of Alaska

> 907.474.7399

> sxdjd_at_orca.alaska.edu

> 

> In a vicious struggle for survival intelligence emerges as the weapon of 

>  choice. - Nova, In Search of Human Origins

>

Received on Sat Jan 11 1997 - 00:00:00 CST