Drop 'Zombie' diskgroup


View all mounted asm_diskgroups in the ASM instance
SYS@+ASM>select NAME,STATE from v$asm_diskgroup
2 /

NAME STATE
------------------------------ -----------
DATA2 MOUNTED
DATA3 MOUNTED
DATADG MOUNTED
View all defined asm_diskgroups in the current ASM instance
SYS@+ASM>show parameter disk

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string BBXDG, DATADG, BBXDG3, BBXDG2,
BBXL7, BBXL7REDO, BBXL7ARCHIV
E, DATA2, BBXL7512, BBXL74096,
BBXSTORAGE, L7BBX4096, BBXL7S
B, BBXL7RAWDG, TEST, BBX7ONLIN
ELOG, BBX7CONTROLFILE, BBXL7RA
WASM, DATA3, BBXL7ASM512, BBX_
SP03, BBX_FDB
asm_diskstring string /dev/raw/raw*
Change spfile only to the mounted diskgroups
SYS@+ASM>alter system set asm_diskgroups='DATA2','DATA3','DATADG';

System altered.
Verify the change
SYS@+ASM>show parameter disk

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA2, DATA3, DATADG
asm_diskstring string /dev/raw/raw*
View all defined asm_diskgroups in the spfile
SYS@+ASM>show spparameter disk

SID NAME TYPE VALUE
-------- ----------------------------- ----------- ----------------------------
+ASM asm_diskgroups string BBX7CONTROLFILE
+ASM asm_diskgroups string BBX7ONLINELOG
+ASM asm_diskgroups string BBXDG
+ASM asm_diskgroups string BBXDG2
+ASM asm_diskgroups string BBXDG3
+ASM asm_diskgroups string BBXL7
+ASM asm_diskgroups string BBXL74096
+ASM asm_diskgroups string BBXL7512
+ASM asm_diskgroups string BBXL7ARCHIVE
+ASM asm_diskgroups string BBXL7ASM512
+ASM asm_diskgroups string BBXL7RAWASM
+ASM asm_diskgroups string BBXL7RAWDG
+ASM asm_diskgroups string BBXL7REDO
+ASM asm_diskgroups string BBXL7SB
+ASM asm_diskgroups string BBXSTORAGE
+ASM asm_diskgroups string BBX_FDB
+ASM asm_diskgroups string BBX_SP03
* asm_diskgroups string DATA2
+ASM asm_diskgroups string DATA2
+ASM asm_diskgroups string DATA3
* asm_diskgroups string DATA3
+ASM asm_diskgroups string DATADG
* asm_diskgroups string DATADG
+ASM asm_diskgroups string L7BBX4096
+ASM asm_diskgroups string TEST
* asm_diskstring string /dev/raw/raw*
Change spfile to the mounted diskgroups for the specific +ASM instance
SYS@+ASM>alter system set asm_diskgroups='DATA2','DATA3','DATADG' scope=spfile sid='+ASM';

System altered.
Verify the change
SYS@+ASM>show spparameter disk

