Re: Deciphering Oracle REDO Log

Hi Mike,
I don't know how you are going to generate sql scripts from the redo logs since the redo log what is in the redo log are data blocks that was changed on the database ... the change can be caused by insert , delete , update , drop , or create .

The redo log doesn't contain the record of the statement that caused those changes but rather the before image of the changes that was done on the database for a specific SCN .

Of course I could be wrong .... if you find a way , I'll be very interested to know how ...

Ciao .

mike.stevens wrote:
>
> 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

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================