Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Sometimes Dbvisit support will ask for a row history, also known as LogMiner dump. This means running LogMiner on the archive/online redo logs to obtain all changes on a particular row.

Setting up

...

LogMiner

First, guess the date (or directly SCN) range of interest. This is often constrained by archive logs available (only archive logs still known to the database are used by default).

...

   OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.CONTINUOUS_MINE
   );
end;

Querying the

...

LogMiner data

After executing START_LOGMNR, the Logminer LogMiner data is available via

SELECT *

...