|
-
Log Miner - DB_ID mismatch between dictionary and logfiles
Can LogMiner only be invoked to mine logs from the 'home' DB?
Tom Kyte's Expert One-On-One suggests not ..."We could go into the data dictionary and find what object 30551 is, but only if the we are in the same database in which the redo log file was originally generated." (p.1100) To me this suggests you can use Log Miner with 'foreign' Logs (ie) those generated by a database other than the current database.
Now, I've used Log Miner on several occasions but only within a DB that 'owned' the logfiles.
Now I've tried to import logfiles from a 'foreign' database and mine them. When I try and start Log Miner I get:
SQL> BEGIN
2 DBMS_LOGMNR.START_LOGMNR
3 (dictFileName => 'C:\oracle\admin\utl_file_dir\logminer_dict.dat');
4 END;
5 /
BEGIN
*
ERROR at line 1:
ORA-01295: DB_ID mismatch between dictionary and logfiles
ORA-06512: at "SYS.DBMS_LOGMNR", line 53
ORA-06512: at line 2
Is what I'm attempting impossible? The error message suggests so, but Mr Kyte implied otherwise.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|