END_LOGMNR;
The available subprograms for the DBMS_LOGMNR package are described in Table 14-1.
Table 14-2 shows the parameters for the START_LOGMNR procedure.
Subprogram Description
ADD_LOGFILE Adds a file to the list of archive files to process
START_LOGMNR Initializes the LogMiner utility
END_LOGMNR Completes and ends a LogMiner session
MINE_VALUE (function) Returns the undo or redo column value of the
column name specified by the COLUMN_NAME
parameter for any row returned from V$LOGMNR_
CONTENT
COLUMN_PRESENT (function) Determines if undo or redo column values exist
for the column name specified by the COLUMN_
NAME parameter for any row returned from
V$LOGMNR_CONTENT
REMOVE_LOGFILE Removes a log file from the list of log files to be
processed by LogMiner
TABLE 14-1 DBMS_LOGMNR Subprograms
Chapter 14: Miscellaneous High Availability Features 503
To create a list of the redo log files that are available for analysis, you run the procedure
DBMS_LOGMNR.ADD_LOGFILE with the NEW option as follows; this example uses a Linux
file system:
execute DBMS_LOGMNR.ADD_LOGFILE(
LogFileName=> '/oracle/ora10/redo01.ora',
Options=> DBMS_LOGMNR.NEW);
execute DBMS_LOGMNR.ADD_LOGFILE(
LogFileName=> '/oracle/ora10/redo02.ora',
Options=> DBMS_LOGMNR.NEW);
Options Description
COMMITTED_DATA_ONLY Only DMLs corresponding to committed transactions
are returned if this option is set.
SKIP_CORRUPTION Skips any corruption encountered in the redo log file
during a select from V$LOGMNR_CONTENTS.
Pages:
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761