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 ~]$
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
Posts
Post a Comment
Thank you for visiting our site and leaving your valuable comment.