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

Comments

Flashback and LogMiner Enhancements in Oracle Database 11g Release 1 - See how Oracle 11g Release 1 makes tracking data changes and recovering from logical errors easier because of enhancements to Flashback and LogMiner.



Claude Saikaly said...

Dear Sir,
Thank you for the nice articles you have put here. I am trying the Flashback transaction, and followed all the steps, when I click on the button FlashBack transaction, I got the following error :

java.sql.SQLException: ORA-55507: Encountered mining error during Flashback Transaction Backout. function:krvxpsr ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_FLASHBACK", line 37 ORA-06512: at "SYS.DBMS_FLASHBACK", line 70 ORA-06512: at line 2

Could you please help me to resolve it?

Thank you

Tim... said...

Hi.

There is nothing more I can say than what is said in the error message. You have a missing log file. You can't expect to mine a log for information to back out a transaction if the log file is not present. :)

Repeat the process for a transaction which you still have the logs for.

Cheers

Tim...

PS. Questions in the forum, not in the comments please. :)

Eddy said...

http://3.ly/e2F6

Tim... said...

Hi.

Yes, DDL is now available for Flashback Data Archive, but it's an 11gR2 new feature. The article was written when 11gR1 was released.

Cheers

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