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

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

Install Oracle Internet Directory (OID) in Standalone mode

Image
Oracle Internet Directory (OID) is an LDAP server which uses an Oracle database as a datastore. Client machines can use the OID for all TNS lookups. With OID. Once all client machines are configured correctly any modifications to the TNS lookups can be done from a central location reducing the amount of client machine administration. This guide is about installing and using Oracle Internet Directory in Standalone mode, no need for Oracle Fusion Middleware Infrastructure. Step-by-step guide Download Oracle Internet Directory (Part of identity management) from http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/index.html Install OID, follow instructions: https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/inoim/installing-product-software.html#GUID-5D47117E-3983-4BED-BADB-CB7DDD63DB34 Starting the Installation Program: ./fmw_12.2.1.3.0_oid_linux64.bin Configure the Domain: $ORACLE_HOME/oracle_common/common/bin/config.sh Start the Servers for Standal
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