Skip to main content

How to restore OCR in 11gR2 grid infrastrcture in ASM without starting CRS?

If your OCR is corrupted and you have to restore, first you have access to diskgroup on which OCR is places. To start ASM you have to start CRS, and CRS can't be started since OCR is no available. How to resolve this issue?

You can start ASM with CRS running. If ASM is not running you will get segmentation fault.

[root@tdc-ovn-0083 tdc-ovn-0083]# ocrconfig -restore /oraclecrsware/product/11.2.0/cdata/crs2/backup00.ocr
Segmentation faulT

Start resources without CRS on one node only.

[root@tdc-ovn-0083 tdc-ovn-0083]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.mdnsd' on 'tdc-ovn-0083' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.gpnpd' on 'tdc-ovn-0083' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'tdc-ovn-0083'
CRS-2672: Attempting to start 'ora.gipcd' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.cssdmonitor' on 'tdc-ovn-0083' succeeded
CRS-2676: Start of 'ora.gipcd' on 'tdc-ovn-0083' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'tdc-ovn-0083'
CRS-2672: Attempting to start 'ora.diskmon' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.diskmon' on 'tdc-ovn-0083' succeeded
CRS-2676: Start of 'ora.cssd' on 'tdc-ovn-0083' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'tdc-ovn-0083'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'tdc-ovn-0083'
CRS-2672: Attempting to start 'ora.ctssd' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.drivers.acfs' on 'tdc-ovn-0083' succeeded
CRS-2676: Start of 'ora.ctssd' on 'tdc-ovn-0083' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'tdc-ovn-0083' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'tdc-ovn-0083'
CRS-2676: Start of 'ora.asm' on 'tdc-ovn-0083' succeeded


[root@tdc-ovn-0083 tdc-ovn-0083]# ocrconfig -restore /oraclecrsware/product/11.2.0/cdata/crs2/backup00.ocr


[root@tdc-ovn-0083 tdc-ovn-0083]# ps -ef|grep pmon
oracle 18408 1 0 10:25 ? 00:00:00 asm_pmon_+ASM2
root 18486 16559 0 10:26 pts/0 00:00:00 grep pmon


Another Reason to keep OCR on raw devices in 11gR2. You dont need to start ASM :)

Comments

Post a Comment

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...
Post a Comment
Read more

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...
Post a Comment
Read more

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...
Post a Comment
Read more