Email: service@parnassusdata.com 7 x 24 online support!
problem with PRM-DUL Schema DataBridge
I am trying to use your tool the PRM Schema Databridge to recover data from a crashed Oracle 12 server.
It works great for tables that don’t have any CLOB or BLOB fields but all the tables that have LOB data fails to transfer.
I’ve attached a log from a failed transfer of one such table.
Am I doing something wrong or do I need to do anything specific to make it work for LOB fields?
If I could get this to work that would be fantastic news for me.
Feedback:
download prm-dul http://zcdn.parnassusdata.com/DUL5108.zip
Are you using 11g new feature securefile LOB? this kind of lob storage is not prm-dul build-in function . If you are using classic basicfile lob (before 11g), maybe there is heavy corruption in lob location blocks.
If you are using classic basicfile lob , then try non-dictionary mode ,it will scan the whole database, and list lob and tables.
We can also provide a recovery service to your emergency case , We can recover it ASAP . Pls let me know if you are interested in service or prm-dul product .
We are not using Secure File explicitly but I now see that it is the default storage setting in Oracle 12.
Anyway, thanks for your quick response.
Also, I think that you have a very useful tool. If I get into similar problems with another system in the future I will look you up and see if you have been able to implement support for these LOBs.