Home » RDBMS Server » Server Administration » ASM add disk issue (Linux 2.6.18-92.1.13.el5)
ASM add disk issue [message #526325] Mon, 10 October 2011 10:06 Go to next message
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>

Re: ASM add disk issue [message #526327 is a reply to message #526325] Mon, 10 October 2011 10:11 Go to previous messageGo to next message
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.
Re: ASM add disk issue [message #526328 is a reply to message #526327] Mon, 10 October 2011 10:14 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

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

Re: ASM add disk issue [message #526332 is a reply to message #526328] Mon, 10 October 2011 10:20 Go to previous messageGo to next message
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>
Re: ASM add disk issue [message #526333 is a reply to message #526332] Mon, 10 October 2011 10:23 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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!
Re: ASM add disk issue [message #526335 is a reply to message #526325] Mon, 10 October 2011 10:29 Go to previous messageGo to next message
John Watson
Messages: 4522
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.
Re: ASM add disk issue [message #526336 is a reply to message #526333] Mon, 10 October 2011 10:34 Go to previous messageGo to next message
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
Re: ASM add disk issue [message #526351 is a reply to message #526336] Mon, 10 October 2011 12:17 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Please suggest ..
Re: ASM add disk issue [message #526352 is a reply to message #526351] Mon, 10 October 2011 12:24 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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?
Re: ASM add disk issue [message #526353 is a reply to message #526352] Mon, 10 October 2011 12:30 Go to previous messageGo to next message
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?
Re: ASM add disk issue [message #526354 is a reply to message #526353] Mon, 10 October 2011 12:38 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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."
Re: ASM add disk issue [message #526355 is a reply to message #526354] Mon, 10 October 2011 12:49 Go to previous messageGo to next message
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]
Re: ASM add disk issue [message #526360 is a reply to message #526355] Mon, 10 October 2011 13:06 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
Er... Do you intend to look at the RBAL trace file? It might help.
Re: ASM add disk issue [message #526364 is a reply to message #526360] Mon, 10 October 2011 13:30 Go to previous messageGo to next message
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.
Re: ASM add disk issue [message #526365 is a reply to message #526364] Mon, 10 October 2011 13:31 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
post DDL used to initially CREATE DISKGROUP
Re: ASM add disk issue [message #526428 is a reply to message #526365] Tue, 11 October 2011 01:30 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Not sure for DDL used for create disk.. It happens long back.
Re: ASM add disk issue [message #526444 is a reply to message #526428] Tue, 11 October 2011 02:30 Go to previous messageGo to next message
John Watson
Messages: 4522
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.
Re: ASM add disk issue [message #526636 is a reply to message #526444] Wed, 12 October 2011 02:33 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Issue is resolved. We can close this service request.

Thanks for all help.

Issue resolved with adding value in parameter asm_diskstring=orcl:*
Re: ASM add disk issue [message #526637 is a reply to message #526636] Wed, 12 October 2011 02:38 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Since disk group is for FRA, so also need to change in DB_RECOVERY_FILE_DEST_SIZE as suggested from you.

Thanks for all support.
Previous Topic: possible to find out last access to a table?
Next Topic: TEMP tablespace estimation
Goto Forum:
  


Current Time: Tue Sep 02 02:43:25 CDT 2014

Total time taken to generate the page: 0.21487 seconds