When the LogMiner Viewer
Console screen is displayed, create an object query by either clicking the top icon in the icon
panel or selecting Create Query from the Object pull-down menu. The LogMiner Viewer
automatically looks for available archived redo log files from which to create a query. If there are
no archived redo log files available, you receive an error message. You can create filtering options
(by creating query criteria), see the beginning and ending SCN for each redo log file available,
and choose the columns to display. The OEM LogMiner Viewer may simplify the process of sifting
through the log file contents. Additionally, you can use the Grid Control screens to access and
view the LogMiner output.
LogMiner Features Introduced in Oracle Database 10g
If you have used LogMiner with versions that preceded Oracle Database 10g, the following
enhancements are now available to you.
Chapter 14: Miscellaneous High Availability Features 505
As shown earlier in Table 14-1, DBMS_LOGMNR now has a REMOVE_LOGFILE procedure
that removes files from the list to be analyzed. You should no longer use the REMOVEFILE option
of the ADD_LOGFILE procedure.
You can use the NO_ROWID_IN_STMT option (refer back to Table 14-2) of START_LOGMNR
to filter out the rowid clause from reconstructed SQL commands.
You can expand supplemental logging via the alter database command to include foreign key
or all changes for rows. Using these settings will increase the amount of data written to the redo
log files.
Pages:
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764