Oracle block corruption happens very rarely but when it happens you may lose all your data. Oracle block corruption is nothing but just some incorrect information in the Oracle data file. Oracle will never be aware of this corruption unless you establish a proper block checking configuration system. To detect & repair block corruption, Oracle provides different methods. One method is to simply drop and recreate the object but this method may not work in all situations. Another method that mostly works is the DBMS_REPAIR package.
Showing posts with label Repair Oracle block corruption. Show all posts
Showing posts with label Repair Oracle block corruption. Show all posts
Thursday, May 9, 2013
How to repair Oracle block corruption using DBMS_REPAIR utility
Oracle block corruption happens very rarely but when it happens you may lose all your data. Oracle block corruption is nothing but just some incorrect information in the Oracle data file. Oracle will never be aware of this corruption unless you establish a proper block checking configuration system. To detect & repair block corruption, Oracle provides different methods. One method is to simply drop and recreate the object but this method may not work in all situations. Another method that mostly works is the DBMS_REPAIR package.
Subscribe to:
Posts (Atom)