I am trying to run a query on a database where logminer is enabled and is being used by a real-time replication tool for data movement but it gives me the following error:-
Select * from v$logmnr_contents;
ERROR at line 1:
ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from
Do I need to run the dbms_logmnr.start_logmnr
for selecting data from v$logmnr_contents even though logminer is already enabled in the database and the real time processes by etl tool are running fine?
Hi, you have to add all online redo log files for your logminer session you want to query. To add your log file thorugh for 1st one
exec dbms_logmnr.add_logfile(LogFileName => filename ,options => dbms_logmnr.new); and after that you can use dbms_logmnr.addfile.
Thanks & Regards, Hardik
Click Here to Expand Forum to Full Width