OraFAQ Forum: Server Administration » logminer and dictionary file from another database

Home » RDBMS Server » Server Administration » logminer and dictionary file from another database (windows 2000 sp1 64 bit oracle 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

logminer and dictionary file from another database [message #291920]

Mon, 07 January 2008 04:23

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?

Report message to a moderator