Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

LogMiner - Analyze archived redo logs to identify specific specific statements and undo them.



Kaleem Ahmad said...

I find the article useful and specific to the relevant topic. I have encountered an error while executing the statement
EXECUTE Dbms_Logmnr_D.Build( -
dictionary_filename =>'TSH1dict.ora', -
dictionary_location => 'C:\Oracle\Oradata\TSH1\Archive');

I have already set the appropriate path in the init.ora file.

error reads like this
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Tim... said...

Hi.

My guess is you are doing this operation from the wrong user. Try it as the SYS or SYSTEM users.

If you have any problems with this it's probably better to ask a question on the forum.

Cheers

Tim...

Aamer said...

Hi, Thanks for such an informative article.

I would humbly suggest a very minor mistake which you might have forgotten,

I have tried executing END_LOGMNR procedure, and according to my experience, a semicolon ";" is required in the following line as shown below:

DBMS_LOGMNR.END_LOGMNR;

Thanks,

Tim... said...

Hi.

Thanks for taking the time to point out the typo. It's corrected now. :)

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired