Monday, July 21, 2014

OCR backup and recovery

OCR calls Oracle Cluster Registry. It stores cluster configuration information.
It is also shared disk component. It must be accessed by all nodes in cluster environment.
It also keeps information of Which database instance run on which nodes and which service runs on which database.The process daemon OCSSd manages the configuration info in OCR and maintains the changes to cluster in the registry.

Automatic backup of OCR is done by CRSD process and every 3 hours.
Default location is CRS_home/cdata/cluster_name. But we can change default location of this backup of OCR.
We can check default location using following command.

$ocrconfig -showbackup

We can change this default location of physical OCR copies using following command.
$ocrconfig -backuploc

We can take export backup of OCR (Oracle Cluster Registry) also in online. but this is only possible if we are using more than 1 OCR files .

ocrconfig -export backup location
We can restore OCR via import command but for that we need to stop cluster .
ocrconfig -import

Oracle takes physical backup of OCR automatically.
No Cluster downtime or RAC database down time requires for PHYSICAL backup of OCR.
No Cluster downtime or RAC database down time requires for MANUAL export backup of OCR.
For recovery of OCR from any of above backup it should need to down ALL.

All procedure requires ROOT login.

No comments:

Post a Comment

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...