20 Using LogMiner to Analyze Redo Log Files

Oracle LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. Redo log files contain information about the history of activity on a database.

See the following topics:

• LogMiner Benefits

• Introduction to LogMiner

• Using LogMiner in a CDB

• LogMiner Dictionary Files and Redo Log Files

• Starting LogMiner

• Querying V$LOGMNR_CONTENTS for Redo Data of Interest

• Filtering and Formatting Data Returned to V$LOGMNR_CONTENTS

• Reapplying DDL Statements Returned to V$LOGMNR_CONTENTS

• Calling DBMS_LOGMNR.START_LOGMNR Multiple Times

• Supplemental Logging

• Accessing LogMiner Operational Information in Views

• Steps in a Typical LogMiner Session

• Examples Using LogMiner

• Supported Data Types, Storage Attributes, and Database and Redo Log File Versions

You can use LogMiner from a command line or you can access it through the Oracle LogMiner Viewer graphical user interface. Oracle LogMiner Viewer is a part of Oracle Enterprise Manager. See the Oracle Enterprise Manager online Help for more information about Oracle LogMiner Viewer.