set lines 200 pages 999
col name format a15
col sector_size for 999999999
col total_mb for 999999999
col free_mb for 999999999
col usable_file_mb for 999999999
select group_number, name,allocation_unit_size alloc_unit_size, sector_size,
state,type,total_mb,free_mb,usable_file_mb,round((free_mb*100/total_mb),2) "%Free"
from v$asm_diskgroup;
GROUP_NUMBER NAME ALLOC_UNIT_SIZE SECTOR_SIZE STATE TYPE
TOTAL_MB FREE_MB USABLE_FILE_MB %Free
------------ --------------- --------------- ----------- ----------- ------
---------- ---------- -------------- ----------
1 OCR 4194304 512 MOUNTED EXTERN
2988 2556 2556 85.54
2 DATA_DG 4194304 512 MOUNTED EXTERN
2095296 458704 458704 21.89
3 RECO_DG 4194304 512 MOUNTED EXTERN
11952 1608 1608 13.45
4 ARCH_DG 4194304 512 MOUNTED EXTERN
199552 178340 178340 89.37
SQL>
SQL> show parameter asm_power_limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 1
SQL> alter session set asm_power_limit=1024;
Session altered.
SQL> show parameter asm_power_limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 1024
SQL>
set lines 200 pages 999
col group_number head GRP_N for 99999
col disk_number head DSK_N for 99999
col name for a18
col path for a54
col label for a5
select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, NAME, PATH,
TOTAL_MB, LABEL from v$asm_disk_stat where NAME like '%ARCH%' order by 1,5;
set lines 200 pages 999
col group_number head GRP_N for 99999
col disk_number head DSK_N for 99999
col name for a18
col path for a54
col label for a5
select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, NAME, PATH,
TOTAL_MB, LABEL from v$asm_disk_stat order by 1,5;
GRP_N DSK_N MOUNT_S HEADER_STATU NAME PATH
TOTAL_MB LABEL
------ ------ ------- ------------ ------------------
------------------------------------------------------ ---------- -----
2 0 CACHED MEMBER DATA_DG_0000 /dev/rdsk/asmdisk/disk06s4
49888
2 1 CACHED MEMBER DATA_DG_0001 /dev/rdsk/asmdisk/disk07s4
49888
2 2 CACHED MEMBER DATA_DG_0002 /dev/rdsk/asmdisk/disk08s4
49888
2 3 CACHED MEMBER DATA_DG_0003 /dev/rdsk/asmdisk/disk09s4
49888
2 4 CACHED MEMBER DATA_DG_0004 /dev/rdsk/asmdisk/disk10s4
49888
2 5 CACHED MEMBER DATA_DG_0005 /dev/rdsk/asmdisk/disk11s4
49888
2 6 CACHED MEMBER DATA_DG_0006 /dev/rdsk/asmdisk/disk12s4
49888
2 7 CACHED MEMBER DATA_DG_0007 /dev/rdsk/asmdisk/disk13s4
49888
2 8 CACHED MEMBER DATA_DG_0008 /dev/rdsk/asmdisk/disk14s4
49888
2 9 CACHED MEMBER DATA_DG_0009 /dev/rdsk/asmdisk/disk15s4
49888
2 10 CACHED MEMBER DATA_DG_0010 /dev/rdsk/asmdisk/disk16s4
49888
2 11 CACHED MEMBER DATA_DG_0011 /dev/rdsk/asmdisk/disk17s4
49888
2 12 CACHED MEMBER DATA_DG_0012 /dev/rdsk/asmdisk/disk18s4
49888
2 13 CACHED MEMBER DATA_DG_0013 /dev/rdsk/asmdisk/disk19s4
49888
2 14 CACHED MEMBER DATA_DG_0014 /dev/rdsk/asmdisk/disk20s4
49888
2 15 CACHED MEMBER DATA_DG_0015 /dev/rdsk/asmdisk/disk21s4
49888
2 16 CACHED MEMBER DATA_DG_0016 /dev/rdsk/asmdisk/disk22s4
49888
2 17 CACHED MEMBER DATA_DG_0017 /dev/rdsk/asmdisk/disk23s4
49888
2 18 CACHED MEMBER DATA_DG_0018 /dev/rdsk/asmdisk/disk24s4
49888
2 19 CACHED MEMBER DATA_DG_0019 /dev/rdsk/asmdisk/disk25s4
49888
2 20 CACHED MEMBER DATA_DG_0020 /dev/rdsk/asmdisk/disk26s4
49888
2 21 CACHED MEMBER DATA_DG_0021 /dev/rdsk/asmdisk/disk27s4
49888
2 22 CACHED MEMBER DATA_DG_0022 /dev/rdsk/asmdisk/disk28s4
49888
2 23 CACHED MEMBER DATA_DG_0023 /dev/rdsk/asmdisk/disk29s4
49888
2 24 CACHED MEMBER DATA_DG_0024 /dev/rdsk/asmdisk/disk30s4
49888
2 25 CACHED MEMBER DATA_DG_0025 /dev/rdsk/asmdisk/disk31s4
49888
2 26 CACHED MEMBER DATA_DG_0026 /dev/rdsk/asmdisk/disk32s4
49888
2 27 CACHED MEMBER DATA_DG_0027 /dev/rdsk/asmdisk/disk33s4
49888
2 28 CACHED MEMBER DATA_DG_0028 /dev/rdsk/asmdisk/disk34s4
49888
2 29 CACHED MEMBER DATA_DG_0029 /dev/rdsk/asmdisk/disk35s4
49888
2 30 CACHED MEMBER DATA_DG_0030 /dev/rdsk/asmdisk/disk36s4
49888
2 31 CACHED MEMBER DATA_DG_0031 /dev/rdsk/asmdisk/disk37s4
49888
2 32 CACHED MEMBER DATA_DG_0032 /dev/rdsk/asmdisk/disk38s4
49888
2 33 CACHED MEMBER DATA_DG_0033 /dev/rdsk/asmdisk/disk39s4
49888
2 34 CACHED MEMBER DATA_DG_0034 /dev/rdsk/asmdisk/disk40s4
49888
2 35 CACHED MEMBER DATA_DG_0035 /dev/rdsk/asmdisk/disk41s4
49888
2 36 CACHED MEMBER DATA_DG_0036 /dev/rdsk/asmdisk/disk42s4
49888
2 37 CACHED MEMBER DATA_DG_0037 /dev/rdsk/asmdisk/disk43s4
49888
2 38 CACHED MEMBER DATA_DG_0038 /dev/rdsk/asmdisk/disk44s4
49888
2 39 CACHED MEMBER DATA_DG_0039 /dev/rdsk/asmdisk/disk45s4
49888
2 40 CACHED MEMBER DATA_DG_0040 /dev/rdsk/asmdisk/disk46s4
49888
2 41 CACHED MEMBER DATA_DG_0041 /dev/rdsk/asmdisk/disk47s4
49888
42 rows selected.
SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------ ---------- ----------
OCR 2988 2556
DATA_DG 2095296 458704
RECO_DG 11952 1608
ARCH_DG 199552 176600
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0041;
Diskgroup altered.
SQL> SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------ ---------- ----------
OCR 2988 2556
DATA_DG 2045408 408816
RECO_DG 11952 1608
ARCH_DG 199552 176600
SQL>
GRP_N OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
EST_MINUTES ERROR_CODE
------ ----- ---- ---------- ---------- ---------- ---------- ----------
----------- --------------------------------------------
2 REBAL RUN 11 11 593 16057 2486
6
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0040;
Diskgroup altered.
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0039;
Diskgroup altered.
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0038;
Diskgroup altered.
SQL> select * from v$asm_operation;
GRP_N OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
EST_MINUTES ERROR_CODE
------ ----- ---- ---------- ---------- ---------- ---------- ----------
----------- --------------------------------------------
2 REBAL RUN 11 11 505 27972 2514
10
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0037;
Diskgroup altered.
SQL>
SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------ ---------- ----------
OCR 2988 2556
DATA_DG 1845856 209272
RECO_DG 11952 1608
ARCH_DG 199552 175736
SQL> select * from v$asm_operation;
GRP_N OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
EST_MINUTES ERROR_CODE
------ ----- ---- ---------- ---------- ---------- ---------- ----------
----------- --------------------------------------------
2 REBAL RUN 11 11 955 20955 3350
5
SQL> select * from v$asm_operation;
no rows selected
SQL>
SQL> select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, NAME, PATH,
TOTAL_MB, LABEL from v$asm_disk_stat where name like 'DATA_HUS%' order by 1,5;
GRP_N DSK_N MOUNT_S HEADER_STATU NAME PATH
TOTAL_MB LABEL
------ ------ ------- ------------ ------------------
------------------------------------------------------ ---------- -----
2 0 CACHED MEMBER DATA_DG_0000 /dev/rdsk/asmdisk/disk06s4
49888
2 1 CACHED MEMBER DATA_DG_0001 /dev/rdsk/asmdisk/disk07s4
49888
2 2 CACHED MEMBER DATA_DG_0002 /dev/rdsk/asmdisk/disk08s4
49888
2 3 CACHED MEMBER DATA_DG_0003 /dev/rdsk/asmdisk/disk09s4
49888
2 4 CACHED MEMBER DATA_DG_0004 /dev/rdsk/asmdisk/disk10s4
49888
2 5 CACHED MEMBER DATA_DG_0005 /dev/rdsk/asmdisk/disk11s4
49888
2 6 CACHED MEMBER DATA_DG_0006 /dev/rdsk/asmdisk/disk12s4
49888
2 7 CACHED MEMBER DATA_DG_0007 /dev/rdsk/asmdisk/disk13s4
49888
2 8 CACHED MEMBER DATA_DG_0008 /dev/rdsk/asmdisk/disk14s4
49888
2 9 CACHED MEMBER DATA_DG_0009 /dev/rdsk/asmdisk/disk15s4
49888
2 10 CACHED MEMBER DATA_DG_0010 /dev/rdsk/asmdisk/disk16s4
49888
2 11 CACHED MEMBER DATA_DG_0011 /dev/rdsk/asmdisk/disk17s4
49888
2 12 CACHED MEMBER DATA_DG_0012 /dev/rdsk/asmdisk/disk18s4
49888
2 13 CACHED MEMBER DATA_DG_0013 /dev/rdsk/asmdisk/disk19s4
49888
2 14 CACHED MEMBER DATA_DG_0014 /dev/rdsk/asmdisk/disk20s4
49888
2 15 CACHED MEMBER DATA_DG_0015 /dev/rdsk/asmdisk/disk21s4
49888
2 16 CACHED MEMBER DATA_DG_0016 /dev/rdsk/asmdisk/disk22s4
49888
2 17 CACHED MEMBER DATA_DG_0017 /dev/rdsk/asmdisk/disk23s4
49888
2 18 CACHED MEMBER DATA_DG_0018 /dev/rdsk/asmdisk/disk24s4
49888
2 19 CACHED MEMBER DATA_DG_0019 /dev/rdsk/asmdisk/disk25s4
49888
2 20 CACHED MEMBER DATA_DG_0020 /dev/rdsk/asmdisk/disk26s4
49888
2 21 CACHED MEMBER DATA_DG_0021 /dev/rdsk/asmdisk/disk27s4
49888
2 22 CACHED MEMBER DATA_DG_0022 /dev/rdsk/asmdisk/disk28s4
49888
2 23 CACHED MEMBER DATA_DG_0023 /dev/rdsk/asmdisk/disk29s4
49888
2 24 CACHED MEMBER DATA_DG_0024 /dev/rdsk/asmdisk/disk30s4
49888
2 25 CACHED MEMBER DATA_DG_0025 /dev/rdsk/asmdisk/disk31s4
49888
2 26 CACHED MEMBER DATA_DG_0026 /dev/rdsk/asmdisk/disk32s4
49888
2 27 CACHED MEMBER DATA_DG_0027 /dev/rdsk/asmdisk/disk33s4
49888
2 28 CACHED MEMBER DATA_DG_0028 /dev/rdsk/asmdisk/disk34s4
49888
2 29 CACHED MEMBER DATA_DG_0029 /dev/rdsk/asmdisk/disk35s4
49888
2 30 CACHED MEMBER DATA_DG_0030 /dev/rdsk/asmdisk/disk36s4
49888
2 31 CACHED MEMBER DATA_DG_0031 /dev/rdsk/asmdisk/disk37s4
49888
2 32 CACHED MEMBER DATA_DG_0032 /dev/rdsk/asmdisk/disk38s4
49888
2 33 CACHED MEMBER DATA_DG_0033 /dev/rdsk/asmdisk/disk39s4
49888
2 34 CACHED MEMBER DATA_DG_0034 /dev/rdsk/asmdisk/disk40s4
49888
2 35 CACHED MEMBER DATA_DG_0035 /dev/rdsk/asmdisk/disk41s4
49888
2 36 CACHED MEMBER DATA_DG_0036 /dev/rdsk/asmdisk/disk42s4
49888
37 rows selected.
SQL> show parameter asm_power_limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 1024
SQL>
SQL> alter session set asm_power_limit=1;
Session altered.
SQL> show parameter asm_power_limit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit integer 1
SQL>
select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, NAME, PATH,
TOTAL_MB, LABEL from v$asm_disk
where
header_status='CANDIDATE'
order by 1,5;
SQL> select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, NAME, PATH,
TOTAL_MB, LABEL from v$asm_disk
where
header_status='FORMER'
order by 1,5;
GRP_N DSK_N MOUNT_S HEADER_STATU NAME PATH
TOTAL_MB LABEL
------ ------ ------- ------------ ------------------
------------------------------------------------------ ---------- -----
0 0 CLOSED FORMER /dev/rdsk/asmdisk/disk47s4
0
0 1 CLOSED FORMER /dev/rdsk/asmdisk/disk43s4
0
0 2 CLOSED FORMER /dev/rdsk/asmdisk/disk44s4
0
0 3 CLOSED FORMER /dev/rdsk/asmdisk/disk45s4
0
0 4 CLOSED FORMER /dev/rdsk/asmdisk/disk46s4
ALTER DATABASE RENAME FILE '/niaiimsarchdb/redo1/archiims/redo01_01.log' TO
'+RECO01_DG' ;
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
ALTER DATABASE RENAME FILE '
alter diskgroup DATA_DG undrop disks;
CREATE DISKGROUP FIN_DATA External REDUNDANCY
DISK '/dev/rdsk/asmdisk/datadisk02',
'/dev/rdsk/asmdisk/datadisk01',
'/dev/rdsk/asmdisk/datadisk03'
ATTRIBUTE 'au_size'='4M';
CREATE DISKGROUP REDO External REDUNDANCY
DISK '/dev/rdsk/asmdisk/redodisk01'
ATTRIBUTE 'au_size'='4M';
alter diskgroup <diskgroupname> dismount on 2nd instance.
drop diskgroup <diskgroupname> including contents;
SQL> select
GROUP_NUMBER,HEADER_STATUS,MODE_STATUS,MOUNT_STATUS,DISK_NUMBER,STATE,PATH from
v$ASM_DISK;
GROUP_NUMBER HEADER_STATU MODE_ST MOUNT_S DISK_NUMBER STATE PATH
------------ ------------ ------- ------- ----------- --------
-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
-------
0 FORMER ONLINE CLOSED 0 NORMAL
/dev/rdsk/asmdisk/HITACHI_ARCH_DISK01
0 FORMER ONLINE CLOSED 1 NORMAL
/dev/rdsk/asmdisk/HITACHI_ARCH_DISK02
0 FORMER ONLINE CLOSED 2 NORMAL
/dev/rdsk/asmdisk/HITACHI_ARCH_DISK04
0 FORMER ONLINE CLOSED 3 NORMAL
/dev/rdsk/asmdisk/HITACHI_ARCH_DISK03
0 FORMER ONLINE CLOSED 4 NORMAL
/dev/rdsk/asmdisk/HITACHI_SATA_DATA04
0 FORMER ONLINE CLOSED 5 NORMAL
/dev/rdsk/asmdisk/HITACHI_SATA_DATA10