SID NAME TYPE VALUE
-------- ----------------------------- ----------- ----------------------------
+ASM asm_diskgroups string DATA2
* asm_diskgroups string DATA2
* asm_diskgroups string DATA3
+ASM asm_diskgroups string DATA3
+ASM asm_diskgroups string DATADG
* asm_diskgroups string DATADG
* asm_diskstring string /dev/raw/raw*
View all defined asm_diskgroups in the Grid Infrastructure
[12:05:12 oracle@e11lora7:~/scripts +ASM ] $ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BBX7CONTROLFILE.dg
ONLINE OFFLINE e11lora7
ora.BBXDG3.dg
ONLINE OFFLINE e11lora7
ora.BBXL7.dg
ONLINE OFFLINE e11lora7
ora.BBXL7512.dg
ONLINE OFFLINE e11lora7
ora.BBXL7ARCHIVE.dg
ONLINE OFFLINE e11lora7
ora.BBXL7ASM512.dg
ONLINE OFFLINE e11lora7
ora.BBXL7REDO.dg
ONLINE OFFLINE e11lora7
ora.BBXL7SB.dg
ONLINE OFFLINE e11lora7
ora.BBXSTORAGE.dg
ONLINE OFFLINE e11lora7
ora.BBX_FDB.dg
ONLINE OFFLINE e11lora7
ora.BBX_SP03.dg
ONLINE OFFLINE e11lora7
ora.DATA2.dg
ONLINE ONLINE e11lora7
ora.DATA3.dg
ONLINE ONLINE e11lora7
ora.DATADG.dg
ONLINE ONLINE e11lora7
ora.L7BBX4096.dg
ONLINE OFFLINE e11lora7
ora.LISTENER.lsnr
ONLINE ONLINE e11lora7
ora.asm
ONLINE ONLINE e11lora7 Started
ora.ons
OFFLINE OFFLINE e11lora7
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.bdb.db
1 ONLINE OFFLINE Instance Shutdown
ora.cssd
1 ONLINE ONLINE e11lora7
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE e11lora7
ora.fdb.db
1 ONLINE OFFLINE
ora.hdb.db
1 ONLINE OFFLINE Instance Shutdown
ora.rpadb.db
1 ONLINE OFFLINE
Trying to remove unnecessary diskgroup diskgroup
[12:06:39 oracle@e11lora7:~/scripts +ASM ] $ srvctl remove diskgroup -g BBX_FDB
PRCA-1002 : Failed to remove CRS resource ora.BBX_FDB.dg for ASM Disk Group BBX_FDB
PRCR-1028 : Failed to remove resource ora.BBX_FDB.dg
PRCR-1072 : Failed to unregister resource ora.BBX_FDB.dg
CRS-0222: Resource 'ora.BBX_FDB.dg' has dependency error.
Checking which database is configured to depend on the diskgroup
[12:08:20 oracle@e11lora7:~/scripts +ASM ] $ srvctl config database -d hdb
Database unique name: hdb
Database name: hdb
Oracle home: /oracle/app/product/11.2.0/dbhome
Oracle user: oracle
Spfile: +DATA3/hdb/spfilehdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: hdb
Disk Groups: DATA3,BBX_FDB
Services:
Removing the unnecessary diskgroup from the database (by omitting it)
[12:12:01 oracle@e11lora7:~/scripts +ASM ] $ srvctl modify database -d hdb -a "DATA3"
Verify the change
[12:12:07 oracle@e11lora7:~/scripts +ASM ] $ srvctl config database -d hdb
Database unique name: hdb
Database name: hdb
Oracle home: /oracle/app/product/11.2.0/dbhome
Oracle user: oracle
Spfile: +DATA3/hdb/spfilehdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: hdb
Disk Groups: DATA3
Services:
Trying again to remove unnecessary diskgroup diskgroup
[12:12:18 oracle@e11lora7:~/scripts +ASM ] $ srvctl remove diskgroup -g BBX_FDB
PRCA-1002 : Failed to remove CRS resource ora.BBX_FDB.dg for ASM Disk Group BBX_FDB
PRCR-1028 : Failed to remove resource ora.BBX_FDB.dg
PRCR-1072 : Failed to unregister resource ora.BBX_FDB.dg
CRS-0222: Resource 'ora.BBX_FDB.dg' has dependency error.
Trying again to remove but now with crsctl, maybe we will have a clue for this new dependency
[12:12:43 oracle@e11lora7:~/scripts +ASM ] $ crsctl delete resource 'ora.BBX_FDB.dg'
CRS-2730: Resource 'ora.fdb.db' depends on resource 'ora.BBX_FDB.dg'
CRS-4000: Command Delete failed, or completed with errors.
Checking if this database is also configured to use this diskgroup
[12:13:34 oracle@e11lora7:~/scripts +ASM ] $ srvctl config database -d fdb
Database unique name: fdb
Database name: fdb
Oracle home: /oracle/app/product/11.2.0/dbhome
Oracle user: oracle
Spfile:
Domain: axxana.local
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: fdb
Disk Groups: DATA2,BBX_SP03,BBX_FDB
Services:
Removing the unnecessary diskgroup from the database (by omitting it)
[12:13:52 oracle@e11lora7:~/scripts +ASM ] $ srvctl modify database -d fdb -a "DATA2"
Trying to remove unnecessary diskgroup
[12:14:07 oracle@e11lora7:~/scripts +ASM ] $ srvctl remove diskgroup -g BBX_FDB
Verify the change
[12:14:21 oracle@e11lora7:~/scripts +ASM ] $ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BBX7CONTROLFILE.dg
ONLINE OFFLINE e11lora7
ora.BBXDG3.dg
ONLINE OFFLINE e11lora7
ora.BBXL7.dg
ONLINE OFFLINE e11lora7
ora.BBXL7512.dg
ONLINE OFFLINE e11lora7
ora.BBXL7ARCHIVE.dg
ONLINE OFFLINE e11lora7
ora.BBXL7ASM512.dg
ONLINE OFFLINE e11lora7
ora.BBXL7REDO.dg
ONLINE OFFLINE e11lora7
ora.BBXL7SB.dg
ONLINE OFFLINE e11lora7
ora.BBXSTORAGE.dg
ONLINE OFFLINE e11lora7
ora.BBX_SP03.dg
ONLINE OFFLINE e11lora7
ora.DATA2.dg
ONLINE ONLINE e11lora7
ora.DATA3.dg
ONLINE ONLINE e11lora7
ora.DATADG.dg
ONLINE ONLINE e11lora7
ora.L7BBX4096.dg
ONLINE OFFLINE e11lora7
ora.LISTENER.lsnr
ONLINE ONLINE e11lora7
ora.asm
ONLINE ONLINE e11lora7 Started
ora.ons
OFFLINE OFFLINE e11lora7
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.bdb.db
1 ONLINE OFFLINE Instance Shutdown
ora.cssd
1 ONLINE ONLINE e11lora7
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE e11lora7
ora.fdb.db
1 ONLINE OFFLINE
ora.hdb.db
1 ONLINE OFFLINE Instance Shutdown
ora.rpadb.db
1 ONLINE OFFLINE

