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;