Re: Deciphering Oracle REDO Log

I'd be surprised if you can get the original text of the SQL statements from the redo log at all !

The redo log contains the "after images" of changed database blocks - i.e. what bits & pieces of the database files look like after one (or more) transactions.

It may be compressed to - but I doubt it.

Are you sure that auditing can't do want you want ? Auditing won't be able to give you the full text of SQL statements, but will be able to tell you who's been where and done (roughly) what.

Lacking that, look at database triggers - they are often used to get more detailed information that Oracle Auditing can provide.

I've heard that Trusted Oracle should be stronger on the auditing side - but I never tried Trusted Oracle.

Hope this helps

--
Karl
Oracle Certified DBA
mike.stevens wrote in message <01bd217a$908c9160$5b2637a6_at_default>...


>I am interested in writing a program that generates the original SQL

>statements from the REDO log.  The REDO log appears to be in some sort 

 of


>binary format.  Does anyone know if it's just compressed or if there is 

 a


>way to decipher it?  Any help would be greatly appreciated.

>

>mike.stevens_at_mci2000.com

>

>


--