Home » , » CRS-2640

CRS-2640

Written By Srikrishna Murthy Annam on Thursday, January 6, 2011 | 2:16 AM

This article describes how to modify the  resource dependencies in the cluster.

Some time back i dropped a diskgroup DG1 from the SQL prompt and it is dropped successfully without any errors. But when i see the cluster resources status, the diskgroup resource still displays in offline status. Further investigations revealed that the disk group details still exist in OCR.

When i try to restart the database, it gives the error CRS-2640. I tried to delete the OCR details as well with srvctl command and able to delete the OCR details. Tried again to start the database but failed with error. The work around to this error is to modify the OCR with the existing diskgroups.
[oracle@dhcppc1 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    dhcppc1
ora.DG1.dg     ora....up.type ONLINE    OFFLINE
ora.FRA.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    dhcppc1
ora.OCR.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora.asm        ora.asm.type   ONLINE    ONLINE    dhcppc1
ora.cssd       ora.cssd.type  ONLINE    ONLINE    dhcppc1
ora.diskmon    ora....on.type ONLINE    ONLINE    dhcppc1
ora.testdb.db  ora....se.type ONLINE    OFFLINE
[oracle@dhcppc1 ~]$ srvctl start database -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DG1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DG1"

CRS-2674: Start of 'ora.DG1.dg' on 'dhcppc1' failed
[oracle@dhcppc1 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    dhcppc1
ora.DG1.dg     ora....up.type ONLINE    OFFLINE
ora.FRA.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    dhcppc1
ora.OCR.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora.asm        ora.asm.type   ONLINE    ONLINE    dhcppc1
ora.cssd       ora.cssd.type  ONLINE    ONLINE    dhcppc1
ora.diskmon    ora....on.type ONLINE    ONLINE    dhcppc1
ora.testdb.db  ora....se.type ONLINE    OFFLINE

[oracle@dhcppc1 ~]$ srvctl disable diskgroup -g dg1
[oracle@dhcppc1 ~]$ srvctl remove diskgroup -g dg1
[oracle@dhcppc1 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    dhcppc1
ora.FRA.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    dhcppc1
ora.OCR.dg     ora....up.type ONLINE    ONLINE    dhcppc1
ora.asm        ora.asm.type   ONLINE    ONLINE    dhcppc1
ora.cssd       ora.cssd.type  ONLINE    ONLINE    dhcppc1
ora.diskmon    ora....on.type ONLINE    ONLINE    dhcppc1
ora.testdb.db  ora....se.type ONLINE    OFFLINE
[oracle@dhcppc1 ~]$ srvctl start database -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
CRS-2640: Required resource 'ora.DG1.dg' is missing.
[oracle@dhcppc1 ~]$ srvctl config database -d testdb
Database unique name: testdb
Database name: testdb
Oracle home: /u01/app/11.2.0/db
Oracle user: oracle
Spfile: +DATA/testdb/spfiletestdb.ora
Domain: testing.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
[oracle@dhcppc1 ~]$

[oracle@dhcppc1 ~]$ srvctl start database -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
CRS-2640: Required resource 'ora.DG1.dg' is missing.
[oracle@dhcppc1 ~]$ srvctl remove diskgroup -g DG1 -f
PRCR-1001 : Resource ora.DG1.dg does not exist
[oracle@dhcppc1 ~]$ crsctl status resource ora.DG1.dg -f
CRS-210: Could not find resource 'ora.DG1.dg'.

[oracle@dhcppc1 ~]$ srvctl start database -d testdb
PRCR-1079 : Failed to start resource ora.testdb.db
CRS-2640: Required resource 'ora.DG1.dg' is missing.
[oracle@dhcppc1 ~]$ srvctl status database -d testdb
Database is not running.
[oracle@dhcppc1 ~]$ srvctl stop database -d testdb
PRCC-1016 : testdb was already stopped
[oracle@dhcppc1 ~]$

[oracle@dhcppc1 ~]$ srvctl modify database -d testdb -a 'DATA,FRA,OCR'
[oracle@dhcppc1 ~]$ srvctl status database -d testdb
Database is not running.
[oracle@dhcppc1 ~]$ srvctl start database -d testdb
[oracle@dhcppc1 ~]$ srvctl status database -d testdb
Database is running.
[oracle@dhcppc1 ~]$

Hope it helps
SRI
Share this article :

Related Articles By Category



Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger