Oracle log analysis tools - LogMiner Detailed

LogMiner ---- Oracle 8i provided after the self through the form of SQL commands to query and resolve redo (redo) and undo (remove) log tool.

1. Install LogMiner
Oracle LogMiner is a log analysis tool that comes with the installation as long as you can run the sql script.

First, run the following two scripts so that the two are SYS user script must be run.
The first script used to create DBMS_LOGMNR package, the package used to analyze log files.
The second script is used to create DBMS_LOGMNR_D package, the package used to create data dictionary files.

Two files:
1 $ ORACLE_HOME / rdbms / admin / dbmslm.sql
2. $ ORACLE_HOME / rdbms / admin / dbmslmd.sql.

Operation command:
SQL> @ d: \ oracle \ product \ 10.2.0 \ db_2 \ RDBMS \ ADMIN \ dbmslm.sql
Package has been created.
Grant succeeded.

SQL> @ d: \ oracle \ product \ 10.2.0 \ db_2 \ RDBMS \ ADMIN \ dbmslmd.sql
Package has been created.

2. Create Data Dictionary (data-dictionary)
Data dictionary is used to parse the hexadecimal log of data items (such as the log of the sql statement in the column name).

3 optional way to create access for the LogMiner data dictionary.
1) Direct access to the database in the online data dictionary.
This simple, convenient, but because the data dictionary is the current date, the log may not match the information in the past.
Usage: When starting logMiner analysis, the use of DICT_FROM_ONLINE_CATALOG option. As follows:
SQL> EXECUTE dbms_logmnr.start_logmnr (options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
Log preferably sys sysdba execute the command.

2) export the data dictionary to a file.
This approach is a point in time the data dictionary export documents; in logMiner start time of analysis (see Step) by options parameter specifies the file name and path to resolve logs.
If we have to analyze the database tables have changed, affecting the library's data dictionary also changed, then they need to re-create the dictionary file. In addition, the analysis of another database redo log file, it must be analyzed again to re-generate the database data dictionary file.
a. First, adjust the spfile parameter;
b. then create a data dictionary file;
SQL> EXECUTE (dictionary_filename => 'logmn_ora817.dat', dictionary_location => 'D: Oraclelogs');
# Note, dictionary_location UTL_FILE_DIR parameters must be referred to the same directory.

3) export the data to a log file in the dictionary.
To extract database dictionary information to the redo log files, databases must be in ARCHIVELOG mode.
Export, use STORE_IN_REDO_LOGS option. For example:

3, to create a list of log files to analyze
Oracle's redo log is divided into two types, on-line (online) and offline (offline) archive log file;
This paper analyzes the archive logs, online journals, like the principle.

A. Create a list of logs to be analyzed
SQL> execute dbms_logmnr.add_logfile (options =>, logfilename => 'D: \ oracle \ product \ 10.2.0 \ oradata \ oracle9i \ REDO01.LOG');
B. add additional log files to the list
SQL> execute dbms_logmnr.add_logfile (options => dbms_logmnr.addfile, logfilename => 'D: \ oracle \ product \ 10.2.0 \ oradata \ oracle9i \ REDO02.LOG');
Continue to add. . .
SQL> execute dbms_logmnr.add_logfile (options => dbms_logmnr.addfile, logfilename => 'D: \ oracle \ product \ 10.2.0 \ oradata \ oracle9i \ REDO03.LOG');
Can also delete
SQL> execute dbms_logmnr.add_logfile (options => dbms_logmnr.removefile, logfilename => 'D: \ oracle \ product \ 10.2.0 \ oradata \ oracle9i \ REDO03.LOG');

Need to analyze the number of log files determined entirely by the user, the proposal should add only a need to analyze the log file, after the analysis of the file, and then add another file.
标签: logs, column name, oracle, oracle home, sql statement, database tables, oracle product, direct access, dict, point in time, data dictionary, sql commands, current date, sql script, log analysis tools, dictionary data, export documents, log analysis tool, dicti, catalog option
分类: Database
时间: 2010-12-22


  1. oracle log analysis tools to LogMiner use (combat)

    To install the LogMiner tool, you must first run the following two scripts so that the two are in the script m ...
  2. Understand and use Oracle log analysis tools-LogMiner

    This article is reproduced, the first author is unknown, please contact me. Oracle LogMiner is Oracle 8i from ...
  3. AWStats Description: Apache / Windows IIS log analysis tools to download, install, configure and use sample You do not have the patience to read all the content: a b ...
  4. MySQL monitoring tools and log analysis tools to summarize

    Monitoring tools: innotop ( installation and description ), mysqlsniffer ( ) ...
  5. request-log-analyzer log analysis tools ...
  6. Detailed logs of Oracle's tools - LogMiner

    Foreword Oracle's redo log is divided into two types of online redo log files (online Redo log) and archived r ...
  7. Oracle log file analysis

    First, explain how to analyze the LogMiner From now, the only way of Oracle is to use the log provided by Orac ...
  8. IIS log analysis methods and tools

    The importance of logging has been more and more attention to the programmer, IIS log is self-evident. Recomme ...
  9. 10 great open source Web traffic analysis tools

    Rui Business Enterprise CMS writes "Web traffic analysis tools are numerous, from the WebTrends Professio ...
  10. Talk about log analysis

    Log Analysis Overview: Log in the computer system is a very broad concept, there may be any program output log ...
  11. Oracle archive log analysis - LogMiner (rpm)

    Log Analysis Technical Overview: As the Oracle DBA, we sometimes need to track the malicious user data acciden ...
  12. Linux system performance analysis tools commonly used in the top command Detailed

    The top command is commonly used under Linux performance analysis tools, real-time display system in the proce ...
  13. oralce8i/9i database log view Method (logminer use)

    First, how to analyze the LogMiner to explain the present circumstances, the only way to analyze Oracle log is ...
  14. [Switch] with awstats log analysis of some records Nginx

    Original Address: System enviro ...
  15. AWStats log analysis tool

    The following tutorial is installed under the windows2003 server configuration, as by awstats perl program to ...
  16. [Java performance analysis] Sun JDK introduces the basic performance analysis tools

    Sun JDK version also released with a number of performance analysis tools, these tools are essentially based o ...
  17. Static analysis tools and the use of summary

    Static analysis tools and the use of summary (2) Here are three open source tools are introduced, PMD, CheckSt ...
  18. Use of multi-threading analysis tools Mtrat

    A very good multi-threading analysis tools, the provider is IBM, the official description on the development o ...
  19. Increasingly powerful static analysis tools

    Static source code analysis tools have evolved from simple grammar checker developed into a powerful tool that ...