关于使用 logminer的问题(问题现象在最后):
我执行的步骤如下:
1>select member from v$logfile order by member/home/oracle/oracle/product/10.2.0/oradata/yz/redo01.log
/home/oracle/oracle/product/10.2.0/oradata/yz/redo02.log
/home/oracle/oracle/product/10.2.0/oradata/yz/redo03.log2>安装 logminer
sqlplus我是用sqlplus / as sysdba登录的1.创建DBMS_LOGMNR包
SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql2.创建相关数据字典
SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql3.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处
SQL>alter system set UTL_FILE_DIR='/home/oracle/oracle/product/10.2.0/db_1/logminer' scope=spfile;4.重启数据库
SQL>shutdown immediate
SQL>startup5.创建数据字典文件 SQL>execute dbms_logmnr_d.build(dictionary_filename =>'sqltrace.ora',dictionary_location =>'/home/oracle/oracle/product/10.2.0/db_1/logminer');6.建立日志分析表execute dbms_logmnr.add_logfile(options =>dbms_logmnr.new,logfilename =>'/home/oracle/oracle/product/10.2.0/db_1/oradata/llyc/redo01.log');7.添加用于分析的日志文件SQL> execute dbms_logmnr.add_logfile(options =>dbms_logmnr.addfile,logfilename=>'/home/oracle/oracle/product/10.2.0/db_1/oradata/llyc/redo02.log');SQL> execute dbms_logmnr.add_logfile(options =>dbms_logmnr.addfile,logfilename=>'/home/oracle/oracle/product/10.2.0/db_1/oradata/llyc/redo03.log');8.启动LogMiner进行分析execute dbms_logmnr.start_logmnr(dictfilename =>'/home/oracle/oracle/product/10.2.0/db_1/logminer/sqltrace.ora');就在这个时候提示 sqlplus 提示ERROR at line 1:
ORA-01295: DB_ID mismatch between dictionary
/home/oracle/oracle/product/10.2.0/db_1/logminer/sqltrace.ora and logfiles
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1请大家帮我解决错误?