Shulou(Shulou.com)06/01 Report--

Logmnr must be installed before it can be used.

Installation steps:

Execute the following script to install as a sys user login

@ ORACLE_HOME/rdbms/admin/dbmslm.sql

@ ORACLE_HOME/rdbms/admin/dbmslmd.sql

Steps before use:

Set the system parameter utl_file_dir to store data dictionary files

Alter system set utl_file_dir='/home/oracle/halee' scope=spfile

Generate the data dictionary file corresponding to the analyzed database to ensure that the database ID and other information in the online log or archived log are consistent with the data dictionary before the correct analysis

Call dbms_logmnr_d package generation

Execute dbms_logmnr_d.build (dictionary_filename= > 'logminer_dict.dat',dictionary_location= >' / home/oracle/halee')

Call logmnr for analysis:

Add online logs that require analysis

Exec dbms_logmnr.add_logfile (logfilename= >'/ home/oracle/redo01.log',options= > dbms_logmnr.new)

Add additional online logs

Exec dbms_logmnr.add_logfile (logfilename= >'/ home/oracle/redo02.log',options= > dbms_logmnr.addfile)

Analyze added files

Exec dbms_logmnr.start_logmnr (DictFileName= >'/ home/oracle/halee/logminer_dict.dat')

Query the corresponding content

Select * from v$logmnr_contents

Select sql_redo from v$logmnr_contents where username = 'Halee'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.