{"id":135,"date":"2008-11-30T14:59:00","date_gmt":"2008-11-30T12:59:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/11\/30\/oracle-logminer\/"},"modified":"2010-08-24T22:42:36","modified_gmt":"2010-08-24T20:42:36","slug":"oracle-logminer","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/11\/30\/oracle-logminer\/","title":{"rendered":"ORACLE LOGMINER"},"content":{"rendered":"<ol>\n<li>uruchomi\u0107 baz\u0119 w trybie ARCHIVELOG<\/li>\n<li>dopisa\u0107 do pliku INIT paramter wskazuj\u0105cy na katalog gdzie b\u0119dzie sk\u0142adowany s\u0142ownik<br \/>UTL_FILE_DIR='[dir_path]&#8217;<\/li>\n<li>ustawi\u0107 szczeg\u00f3\u0142owo\u015b\u0107 logowania informacji w redo logach:<br \/>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;<br \/>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;<br \/>SELECT supplemental_log_data_min FROM v$database;<br \/>SELECT supplemental_log_data_all FROM v$database;<\/li>\n<li>wyeksportowa\u0107 s\u0142ownik:<br \/>do pliku:<br \/>execute DBMS_LOGMNR_D.BUILD('[dict_file&#8217;],'[dict_file_dir_path]&#8217;);<br \/>do redolog\u00f3w:<br \/>execute DBMS_LOGMNR_D.BUILD(Options=>DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);<br \/>SELECT * FROM v$logmnr_dictionary;<\/li>\n<li>dodanie plik\u00f3w archiwalnych do analizy:<br \/>execute DBMS_LOGMNR.ADD_LOGFILE(Options=>dbms_logmnr.new,LogFileName=>'[archive_log_path]&#8217;);<br \/>DBMS_LOGMNR.ADD_LOGFILE(Options=>dbms_logmnr.addfile,LogFileName=>'[archive_log_path]&#8217;);<br \/>DBMS_LOGMNR.REMOVE_LOGFILE(LogFileName=>'[archive_log_path]&#8217;);<br \/>SELECT * FROM v$logmnr_logs;<\/li>\n<li>uruchamianie:<br \/>execute DBMS_LOGMNR.START_LOGMNR(DictFileName=>'[dict_file_path]&#8217;);<br \/>lub w okre\u015blonych ramach czasowych<br \/>execute DBMS_LOGMNR.START_LOGMNR(DictFileName=>'[dict_file_paht]&#8217;, StartTime=>TO_DATE(&#8217;15-01-2008 08:00:00&#8242;,&#8217;DD-MM-YYYY HH24:MI:SS&#8217;, EndTime=>TO_DATE(&#8217;15-01-2008 14:00:00&#8242;,&#8217;DD-MM-YYYY HH24:MI:SS&#8217;));<\/li>\n<li>sprawdzanie wynik\u00f3w:<br \/>SELECT username,sql_redo,sql_undo FROM v$logmnr_contents WHERE username='[username]&#8217;;<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>uruchomi\u0107 baz\u0119 w trybie ARCHIVELOG dopisa\u0107 do pliku INIT paramter wskazuj\u0105cy na katalog gdzie b\u0119dzie sk\u0142adowany s\u0142ownikUTL_FILE_DIR='[dir_path]&#8217; ustawi\u0107 szczeg\u00f3\u0142owo\u015b\u0107 logowania informacji w redo logach:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;SELECT supplemental_log_data_min FROM v$database;SELECT supplemental_log_data_all FROM v$database; wyeksportowa\u0107 s\u0142ownik:do pliku:execute DBMS_LOGMNR_D.BUILD('[dict_file&#8217;],'[dict_file_dir_path]&#8217;);do redolog\u00f3w:execute DBMS_LOGMNR_D.BUILD(Options=>DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);SELECT * FROM v$logmnr_dictionary; dodanie plik\u00f3w archiwalnych do [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[53],"class_list":["post-135","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-logminer"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":198,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions\/198"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}