Home » RDBMS Server » Server Administration » logminer and dictionary file from another database (windows 2000 sp1 64 bit oracle 10)
logminer and dictionary file from another database [message #291920] Mon, 07 January 2008 04:23 Go to next message
maga
Messages: 17
Registered: November 2007
Junior Member
I have to use log miner to read some archive logs of a database.
I have read this document on metalink. Note:62508.1
it says:
LogMiner can be used against online or archived logs from either the
'current' database or a 'foreign' database. The reason for this is that it
uses an external dictionary file to access meta-data, rather than the
'current' data dictionary.

And this is my situation.

I have two database A and B.
The archive logs belogs to database A, but I need to read them in the database B.

So I need a dictionary file to access meta-data, is it right?
Has this dictionary file to be created in the database A with this command?
BEGIN
dbms_logmnr_d.build(
dictionary_filename=> 'miner_dictionary.dic',
dictionary_location => 'C:\utl'
);
END;
/

And then do I need to read this file in the database B with this command?

dbms_logmnr.add_logfile(
'/export/home/sme81/aholland/database/files/redo03.log',DBMS_LOGMNR.NEW );

and then this (in database B):

EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME =>'/oracle/database/dictionary.ora');

is it correct?
Re: logminer and dictionary file from another database [message #291926 is a reply to message #291920] Mon, 07 January 2008 04:44 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

So I need a dictionary file to access meta-data, is it right?

Yes

Quote:

Has this dictionary file to be created in the database A with this command?

Yes or the like.

Quote:

And then do I need to read this file in the database B with this command?

Yes

Quote:

and then this (in database B):
EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME =>'/oracle/database/dictionary.ora');

If this is the name you gave to your dictionary file.

Quote:

is it correct?

It seems but to be sure you have to try it.

Regards
Michel

Previous Topic: Can't view the table that is exported from one to another
Next Topic: pls. help! Control file problem
Goto Forum:
  


Current Time: Fri Dec 09 17:25:21 CST 2016

Total time taken to generate the page: 0.14491 seconds