Step 0: LogMiner Tools Installation
Log in as sysdba,
1) create dbms_logmnr package to analyze log files;
SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql
2) create dbms_logmnr_d package to create dictionary files.
SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
Step 1: Edit Parameter File
If you startup database using pfile, edit pfile directly;
If you startup database using spfile,
SQL> create pfile from spfile;
Edit init<SID>.ora and put the following:
utl_file_dir=/u01/app/oracle/admin/<SID>/udump
Step 2: Verify utl parameter
SQL> connect / as [...]
Filed under: Oracle Tools | Tagged: Logminer, Redo Log, Workshop | Leave a Comment »
