enable logminer

[Roshan]

Hi Erman,

I have executed the steps in doc below to enable logminer.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
EXECUTE DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);
EXECUTE DBMS_LOGMNR.START_LOGMNR(STARTTIME => SYSDATE -1/24,ENDTIME => SYSDATE, OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL + DBMS_LOGMNR.CONTINUOUS_MINE);

Ref: https://community.oracle.com/tech/developers/discussion/948629/ora-01371-complete-logminer-dictionary-not-found

Is it ok? If DB is restarted/ CDC tool is restarted should I restart logminer each time?

Thanks,

Roshan

[ErmanArslansOracleBlog]

When you enable supplemental logging in the oracle database, it will persist across reboots/bounces..

--Also you can see it yourself.. Check v$database.
--Enable the supplemental log , restart the db and query the appropriate columns in the V$DATABASE view to determine whether any supplemental logging is still enabled.. It will answer your question..

As for your other question, the tool that does the CDC , that executes the logminer should handle starting capturing changes.

If you are using Striim for this task, please visit https://www.striim.com/docs/en/oracle-configuration.html