This is a quick note about using LogMiner for mining archived redo logs on the database itself. (Source and mining databases are same)
- Specify a dictionary file with the following procedure:
EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle/acs/logmnr', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);
- Determine the minimum and maximum archived log sequences that is in the mining scope.
- Specify one archived log file with DBMS_LOGMNR.ADD_LOGFILE procedure, dbms_logmnr.NEW option. Then we can add other archived log sequences with dbms_logmnr.ADDFILE option:
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '+ARCH1/xx/archivelog/2013_01_28/thread_2_seq_31844.932.805914077', OPTIONS => dbms_logmnr.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '+ARCH1/xxx/archivelog/2013_01_28/thread_2_seq_31844.932.805914077', OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '+ARCH1/xxx/archivelog/2013_01_28/thread_2_seq_31845.1334.805914145', OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '+ARCH1/xxx/archivelog/2013_01_28/thread_2_seq_31846.1062.805914271', OPTIONS => dbms_logmnr.ADDFILE);
- Start LogMiner with the EXECUTE DBMS_LOGMNR.START_LOGMNR procedure:
EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME =>'/oracle/acs/logmnr/dictionary.ora');
- It's also possible to start LogMiner by specifying a time or SCN range:
EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME => '/oracle/acs/logmnr/dictionary.ora', STARTTIME => to_date('01-Jan-2013 08:30:00', 'DD-MON-YYYY HH:MI:SS'), - ENDTIME => to_date('01-Jan-2013 08:45:00', 'DD-MON-YYYY HH:MI:SS'));- Now it's possible to query details about the operations inside archived logs. We can use V$LOGMNR_CONTENTS view for this purpose. However it may be slow to return data because it'll do log file sequential read. If several queries will be run for mining log, it'll be better to create a table by selecting all from V$LOGMNR_CONTENTS view.
CREATE TABLE ORAMINE.LOGMNR as select * from v$logmnr_contents;- OWhen we're finished with LogMiner, we can stop it with the following procedure:
EXECUTE DBMS_LOGMNR.end_logmnr;
Nice & helpful! I suppose you know that in recent versions (9i onwards, if I recall that right), you don't need a dictionary file anymore:
begin dbms_logmnr.start_logmnr(options=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
end;
Just as additional information :)
Kind regards
Uwe
Thanks for the information Uwe. I didn't know that..
Hi, Nice Basic Oracle Log Miner Steps.Thanks, its really helped me......
-Aparna
Theosoft
This info you provided in the blog that was really unique I love it!!
Oracle Training in Chennai
Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
oracle fusion financials online training
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Oracle Fusion Financials Online Training if you want more information.
Oracle Fusion Financials Online Training
Thanks for sharing a useful information.. we have learnt so much information from your blog..... keep sharing
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
python training in Bangalore
Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable informations..
Oracle DBA Online Training
I was recommended this web site by means of my cousin. I am now not certain whether this post is written through him as nobody else recognise such precise about my difficulty. You're amazing! Thank you!
ReactJS Online Training
Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had a lot of information All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
Sql server dba online training
Nice article
For Data Science training in Bangalore, Visit:
Data Science training in Bangalore
Great article.
spark interview questions
Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
sem training in hyderabad
seo training in hyderabad
SMM Training In Hyderabad
Very good article, very nice information, thanks for sharing.
Regards
Tirupati darshan online booking
Tirupati darshan online booking
Tirupati package from Bangalore
Best Tirupati package from Bangalore
Tirupati darshan package from Bangalore
Tirupati tour package from Bangalore
Very good article, very nice information, thanks for sharing.
Regards
Tirupati darshan online booking
Tirupati darshan online booking
Tirupati package from Bangalore
Best Tirupati package from Bangalore
Tirupati darshan package from Bangalore
Tirupati tour package from Bangalore
Informative blog post. Thanks for this useful Post. oracle training in chennai
Nice Article!
Software Testing Course
Air Hostess Course
Data Science Course
Clinica Research Courses
Cabin Crew Course
Ground Staff Course
React Js Course
Dot Net Course
Php Course
Java Course
Medical Coding Course
Wow, amazing post! Really engaging, thank you.
Data Science Training In Bangalore
Best Data Science Training Institute in Bangalore
Thanks for crafting this beautiful information. I’m thankful and humbled to you. This is the best blog I have ever read. I’m going to make sure that I will share. Rubix Market Research
Thanks for crafting this beautiful information. I’m thankful and humbled to you. This is the best blog I have ever read. I’m going to make sure that I will share. Rubix Market Research
Infycle Technologies, the
No.1 software training institute in Chennai offers the leading Python course in Chennai for tech professionals and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.
Thanks for providing valuable information, keep posted Spoken English Course In Pune
Amazing write-up always finds something interesting.aws training in pune