Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Omar.

Asked: June 23, 2020 - 8:02 am UTC

Answered by: Connor McDonald - Last updated: June 26, 2020 - 4:19 am UTC

Category: Database Administration - Version: 11g

Viewed 100+ times

You Asked

can i start logminer once across one connection, reuse it in realtime. meaning that the V$LOGMNR_CONTENTS view gets updated in realtime without having to end logminer session and build it again?
Thank you

and we said...

Not real time, but you can do DBMS_LOGMNR.ADD_LOGFILE whenever you want in a session, even if you have already started log miner, and you do not have to do an END.

ie, you can do:

dbms_logmnr.add_logfile
dbms_logmnr.add_logfile
dbms_logmnr.add_logfile
dbms_logmnr.start_logmnr

and query V$LOGMNR_CONTENTS and then do

dbms_logmnr.add_logfile
dbms_logmnr.add_logfile

without needing to run dbms_logmnr.end_logmnr

You might see a "CONTINUOUS_MINE" option in the docs which automatically add log files. I'd recommend against that because it is de-supported in later releases.

and you rated our response

  (1 rating)

Reviews

follow up on the logmimer question

June 24, 2020 - 1:40 pm UTC

Reviewer: Omar from Egypt

is it possible to start the logminer with endtime option using future date and could u please elaborate on which version does the de-support of the 'CONTINUOUS_MINE' option start
Connor McDonald

Followup  

June 26, 2020 - 4:19 am UTC

12c deprecated.
19c desupported.

start_time / end_time are optional - and thus you should be able to mine all logfiles that you have added via "add_logfile"

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.