Why my new Disk Group is not getting mounted automatically when ASM instance starts?
Today I faced the issue that a new ASM Disk Group created in
instance +ASM1 is not getting automatically mounted in instance +ASM2.
The first step was to check DB dependencies:
[oracle@ol5-112-rac2 trace]$ srvctl config database
-d RAC
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/RAC/spfileRAC.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RAC
Database instances: RAC1,RAC2
Disk Groups: DATA
Services: reports
Database is administrator managed
You can see that only dependent Disk Groups are ‘DATA’.
Let us add ‘FRA’ also as dependent Disk Group:
[oracle@ol5-112-rac2 trace]$ srvctl modify database
-d RAC -a 'DATA,FRA'
[oracle@ol5-112-rac2 trace]$ srvctl config database
-d RAC
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/RAC/spfileRAC.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RAC
Database instances: RAC1,RAC2
Disk Groups: DATA,FRA
Services: reports
Database is administrator managed
The next step is to add the Disk Groups to ASM_DISKGROUPS
parameter:
SQL> ALTER SYSTEM SET
ASM_DISKGROUPS='DATA','FRA' scope=both sid='+ASM1';
System altered.
SQL> ALTER SYSTEM SET ASM_DISKGROUPS='DATA','FRA'
scope=both sid='+ASM2';
System altered.
After restarting +ASM2 instance we can see that FRA Disk
Group is mounted automatically:
[oracle@ol5-112-rac2 trace]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun
12 15:44:44 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
- Production
With the Real Application Clusters and Automatic
Storage Management options
SQL> set lines 1000
SQL> select * from V$ASM_DISKGROUP;
GROUP_NUMBER NAME SECTOR_SIZE
BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE
TYPE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB
REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS COMPATIBILITY
DATABASE_COMPATIBILITY V
------------ ------------------------------
----------- ---------- -------------------- ----------- ------ ----------
---------- ----------- ------------ ----------------------- --------------
------------- ------------------------------------------------------------
------------------------------------------------------------ -
1
DATA
512 4096 1048576 MOUNTED EXTERN
15342 12616 0 2726 0 12616 0 11.2.0.0.0
10.1.0.0.0
N
2
FRA
512 4096 1048576 MOUNTED EXTERN 6133 5962 0 171 0 5962 0 11.2.0.0.0 10.1.0.0.0
N
SQL> exit
Disconnected from Oracle Database 11g Enterprise
Edition Release 11.2.0.1.0 - Production
With the Real Application Clusters and Automatic
Storage Management options
Thanks,
Alfredo
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home