Transcription of Dissassembling the Oracle Redolog
{{id}} {{{paragraph}}}
Document Revision Date: 9/26/00 Page 1 of 9 Dissassembling the Oracle RedologThe Redolog is one of the most powerful features of the Oracle database, since it is the mechanism by whichOracle guarantees to be able to recover the database to the last committed transaction (provided thedatabase is in archive-log mode). What most DBA's do not know, is that the Redolog is also one of themost powerful debugging tools available, allowing the DBA to see the actual transactions, including thedata, that was executed against the this differs from the well known trace facilities, is that the Redolog is always on. Unlike tracing,which has be turned on in advance of a known problem, redologs faithfully capture every transaction,making them particularly useful in regulated production environments, or where problems cannot berecreated on demand.
Dissassembling the Oracle Redolog written by Graham Thornton Snr. Database Architect / Oracle DBA Document Revision Date: 9/26/00 Page 2 of 9 file, since a 4Mb redolog file will grow to 20Mb or more when dumped.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}