You direct LogMiner operations using the DBMS_LOGMNR and DBMS_LOGMNR_D PL/SQL packages, and retrieve data of interest using the V$LOGMNR_CONTENTS view, as follows:
1. Specify a LogMiner dictionary.
Use the DBMS_LOGMNR_D.BUILD procedure or specify the dictionary when you
start LogMiner (in Step 3), or both, depending on the type of dictionary you plan
2. Specify a list of redo log files for analysis.
Use the DBMS_LOGMNR.ADD_LOGFILE procedure, or direct LogMiner to create a
list of log files for analysis automatically when you start LogMiner (in Step 3).
Note: You must enable supplemental logging prior to generating
log files that will be analyzed by LogMiner.
When you enable supplemental logging, additional information is
recorded in the redo stream that is needed to make the information
in the redo log files useful to you. Therefore, at the very least, you
must enable minimal supplemental logging, as the following SQL
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
To determine whether supplemental logging is enabled, query the
V$DATABASE view, as the following SQL statement shows:
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
If the query returns a value of YES or IMPLICIT, minimal
supplemental logging is enabled. See Supplemental Logging on
page 17-21 for complete information about supplemental logging.
LogMiner Dictionary Files and Redo Log Files
Using LogMiner to Analyze Redo Log Files 17-5
3. Start LogMiner.
Use the DBMS_LOGMNR.START_LOGMNR procedure.
4. Request the redo data of interest.
Query the V$LOGMNR_CONTENTS view. (You must have the SELECT ANY
TRANSACTION privilege to query this view.)
5. End the LogMiner session.
Use the DBMS_LOGMNR.END_LOGMNR procedure.
You must have been granted the EXECUTE_CATALOG_ROLE role to use the LogMiner
PL/SQL packages and to query the V$LOGMNR_CONTENTS view.