Logminer

From Oracle FAQ
Jump to: navigation, search

Oracle LogMiner is an Oracle database facility that allows data in redo log files to be extracted and analysed.

LogMiner is typically used to:

  • Track database changes for audit purposes
  • Undo user errors or logical corruption

After mining the logs, query the V$LOGMNR_CONTENTS view to list all logical change operation conducted on the database. The rows will contain both redo SQL and undo SQL.

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #