Oracle uses LOGMNR to analyze online redo logs

LOGMNR needs to be installed before it can be used.

Installation steps:

1. Install with the SYS user log-in execution of the following script
   

   @ORACLE_HOME/rdbms/admin/dbmslm.sql

   @ORACLE_HOME/rdbms/admin/dbmslmd.sql

Pre-use steps:

Set system parameters Utl_file_dir for storing data dictionary files

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

Generate the data dictionary file corresponding to the analyzed database, ensure that the information of the database ID in the online log or archive log is consistent with the data dictionary before analyzing correctly.

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:

1. Add an online log to analyze
   

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

2. Add additional online logs

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

3. Parsing the added Files

   EXEC dbms_logmnr.start_logmnr (dictfilename=> '/home/oracle/halee/logminer_dict.dat ');

4. Query the corresponding content

   SELECT * from V$logmnr_contents;

   Select Sql_redo from v$logmnr_contents where username = ' Halee ';
   

This article is from the "8016776" blog, please be sure to keep this source http://8026776.blog.51cto.com/8016776/1871011

Oracle uses LOGMNR to analyze online redo logs