Recover Corrupt/Missing Oracle Cluster Registry (OCR) with No Backup – (Oracle 10g)File Repair Tool Blog

A corrupt/damaged oracle cluster registry (OCR) may affect your entire oracle database, if you don’t have an updated backup file of your database then this situation become worst. This situation generally not happens very often. But once it occurs then irritate the user by displaying lots of error messages on the screen.

We know that CRSD process is dependable for making backup copies of the OCR form the master node in the master node in the CRS_home/cdata directory. Through these backups one can recover the OCR form a damaged OCR files by using ocrconfig-restore command line. Let us see an example, you add a node to the cluster and before CRSD take backup (before 4 hours) you see that the OCR gets corrupted. You may also forget to create a logical export of the OCR before adding the new node. In this example you have a damaged OCR without a latest backup.

One safest way to reconstruct the OCR is to reinstall the Oracle Clusterware software. In order to do this task without any error a whole outage is necessary for the complete cluster all through the period of the re-install. It is also necessary to remove the Oracle Clusterware software fully, the OCR and voting disks reformatted, all virtual IP addresses (VIPs) re-installed, and a total reinstall of the Oracle Clusterware software will need to be executed.

Other Oracle Errors and Solutions

• ORA-12154: TNS:could not resolve the connect identifier specified (#1)
• ORA-00600: internal error code, arguments: [%s], [%s],[%s], [%s], [%s] (#2)
• ORA-1722: Invalid Number (#3)
• ORA-03113: end-of-file on communication channel (#5)
• ORA-01000: maximum open cursors exceeded (#23)

 Solution for a corrupt or Error showing Oracle File:  

A damaged or error showing oracle database is very dangerous situation for any user, because small error may corrupt entire oracle database after sometime. So it is necessary to apply any solution to remove oracle errors immediately. Some errors are ignorable but some are not, if you unable to access oracle database due to any error then you can’t ignore such error and have to apply any error removal solution. But it is also necessary to repair ignorable error immediately because after a couple of weak it get huge and corrupt your entire data permanently.

Backup and Restore: Through this method you can easily remove any kinds of error, but it is applicable only when you have an updated backup file. Use latest backup of your oracle database and restore your database through it. But make sure that your backup is completely updated because an outdated backup file may affect your stored information.

Third party Tool: This option is good for normal user or those users that doesn’t have backup of their database. Use a third party oracle repair tool and repair oracle database. This is very easy and efficient method to repair any database because in this method you don’t have to supply an updated backup file or type any command to run it. Simple download oracle repair tool and run it in the manner to repair your database.               

Users Guide

Step 1: Search Initial screen of Stellar Phoenix Oracle Recovery with a pop-up window showing options to select or search corrupt Oracle databases in your computer.

Step 2: Click Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in left-side pane.

Step 3: Click an object to see its preview.

Step 4: : Click Start Repair in the icon bar to start the repair process. A pop-up window is displayed which show the steps needed to perform further. Click next and continue.

Step 5: Give the user name, password and path of the blank database where you want to save the repaired database objects.

Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.