Oracle Local Registry (OLR) in RAC - 11gR2

In 11gR2, addition to OCR, we have another component called OLR installed on each node in the cluster. It is a local registry for node specific purposes. The OLR is not shared by other nodes in the cluster. It is installed and configured when clusterware is installed.

Why OLR is used and why was it introduced.
In 10g, we cannot store OCR’s in ASM and hence to startup the clusterware, oracle uses OCR but what happens when OCR is stored is ASM in 11g.
OCR should be accessible to find out the resources that need to be started or not. But, if OCR is on ASM, it can’t read until ASM (which itself is the resource of the node and this information is stored in OCR) is up.

 To answer this, Oracle introduced a component called OLR.
Ø  It is the first fi
le used to startup the clusterware when OCR is stored on ASM.
Ø  Information about the resources that needs to be started on a node is stored in an OS file called ORACLE LOCAL REGISTRY (OLR).
Ø  Since OLR is an OS file, it can be accessed by various processes on the node for read/write irrespective of the status of cluster (up/down).
Ø  When a node joins the cluster, OLR on that node is read, various resources, including ASM are started on the node.
Ø  Once ASM is up, OCR is accessible and is used henceforth to manage all the cluster nodes. If OLR is missing or corrupted, clusterware can’t be started on that node.

Where is OLR located
It is located $GRID_HOME/cdata/<hostname>.olr .  The location of OLR is stored in /etc/oracle/olr.loc and used by OHASD.
What does OLR contain
The OLR stores
·         Clusterware version info.
·         Clusterware configuration
·         Configuration of various resources which needs to be started on the node,etc.


To see the contents in the OLR file, we can use following commands and see the resources.

[root@rac1 ~]# ocrconfig -local -manualbackup
host01     2014/03/16 01:20:27     /u01/app/grid/11.2.0.3/product/grid_1/cdata/rac1/backup_20140316_012027.olr

[root@rac1 ~]# strings /u01/app/grid/11.2.0.3/product/grid_1/cdata/rac1/backup_20140316_012027.olr |grep -v type |grep ora!

ora!drivers!acfs
ora!crsd
ora!asm
ora!evmd
ora!ctssd
ora!cssd
ora!cssdmonitor
ora!diskmon
ora!gpnpd
ora!gipcd
ora!mdnsd


OLR administration
Checking the status of the OLR file on each node.
$ ocrcheck –local

OCRDUMP is used to dump the contents of the OLR to text terminal
$ocrdump –local –stdout

We can export and import  the OLR file using OCRCONFIG

$ocrconfig –local –export  <export file name>
$ocrconfig –local –import  <file_name>

We can even the repair the OLR file if it corrupted.

$ocrconfig –local –repair –olr <filename>

OLR is backed up at the end of the installation or an upgrade. After that time we need to manually backup the OLR. Automatic backups are not supported for OLR.

$ocrconfig –local –manualbackup.

Viewing the contents of backup file

$ocrdump  -local –backupfile <olr_backup_file_name>

To change the OLR backup location
$ocrconfig –local –backuploc  <new_backup_location>

To restore OLR
$crsctl stop crs
$ocrconfig –local –restore_file_name
$ocrcheck –local
$crsctl start crs

$cluvfy comp olr   -- to check the integrity of the OLR file which was restored.

Comments

Post a Comment

Popular posts from this blog

Oracle Management Server _ EMGC_OMS1 _1 in windows

12c: EM: OMS Server Fails - error nm home replaced Environment: Oracle Enterprise Manager 12c, Windows 2008 R2 Error: Below error occured on one of the client environment C:\Windows\system32> %OMS_HOME%/bin/emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is Down Please check E://gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details Log file showed below 2013-12-22 10:30:54,300 [main] INFO wls.OMSController main.219 - Executing emctl command : start 2013-12-22 10:30:58,536 [main] INFO commands.BaseCommand getEnvProps.456 - nm home replaced : E:/gc_inst/NodeManager/emnodemanager 2013-12-22 10:30:58,581 [main] INFO commands.StartCommand startOMS.371 - net start return code is 2 2013-12-22 10:30:58,582 [main] ERROR commands.BaseCommand logAndPrint.620 - Windows service OracleManagementServe...
Read more

ORA-00600: internal error code, arguments: [qctVCO:csform] ORA-64131 ORA-01403 Errors After Upgrade From 11.2.0.1 To 11.2.0.3 (Doc ID 1394206.1) when database is running in the Chinese language

Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 or 11.2.0.4 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 24-Jul-2013*** SYMPTOMS After upgrading the database from 11.2.0.1.0 to 11.2.0.2 or 11.2.0.3.0, XDB upgraded successfully but now there are XDB errors of: Tue Jan 10 13:22:01 2012 XDB installed. XDB initialized. .. ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [2], [213], [], [], [], [] ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary ORA-01403: no data found And the following object(s) are invalid in the database: SYS ALL_XSC_SECURITY_CLASS_DEP VIEW SYS ALL_XSC_SECURITY_CLASS VIEW SYS ALL_XSC_PRIVILEGE VIEW SYS ALL_XSC_AGGREGATE_PRIVILEGE VIEW SYS ALL_XSC_SECURITY_CLASS_STATUS VIEW Attempts to recompile these objects also fail with the above errors. CAUSE T...
Read more

EXPDP – ORA-39006,ORA-39213 Metadata processing is not available

==> Environmental Details : O/S :Windows Server 2008 64 bits Oracle Version : 11.2.0.1 ==> Error Details : While Taking full database export using “EXPDP” i was getting below mentioned error : ############################################### C:\> expdp directory=pump_dir=expdp_test.dmp logfile=expdp_test.log full=y Export: Release 11.2.0.1.0 – Production on Thu Feb 27 10:48:09 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username : system/oracle123 as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available ############################################### Soultion login  to sys C:\sqlplus sys as sysdba SQL> execute dbms_metadata_util.load_stylesheets ...
Read more