Oracle LogMiner

LogMiner, which is part of Oracle AI 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 AI Database 26ai Utilities.

Oracle Autonomous AI 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 AI 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 AI Database.

• Only one LogMiner session is allowed per Autonomous AI Database.

• Autonomous AI 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.