set linesize 200
col PATH format a30
col LABEL format a15
select group_number, disk_number, name, label, path, redundancy, mount_status, header_status from v$asm_disk;
GROUP_NUMBER DISK_NUMBER NAME LABEL PATH REDUNDA MOUNT_S HEADER_STATU
------------ ----------- ------------------------------ --------------- ------------------------------ ------- ------- ------------
0 0 DATA ORCL:DATA UNKNOWN CLOSED MEMBER
SQL> ALTER DISKGROUP data mount ;
set linesize 200
col PATH format a30
col LABEL format a15
select group_number, disk_number, name, label, path, redundancy, mount_status, header_status from v$asm_disk;
GROUP_NUMBER DISK_NUMBER NAME LABEL PATH REDUNDA MOUNT_S HEADER_STATU
------------ ----------- ------------------------------ --------------- ------------------------------ ------- ------- ------------
1 0 DATA DATA ORCL:DATA UNKNOWN CACHED MEMBER
alter system set asm_diskstring='/dev/rdsk/*' scope=both;
SQL> alter system set asm_diskstring='ORCL:DATA' scope=both;
System altered.
SQL> alter system set asm_diskgroups='DATA' scope=both ;
1 comment:
Hi Anuj, Thank you for the post. I am having similar problem. I have my both parameters asm_diskgroups and asm_diskstring are set properly as follows
*.asm_diskgroups='SEDEVDATA','SEDEVFRA'
*.asm_diskstring='/dev/oracleasm/disks/*'
I don't have any problems while starting up the ASM instance but I am getting an error message while shutting down. I did not mount all the asm disks though, woudl that be a problem.
Thank you
CT
Post a Comment