OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ASM add disk issue (Linux 2.6.18-92.1.13.el5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ASM add disk issue [message #526325]

Mon, 10 October 2011 10:06

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hi Expert.

I have added disk to disk group FRA successfully but total size for disk is not increased. Also when checked with v$asm_disk, disk is attached with wrong disk number i.e. 0. Please suggest.

SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:T1_ASM11';

Diskgroup altered.

SQL> select * from v$asm_operation;

no rows selected

SQL> select group_number,name,total_mb/1024,free_mb/1024 from v$asm_diskgroup;

GROUP_NUMBER NAME                           TOTAL_MB/1024 FREE_MB/1024
------------ ------------------------------ ------------- ------------
           1 DATA                                    1800   719.444336
           2 FRA                                      200   14.4238281

SQL> select GROUP_NUMBER,name from v$asm_disk;

GROUP_NUMBER NAME
------------ ------------------------------
           0
           2 T1_ASM01
           1 T1_ASM02
           1 T1_ASM03
           1 T1_ASM04
           1 T1_ASM05
           1 T1_ASM06
           1 T1_ASM07
           1 T1_ASM08
           1 T1_ASM09
           1 T1_ASM10

11 rows selected.

SQL>

Report message to a moderator

Re: ASM add disk issue [message #526327 is a reply to message #526325]

Mon, 10 October 2011 10:11

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Size for disk group FRA is 200 GB before adding the disk & after adding the disk same remains at 200 GB .??? Please suggest.

Report message to a moderator

Re: ASM add disk issue [message #526328 is a reply to message #526327]

Mon, 10 October 2011 10:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size	     big integer 4000M
SQL>

Report message to a moderator

Re: ASM add disk issue [message #526332 is a reply to message #526328]

Mon, 10 October 2011 10:20

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member


SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 200G
SQL>

Report message to a moderator

Re: ASM add disk issue [message #526333 is a reply to message #526332]

Mon, 10 October 2011 10:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>DB_RECOVERY_FILE_DEST_SIZE

it is was it is, unless & until you actually change it.
The dumb parameter does not know another disk was added!

Report message to a moderator

Re: ASM add disk issue [message #526335 is a reply to message #526325]

Mon, 10 October 2011 10:29

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

I have added disk to disk group FRA successfully

No you haven't. Your new disc is not in any disk group at all. That is why its group_number is zero.

Report message to a moderator

Re: ASM add disk issue [message #526336 is a reply to message #526333]

Mon, 10 October 2011 10:34

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Expert.

I have change the parameter DB_RECOVERY_FILE_DEST_SIZE and againg added the disk but still no increase in size.

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=230G scope=both;

System altered.

SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 230G


Enter user-name: / as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:T1_ASM11';

Diskgroup altered.

SQL>  select group_number,name,total_mb/1024,free_mb/1024 from v$asm_diskgroup;

GROUP_NUMBER NAME                           TOTAL_MB/1024 FREE_MB/1024
------------ ------------------------------ ------------- ------------
           1 DATA                                    1800   719.444336
           2 FRA                                      200   14.4238281

SQL>  select GROUP_NUMBER,name from v$asm_disk;

GROUP_NUMBER NAME
------------ ------------------------------
           0
           2 T1_ASM01
           1 T1_ASM02
           1 T1_ASM03
           1 T1_ASM04
           1 T1_ASM05
           1 T1_ASM06
           1 T1_ASM07
           1 T1_ASM08
           1 T1_ASM09
           1 T1_ASM10

11 rows selected.

SQL> select * from v$asm_operation;

no rows selected

SQL> select group_number,name,total_mb/1024,free_mb/1024 from v$asm_diskgroup;

GROUP_NUMBER NAME                           TOTAL_MB/1024 FREE_MB/1024
------------ ------------------------------ ------------- ------------
           1 DATA                                    1800   719.444336
           2 FRA                                      200   14.4238281

Report message to a moderator

Re: ASM add disk issue [message #526351 is a reply to message #526336]

Mon, 10 October 2011 12:17

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Please suggest ..

Report message to a moderator

Re: ASM add disk issue [message #526352 is a reply to message #526351]

Mon, 10 October 2011 12:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/mv/msg/175424/526335/136107/#msg_526335

>SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:T1_ASM11';
why does T1_ASM11 NOT appear in the SELECT?

Report message to a moderator

Re: ASM add disk issue [message #526353 is a reply to message #526352]

Mon, 10 October 2011 12:30

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Yaa, i understand. It should be .. This is what puzzled me. From where i should start looking to trace the situation?

Report message to a moderator

Re: ASM add disk issue [message #526354 is a reply to message #526353]

Mon, 10 October 2011 12:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle-base.com/articles/10g/AutomaticStorageManagement10g.php#disks

"In most cases you will only need two disk groups (DATA and FRA),
where DATA holds all database related files and FRA holds the fast recovery area,
including multiplexed copies on online redo logs and controlfiles.
Typically, the FRA disk group will be twice the size of the DATA disk group, since it must hold all backups."

Report message to a moderator

Re: ASM add disk issue [message #526355 is a reply to message #526354]

Mon, 10 October 2011 12:49

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Interesting points in alert log file for ASM:

SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:T1_ASM11'
Mon Oct 10 13:36:15 2011
NOTE: failed to discover disks from gpnp profile asm diskstring
Errors in file /p01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_31856.trc:
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
NOTE: Assigning number (2,1) to disk (ORCL:T1_ASM11)
NOTE: requesting all-instance membership refresh for group=2
ORA-15186: ASMLIB error function = [asm_open(global)],  error = [1],  mesg = [Operation not permitted]
ORA-15025: could not open disk "ORCL:T1_ASM11"
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: requesting all-instance disk validation for group=2
NOTE: skipping rediscovery for group 2/0xff5a079 (FRA) on local instance.
NOTE: requesting all-instance disk validation for group=2
NOTE: skipping rediscovery for group 2/0xff5a079 (FRA) on local instance.
NOTE: initiating PST update: grp = 2
Mon Oct 10 13:36:18 2011
GMON updating group 2 at 25 for pid 21, osid 6365
NOTE: PST update grp = 2 completed successfully
NOTE: membership refresh pending for group 2/0xff5a079 (FRA)
GMON querying group 2 at 26 for pid 13, osid 31856
GMON querying group 2 at 27 for pid 13, osid 31856
SUCCESS: refreshed membership for 2/0xff5a079 (FRA)
SUCCESS: ALTER DISKGROUP FRA ADD DISK 'ORCL:T1_ASM11'
NOTE: starting rebalance of group 2/0xff5a079 (FRA) at power 1
Starting background process ARB0
Mon Oct 10 13:36:20 2011
ARB0 started with pid=22, OS id=13921
NOTE: assigning ARB0 to group 2/0xff5a079 (FRA) with 1 parallel I/O
Mon Oct 10 13:36:36 2011
NOTE: failed to discover disks from gpnp profile asm diskstring
Errors in file /p01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_31856.trc:
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
NOTE: Attempting voting file refresh on diskgroup FRA
ORA-15186: ASMLIB error function = [asm_open(global)],  error = [1],  mesg = [Operation not permitted]

Report message to a moderator

Re: ASM add disk issue [message #526360 is a reply to message #526355]

Mon, 10 October 2011 13:06

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Er... Do you intend to look at the RBAL trace file? It might help.

Report message to a moderator

Re: ASM add disk issue [message #526364 is a reply to message #526360]

Mon, 10 October 2011 13:30

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member


KGGPNP_SIHA: resource 'ora.asm' is not available [200]
KGGPNP_SIHA: attribute 'ASM_DISKSTRING' get failed sts[200] lsts[0]
NOTE: failed to discover disks from gpnp profile asm diskstring
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
ERROR: asm_open(global)(): asm_erc:1 msg:Operation not permitted pid:31856

Looking for ASM_DISKSTRING parameter.

Report message to a moderator

Re: ASM add disk issue [message #526365 is a reply to message #526364]

Mon, 10 October 2011 13:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post DDL used to initially CREATE DISKGROUP

Report message to a moderator

Re: ASM add disk issue [message #526428 is a reply to message #526365]

Tue, 11 October 2011 01:30

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Not sure for DDL used for create disk.. It happens long back.

Report message to a moderator

Re: ASM add disk issue [message #526444 is a reply to message #526428]

Tue, 11 October 2011 02:30

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

How did you add the new disk to the discovery string? Did you use

alter system set asm_diskstring='something different';

or did you use

oracleasm createdisk....

I hope you didn't try to edit your profile.xml file, that really would be disastrous.

Can you run this query,

select path,name,group_number,header_status from v$asm_disk;

to see if ASM thinks the disk is usable.

Report message to a moderator