troubleshooting Question

How do I analyze redo logs belong to another database by logminer?

Avatar of doubleling00
doubleling00 asked on
Oracle Database
10 Comments1 Solution1734 ViewsLast Modified:
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
5.Execute dbms_logmnr.add_logfile('e:\dump\redo01.log',
notes: e:\dump\redo01.log is a redo log of database B
6.Execute dbms_logmnr.start_logmnr(dictfilename=>'d:\ora817\oradata\vvv.ora');

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?

Mark Geerlings
Database Administrator, retired

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros