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?
|
|
|
Re: logminer and dictionary file from another database [message #291926 is a reply to message #291920] |
Mon, 07 January 2008 04:44  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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.
It seems but to be sure you have to try it.
Regards
Michel
|
|
|