Mining Redo Log Files
Just when you DBAs think things are a bit too quiet and harmonious, someone walks into your cubicle to announce that they’ve done a silly thing and need the DBA to come to their rescue. For example, a developer may have forgotten to place a WHERE clause on a DELETE command and thus deleted all the rows from a table rather than just a select few. Beginning with 8i, Oracle provides a set of packages to make such transaction recoveries possible. But to use the DBMS_LOGMINER packages without a GUI is a tedious and garish exercise at best. So again TOAD comes to the rescue with the DBMS_LOGMINER Interface screen shown in Figure 6.63 and accessible from the main menu at DBA|Log Miner.
Figure 6.63. TOAD DBMS_LOGMINER Interface ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
