Prostrct Repair usage

[karikalanr]

Hi,

I am newbie to this DBA forum. I dont have the clear idea at what circumstances we need to use prostrct repair command?. And what else possible usage of prostrct command? Could you please clarify me in details with syntax? I had gone thru history of this forum, unfortunately I dint get clear explanation... Sorry for troubling you all for this core question..

Thanks,
Karikalan

 

[TomBascom]

You shouldn't need to use dbrpr unless instructed to do so by tech support.

If you do find yourself in that position you have probably lost data and you are attempting to recover what you can. It is not a happy place to be.

Rather than worry about dbrpr you should review your backup and recovery strategy and make sure that you will never be in a position where dbrpr is needed. The key to making sure that you never need dbrpr is to properly implement Progress after-imaging feature. This one feature will do more for your job security than any other. It is not enabled by default and failure to properly implement it is the number one mistake that new DBAs make.

Stop what you are doing and make sure that after-imaging is properly implemented.

(To verify that it is properly implemented restore a backup to a fresh machine and roll forward ai logs until you are current.)