Introduction to Oracle logminer

Oracle logminer is a tool used to analyze archived logs. Here I will list a simple and efficient use process.

1. initialize parameter configuration

Alter system set utl_file_dir = '*' scope = both;

This requires a restart to take effect.

SQL> show parameter utl_file_dir

NAME TYPE

--------------------------------------------------------------------

VALUE

------------------------------

Utl_file_dir string

*

SQL>

2. Create a data dictionary

EXECUTE dbms_logmnr_d.build ('dictionary. ora ','/u01/home/oracle /');

SQL> EXECUTE dbms_logmnr_d.build ('dictionary. ora ','/u01/home/oracle /');

PL/SQL procedure successfully completed.

SQL> host;

[Oracle @ rac1 ~] $ Ls-ltr dictionary. ora

-Rw-r -- 1 oracle oinstall 27267751 May 7 dic40 dictionary. ora

[Oracle @ rac1 ~] $

1 2 Next Page