I just tried to resize an ASM disk and although the feedback was 'successful', there doesn't appear to have been any change.
I was attempting to shrink disk DATA_0001 from 200G to 100G. Am I missing something obvious?
SQL> select group_number, name, path, os_mb, total_mb, free_mb from v $asm_disk;
GROUP_NUMBER NAME PATH OS_MB TOTAL_MB FREE_MB ------------ -------------------- ------------------------------ ---------- ---------- ---------- 0 /dev/iscsi/rman11 20489 0 0 0 /dev/iscsi/rmanB11 102398 0 0 0 /dev/iscsi/rman1 20490 0 0 0 /dev/iscsi/ vote3 300 0 0 0 /dev/iscsi/ vote1 300 0 0 0 /dev/iscsi/rmanP11 204805 0 0 0 /dev/iscsi/ vote2 300 0 0 0 /dev/iscsi/rmanP1 204810 0 0 0 /dev/iscsi/rmanB1 102405 0 0 1 DATA_0000 /dev/iscsi/db1 10245 10245 10109 2 FRA_0000 /dev/iscsi/flshbk1 20490 20490 20465
GROUP_NUMBER NAME PATH OS_MB TOTAL_MB FREE_MB ------------ -------------------- ------------------------------ ---------- ---------- ---------- 2 FRA_0001 /dev/iscsi/flshbkR1 409605 409605 409262 1 DATA_0001 /dev/iscsi/dbR1 204810 204810 202297
13 rows selected. SQL> alter diskgroup data resize disk 'data_0001' size 100g; Diskgroup altered.SQL> select group_number, name, path, os_mb, total_mb, free_mb from v $asm_disk;
GROUP_NUMBER NAME PATH OS_MB TOTAL_MB FREE_MB ------------ -------------------- ------------------------------ ---------- ---------- ---------- 0 /dev/iscsi/rman11 20489 0 0 0 /dev/iscsi/rmanB11 102398 0 0 0 /dev/iscsi/rman1 20490 0 0 0 /dev/iscsi/ vote3 300 0 0 0 /dev/iscsi/ vote1 300 0 0 0 /dev/iscsi/rmanP11 204805 0 0 0 /dev/iscsi/ vote2 300 0 0 0 /dev/iscsi/rmanP1 204810 0 0 0 /dev/iscsi/rmanB1 102405 0 0 1 DATA_0000 /dev/iscsi/db1 10245 10245 10004 2 FRA_0000 /dev/iscsi/flshbk1 20490 20490 20465
GROUP_NUMBER NAME PATH OS_MB TOTAL_MB FREE_MB ------------ -------------------- ------------------------------ ---------- ---------- ---------- 2 FRA_0001 /dev/iscsi/flshbkR1 409605 409605 409262 1 DATA_0001 /dev/iscsi/dbR1 204810 204810 202402
13 rows selected.The free_mb seems to have increased, but otherwise I can't see the effect of my change. Maybe I'm looking in the wrong place??
I tried restarting the ASM instance but it made no difference. Thanks, Steve This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email. -- //www.freelists.org/webpage/oracle-l
