ORA-01280: Fatal LogMiner Error (data dictionary created under ocfs2)

Source: Internet
Author: User

ORA-01280: Fatal LogMiner Error.

Logminer is easy to use. follow the steps below.

1. Install
Run the following two scripts in Oracle10g:
L $ ORACLE_HOME/rdbms/admin/dbmslm. SQL
2 $ ORACLE_HOME/rdbms/admin/dbmslmd. SQL.

These two scripts are used to create two packages (DBMS_LOGMNR and DBMS _ LOGMNR_D) and four V $ dynamic performance views (the view is created when LogMiner is started using DBMS_LOGMNR.START_LOGMNR)

Important Process

Dbms_logmnr_d.build creates a data dictionary file
Dbms_logmnr.add_logfile add log files to the list for analysis
Dbms_logmnr.start_logmnr starts LogMiner by using an optional dictionary file and the log file that was previously determined to be analyzed.
Dbms_logmnr.end_logmnr stop LogMiner Analysis

Important views
V $ logmnr_dictionary: displays the information of the dictionary file used to determine the Object ID.
V $ logmnr_logs displays the list of logs analyzed when LogMiner is started
V $ logmnr_contents after LogMiner is started, you can use this view to enter an SQL statement at the SQL prompt to query the redo log Content.

The view related to logminer is as follows:

V $ LOGMNR_CONTENTS
V $ LOGMNR_LOGS
V $ LOGMNR_DICTIONARY
V $ LOGMNR_PARAMETERS
V $ LOGMNR_LOGFILE
V $ LOGMNR_PROCESS
V $ LOGMNR_TRANSACTION
V $ LOGMNR_REGION
V $ LOGMNR_CALLBACK
V $ LOGMNR_SESSION
V $ LOGMNR_LATCH
V $ LOGMNR_DICTIONARY_LOAD
V $ LOGMNR_STATS

2. Create a data dictionary
3. Create a list of log files to be analyzed
4. Use LogMiner for log analysis
5. Observe the analysis results (v $ logmnr_contents)

The following is a logminer log analysis process.

Create a data dictionary
Begin
DBMS_LOGMNR_D.BUILD ('logmin _ dic. ora ','/db06/stream/logmin ');
End;

Create a list of log files to be analyzed
Begin
DBMS_LOGMNR.ADD_LOGFILE ('/db06/archivelog/2_4648_748374015.dbf', DBMS_LOGMNR.NEW );
End;

Use LogMiner for log analysis
Alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';
Begin

Dbms_logmnr.start_logmnr (dictfilename => '/db06/stream/logmin/logmindic3.ora ');
End;

This analysis reported an Error and reported ORA-01280: Fatal LogMiner Error. I'm testing on another machine and there's no problem finding the different reason here
Create a database dictionary in the ocfs2 file system, and then recreate the data dictionary in the ext3 file system. The operation steps are correct.
It seems that the logminer data dictionary cannot be created in the ocfs2 file system.

Terminate a log analysis transaction
Begin
DBMS_LOGMNR.end_logmnr ();
End;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.