27
DBMS_LOGMNR_D

DBMS_LOGMNR_D contains the LogMiner procedure, DBMS_LOGMNR_D.BUILD, used to create the LogMiner dictionary file. This procedure extracts the dictionary either to the redo log files or to a flat file.

This information is saved in preparation for future analysis of redo log files using the LogMiner tool.

This chapter discusses the following topics:

Extracting a Dictionary to the Redo Log Files

To extract a dictionary file to the redo log files, the following conditions must be met:

The DBMS_LOGMNR_D.BUILD procedure must be run on a system that is running Oracle9i or later
Archiving mode must be enabled in order to generate usable redo
Oracle9i compatibility must be employed
The mining system must be Oracle9i or later
The dictionary redo files must be created from the same database that generated the redo log files you want to analyze

The DBMS_LOGMNR_D.BUILD procedure will not run if there are any ongoing DDL operations.

Additionally, while the procedure is executing, no DDL operations are allowed.

Extracting a Dictionary to a Flat File

When extracting a dictionary to a flat file, the procedure queries the dictionary tables of the current database and creates a text-based file containing the contents of the tables.

To extract a dictionary to a flat file, the following conditions must be met:

The dictionary file must be created from the same database that generated the redo log files you want to analyze

You must specify a directory for use by the PL/SQL procedure. To do so, set the initialization parameter UTL_FILE_DIR in the init.ora file. For example:
```
UTL_FILE_DIR = /oracle/dictionary
```
If you do not set this parameter, the procedure will fail.
You must ensure that no DDL operations occur while the dictionary build is running. Otherwise, the dictionary file may not contain a consistent snapshot of the data dictionary.

Examples of Using DBMS_LOGMNR_D.BUILD

The DBMS_LOGMNR_D package contains one procedure, DBMS_LOGMNR_D.BUILD. For a complete description of this procedure, see DBMS_LOGMNR_D.BUILD Procedure .

To use the DBMS_LOGMNR_D.BUILD procedure, mount and open the database whose files you will want to analyze.

Then run the PL/SQL procedure DBMS_LOGMNR_D.BUILD,as illustrated in the following examples.

Example of Extracting to a Flat File

The following example extracts the dictionary file to a flat file named dictionary.ora in a specified path (/oracle/database).

SQLPLUS>EXECUTE dbms_logmnr_d.build('dictionary.ora',  
SQLPLUS>'/oracle/database/', 
SQLPLUS>options => dbms_logmnr_d.store_in_flat_file);

Example of Extracting to Redo Logs

SQLPLUS>EXECUTE dbms_logmnr_d.build (
SQLPLUS>options => dbms_logmnr_d.store_in_redo_logs);

Summary of DBMS_LOGMNR_D Subprograms

DBMS_LOGMNR_D contains one procedure, BUILD, which writes the dictionary tables of the current database (the online catalog) into the redo log files or into a flat file.

27 DBMS_LOGMNR_D