How to configure Logminer in oracle step by step


Logminer is a utility provided with the Oracle database server which mines the redologs or Archivelogs and data dictionary information to build the SQL statements and keeps the contents of the redolog file in the fixed view called ” V$logmnr_contents “.
LogMiner tool can help the DBA to the find changed records in redo log files by using a set of PL/SQL procedures and functions .
Internally Oracle uses the Log Miner technology for several other features,such as Flashback Transaction Backout,Streams, and Logical Standby Databases .Most often LogMiner is used for recovery purpoRead more