Thursday, January 15, 2015

How to check OCR details.

How to check OCR details.

Need to use the below tools for checking the OCR details

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3860
         Available space (kbytes) :     258260
         ID                       :  710588188
         Device/File Name         : +OCRVOTEDG
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 >

Go inside the asm location to check the phisical file

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > asmcmd
ASMCMD> cd OCRVOTEDG
ASMCMD> ls
testingdbiscan/
ASMCMD> cd testingdbiscan/
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd ASMPARAMETERFILE/
ASMCMD> ls
REGISTRY.253.807918545
ASMCMD>


To fine the OLR or the local registry for the Cluster node go to the root user and run the below command.

[root@testserver1i app]# . oraenv
ORACLE_SID = [root] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[root@testserver1i app]# echo $ORACLE_HOME
/u01/app/11.2.0.4/grid
[root@testserver1i app]# ocrcheck -local
Status of Oracle Local Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2696
         Available space (kbytes) :     259424
         ID                       : 1047978051
         Device/File Name         : /u01/app/11.2.0.4/grid/cdata/testserver1i.olr
                                    Device/File integrity check succeeded

         Local registry integrity check succeeded

         Logical corruption check succeeded

[root@testserver1i app]#

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...