Re: Where get Logminer???

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Fri, 22 Sep 2000 0:41 -0500
Message-Id: <10626.117623@fatcity.com>

Hi,
I have tried this on Oracle 8i enterprise edition.

The Oracle utility LogMiner allows you to read  information contained in online and archived redo logs based on selection criteria.

1. Set the init.ora parameter UTL_FILE_DIR= /oracle/logs (any valid directory). Restart the database.
2. Using the dbms_logmnr._d.build procedure within a package create a dictionary file. This has to be executed at the <svrmgrl> prompt . (after connecting as internal) EXECUTE dbms_logmnr_d.build( dictionary_filename =>'dictionary.ora', dictionary_location => '/oracle/logs');
3. Add logfiles. execute dbms_logmnr.add_logfile( LogFileName => '/oracle/logs/log1.f', Options => dbms_logmnr.NEW);

    NEW is used to create a list of logs.

4) execute dbms_logmnr.add_logfile(

     LogFileName => '/oracle/logs/log2.f',
     Options => dbms_logmnr.ADDFILE);                     Addfile

option is used to add logfiles.

5) In case you want to remove logfiles from the list use the removefile option.

6) Start the logminer process

               execute dbms_logmnr.start_logmnr(
     DictFileName =>'/oracle/dictionary.ora');

7) Now check v$logmnr_contents table. Especially sql_redo,username,sql_undo columns.

For more details Check the Administrators guide Chapter 7 and Oracle supplied packages
refrence guide . Chapter 19 and chapter 20.

Hope this helps. Received on Fri Sep 22 2000 - 00:41:18 CDT