Oracle LogMiner

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.

All changes made to user data or the database dictionary are recorded in the Oracle redo log files to perform database recovery operations. Because LogMiner provides a well-defined, easy-to-use, and comprehensive relational interface to redo log files, it can be used as a powerful data auditing tool and sophisticated data analysis tool. For key capabilities of LogMiner, refer to LogMiner Benefits in Oracle Database 19c Utilities or Oracle Database 23ai Utilities .

Oracle Autonomous Database supports LogMiner, with the following limitations:

• The DBMS_LOGMNR.ADD_LOGFILE and DBS_LOGMNR.REMOVE_LOGFILE procedures can not be used from an Autonomous Database.

• The dbms_logmnr.start_logmnr procedure can only be invoked with SCN or time range parameters. Querying the V$LOGMNR_CONTENTS view subsequently returns the data from the specified SCN or time range for the connected Autonomous Database.

• Only one LogMiner session is allowed per Autonomous Database.

• Autonomous Database archived log files are kept for 7 days. Therefore, LogMiner can only access up to 7 days of archived log files.

Note:

You must have the LOGMINING privilege to invoke start_logmnr.