I'm in charge of maintaining three databases (A,B,C), I don't want to install logminer for each database,so I created a small database(D) on my computer, and I installed logminer for this database. Now I want to analyze redo logs belong to database A,B and C by logminer which installed in database D. How should I setup the utl_file_dir? How should I create the dictionary?
I did the following steps:
1.Added 'utl_file_dir=d:\ora817\oradata' in initA.ora
2.COPY system01.ora (belongs to database B) to d:\ora817\oradata
3.startup instance A
notes: e:\dump\redo01.log is a redo log of database B
No problems in the first 5 steps, but after step 6,the error message appeared:
ORA-01295: DB_ID mismatch between dictionary d:\ora817\oradata\vvv.ora and logfiles
ORA-06512: at "SYS.DBMS_LOGMNR", line 42
ORA-06512: at line 2
I think the problem occured at step 4,the dictionary I built was from database A,so the DB_ID in the dictionary didn't match the DB_ID in the log file. How should I do?