Yehh.... :)

Comments

Post a Comment

Popular posts from this blog

Silent Installation

Some times there are problems using installation with GUI, the reason can be: 1. Firewall 2. Unix security 3. Client software (missing or not working( and maybe some more reasons If your environment is cooperative helping you solve this - it is simple - go for it. But if you are on your own and can't reach "the right guys" - do it yourself " Silently " Look for the proper response file fits for your needs in /database/response/ Edit it and run the following command: $ ./runInstaller -force -invPtrLoc /oraInst.loc -silent -noconfig -ignoreSysPrereqs -responseFile /database/response/enterprise.rsp You can also run the installer without a response file as mentioned in Metalink Note 782918.1 $ ./runInstaller -silent -force -debug \ FROM_LOCATION="/mount/dvd/database/stage/products.xml" \ ORACLE_HOME="/u01/app/oracle/product/11.1.0/db_1" \ ORACLE_HOME_NAME="Ora11gDb1" ORACLE_BASE="/u01/app/oracle" \ TOPLEVEL_COMPONENT='{&q
Read more

Data Guard - Changing IP Addresses

Image
When changing IP of a host we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration. Dataguard configuration Show the environment DGMGRL> show configuration Configuration - dr   Protection Mode: MaxAvailability   Members:   pdb7 - Primary database     fdb7 - Far sync instance       sdb7 - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS   (status updated 351 seconds ago) Show detailed information of the Primary
Read more

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in: HP/Solaris /var/opt/oracle/oraInst.loc Linux /etc/oraInst.loc Windows \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc To check if all oracle homes are registered within the Central Inventory run the following command: ${ORACLE_HOME}/oui/bin/opatch lsinventory -all Invoking OPatch 10.2.0.3.0 Oracle interim Patch Installer version 10.2.0.3.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /software/oracle/OEM10gR2/agent10g Central Inventory : /software/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.3.0 OUI version : 10.2.0.3.0 OUI location : /software/oracle/OEM10gR2/agent10g/oui Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt ----------------------------------... List of Oracle Homes:
Read more