Perry

一.  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

#!/bin/bashsqlplus / as sysdba spool spool.logexecute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');execute dbms_logmnr.

LogMiner 示例 在做实验之前，检查下suppplemental logging：  SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;SUPPLEME--------YES 如果是YES 或者IMPLICIT则表明已经生效了，否则需要启动：SQL> ALTER DATABASE ADD S

#!/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_

#!/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

#!/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

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

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 

LogMiner by Exampleby Jeff Hunter, Sr. Database AdministratorContentsIntroductionRequirementsCopying V$LOGMNR_CONTENTSScenario 1: Extract LogMiner Dictionary to a Flat FileScenario 2: