ORACLE_LogMiner
Perry705
OCM
展开
-
LogMiner
一. Logminer 说明 Oracle LogMiner 的官网说明: Using LogMiner to Analyze Redo Log Files http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/logminer.htm#SUTIL019 Lo翻译 2014-10-16 11:27:49 · 388 阅读 · 0 评论 -
LogMiner脚本
#!/bin/bashsqlplus / as sysdba spool spool.logexecute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');execute dbms_logmnr.原创 2014-10-17 10:31:58 · 348 阅读 · 0 评论 -
LogMiner 示例
LogMiner 示例 在做实验之前,检查下suppplemental logging: SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;SUPPLEME--------YES 如果是YES 或者IMPLICIT则表明已经生效了,否则需要启动:SQL> ALTER DATABASE ADD S转载 2014-10-16 12:36:08 · 358 阅读 · 0 评论 -
LogMiner_DDL_DICT_TRACKING
#!/bin/bashsqlplus / as sysdba spool spool.logexecute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log',options => dbms_logmnr_d.store_原创 2014-10-17 12:06:04 · 702 阅读 · 0 评论 -
LogMiner_Online_Catalog
#!/bin/bashsqlplus / as sysdba spool spool.logalter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';select sysdate from dual;EXECUTE DBMS_LOGMNR.START_LOGMNR(STAR原创 2014-10-17 10:39:26 · 524 阅读 · 0 评论 -
LogMiner_Automatically
#!/bin/bashsqlplus / as sysdba spool spool.logexecute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');alter session set nls_da原创 2014-10-17 10:37:24 · 329 阅读 · 0 评论 -
LogMiner Dictionary Files and Redo Log Files
LogMiner Dictionary Files and Redo Log FilesBefore you begin using LogMiner, it is important to understand how LogMiner works with the LogMiner dictionary file (or files) and redo log files. This原创 2015-06-30 10:45:09 · 478 阅读 · 0 评论 -
Starting LogMiner
Starting LogMinerYou call the DBMS_LOGMNR.START_LOGMNR procedure to start LogMiner. Because the options available with the DBMS_LOGMNR.START_LOGMNRprocedure allow you to control output to the原创 2015-06-30 11:27:23 · 405 阅读 · 0 评论 -
LogMiner by Example
LogMiner by Exampleby Jeff Hunter, Sr. Database AdministratorContentsIntroductionRequirementsCopying V$LOGMNR_CONTENTSScenario 1: Extract LogMiner Dictionary to a Flat FileScenario 2:转载 2015-06-30 23:36:11 · 676 阅读 · 0 评论