enable logminer

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/enable-logminer-tp9406.html

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