SQL> select name, group_number, state from v$asm_diskgroup;
NAME GROUP_NUMBER STATE
------------------------------ ------------ -----------
FRA 1 MOUNTED
OCR 2 MOUNTED
DATA 3 MOUNTED
REDO 4 MOUNTED
DATA2 5 MOUNTED
SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
NAME STATE TYPE TOTAL_MB FREE_MB
------------------------------ ----------- ------ ---------- ----------
FRA MOUNTED EXTERN 1024000 294361
OCR MOUNTED NORMAL 6144 5218
DATA MOUNTED NORMAL 1228800 1060302
REDO MOUNTED NORMAL 46080 45795
DATA2 MOUNTED NORMAL 2457600 1634903
SQL> select name, path, mode_status, state, disk_number from v$asm_disk;
NAME PATH MODE_ST STATE DISK_NUMBER
------------------ ------------------- -------------- ------------------
DATA_0000 /dev/ASM_DATA_Disk1 ONLINE NORMAL 0
DATA_0001 /dev/ASM_DATA_Disk2 ONLINE NORMAL 1
DATA_0002 /dev/ASM_DATA_Disk3 ONLINE NORMAL 2
DATA2_0000 /dev/ASM_DATA_Disk4 ONLINE NORMAL 0
DATA2_0001 /dev/ASM_DATA_Disk5 ONLINE NORMAL 1
DATA2_0002 /dev/ASM_DATA_Disk6 ONLINE NORMAL 2
DATA2_0003 /dev/ASM_DATA_Disk7 ONLINE NORMAL 3
DATA2_0004 /dev/ASM_DATA_Disk8 ONLINE NORMAL 4
DATA2_0005 /dev/ASM_DATA_Disk9 ONLINE NORMAL 5
FRA_0000 /dev/ASM_FRA_Disk1 ONLINE NORMAL 0
FRA_0001 /dev/ASM_FRA_Disk2 ONLINE NORMAL 1
NAME PATH MODE_ST STATE DISK_NUMBER
------------------ ------------------- -------------- ------------------
OCR_0000 /dev/ASM_OCRVOTA_Disk1 ONLINE NORMAL 0
OCR_0001 /dev/ASM_OCRVOTA_Disk2 ONLINE NORMAL 1
OCR_0002 /dev/ASM_OCRVOTA_Disk3 ONLINE NORMAL 2
REDO_0000 /dev/ASM_REDO_Disk1 ONLINE NORMAL 0
REDO_0001 /dev/ASM_REDO_Disk2 ONLINE NORMAL 1
REDO_0002 /dev/ASM_REDO_Disk3 ONLINE NORMAL 2
SQL> select INSTANCE_NAME,DB_NAME,STATUS,SOFTWARE_VERSION,COMPATIBLE_VERSION from v$asm_client;
INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
----------------------------------------------------------------------------------------------------------------------------------
+ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
+ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
DB1 DB CONNECTED 11.2.0.4.0 11.2.0.4.0
INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
----------------------------------------------------------------------------------------------------------------------------------
DB1 DB CONNECTED 11.2.0.4.0 11.2.0.4.0
DBG1 DBG CONNECTED 11.2.0.4.0 11.2.0.4.0
DBG1 DBG CONNECTED 11.2.0.4.0 11.2.0.4.0
SQL> select file_number , sum(bytes)/(1024*1024) from v$asm_file group by file_number;
FILE_NUMBER SUM(BYTES)/(1024*1024)
----------- ----------------------
253 .001464844
255 260.121094
256 5550.01563
257 3787.26563
258 4775.97949
259 1721.26563
260 403.257813
261 100.000977
262 1634.32715
263 34745.0156
264 1321.26563
FILE_NUMBER SUM(BYTES)/(1024*1024)
----------- ----------------------
265 200.008301
266 113.782227
267 63.7861328
268 337920.012
269 24132.6875
270 12288.0156
271 67611.0791
272 3303.13281
274 13.65625
275 92.9921875
276 13.78125
SQL>
set linesize 200
col g_name format a10
col g_n format 99
col d_n format 999
col m_status format a7
col mo_status format a7
col h_status format a11
col name format a30
col path format a45
col failgroup format a15
select g.group_number g_n,
g.disk_number d_n,
g.name name,
g.failgroup,
g.mount_status m_status,
g.header_status h_status,
g.mode_status mo_status,
g.path ,
to_char(g.mount_date, 'YYYY/MM/DD HH24:MI:SS') m_date
from v$asm_disk g
order by g_n, d_n;
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
1 0 FRA_0000 FRA_0000 CACHED MEMBER ONLINE /dev/ASM_FRA_Disk1 2016/01/27 16:48:27
1 1 FRA_0001 FRA_0001 CACHED MEMBER ONLINE /dev/ASM_FRA_Disk2 2016/01/27 16:48:27
2 0 OCR_0000 OCR_0000 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk1 2015/12/23 16:28:21
2 1 OCR_0001 OCR_0001 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk2 2015/12/23 16:28:21
2 2 OCR_0002 OCR_0002 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk3 2015/12/23 16:28:21
3 0 DATA_0000 DATA_0000 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk1 2016/01/27 16:48:28
3 1 DATA_0001 DATA_0001 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk2 2016/01/27 16:48:28
3 2 DATA_0002 DATA_0002 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk3 2016/01/27 16:48:28
4 0 REDO_0000 REDO_0000 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk1 2016/01/27 16:48:28
4 1 REDO_0001 REDO_0001 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk2 2016/01/27 16:48:28
4 2 REDO_0002 REDO_0002 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk3 2016/01/27 16:48:28
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
5 0 DATA2_0000 DATA2_0000 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk4 2016/03/31 16:45:02
5 1 DATA2_0001 DATA2_0001 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk5 2016/03/31 16:45:02
5 2 DATA2_0002 DATA2_0002 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk6 2016/03/31 16:45:02
5 3 DATA2_0003 DATA2_0003 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk7 2016/06/10 14:20:22
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
5 4 DATA2_0004 DATA2_0004 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk8 2016/06/10 14:20:22
5 5 DATA2_0005 DATA2_0005 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk9 2016/06/10 14:20:22
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
FRA MOUNTED
OCR MOUNTED
DATA MOUNTED
REDO MOUNTED
DATA2 MOUNTED
Header Status of ASM Disks
SQL> select HEADER_STATUs, path from v$asm_disk where GROUP_NUMBER = 0;
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string REDO, FRA, DATA, DATA2
asm_diskstring string /dev/ASM*
asm_power_limit integer 1
asm_preferred_read_failure_groups string
SQL> select NAME, STATE, TOTAL_MB, FREE_MB, HOT_USED_MB, COLD_USED_MB, DATABASE_COMPATIBILITY, VOTING_FILES from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB DATABASE_COMPATIBILITY V
------------------------------ ----------- ---------- ---------- ----------- ------------ ------------------------------------------------------------ -
FRA MOUNTED 1024000 294103 0 729897 10.1.0.0.0 N
OCR MOUNTED 6144 5218 0 926 10.1.0.0.0 Y
DATA MOUNTED 1228800 1060302 0 168498 10.1.0.0.0 N
REDO MOUNTED 46080 45795 0 285 10.1.0.0.0 N
DATA2 MOUNTED 2457600 1634903 0 822697 10.1.0.0.0 N
ASMCMD commands:
--------
md_backup, md_restore
lsattr, setattr
cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias
chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount
dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup
chtmpl, lstmpl, mktmpl, rmtmpl
chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 2457600 1634903 409600 612651 0 N DATA2/
MOUNTED EXTERN N 512 4096 1048576 1024000 294361 0 294361 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 6144 5218 2048 1585 0 Y OCR/
MOUNTED NORMAL N 512 4096 1048576 1228800 1060302 409600 325351 0 N DATA/
MOUNTED NORMAL N 512 4096 1048576 46080 45795 15360 15217 0 N REDO/
NAME GROUP_NUMBER STATE
------------------------------ ------------ -----------
FRA 1 MOUNTED
OCR 2 MOUNTED
DATA 3 MOUNTED
REDO 4 MOUNTED
DATA2 5 MOUNTED
SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
NAME STATE TYPE TOTAL_MB FREE_MB
------------------------------ ----------- ------ ---------- ----------
FRA MOUNTED EXTERN 1024000 294361
OCR MOUNTED NORMAL 6144 5218
DATA MOUNTED NORMAL 1228800 1060302
REDO MOUNTED NORMAL 46080 45795
DATA2 MOUNTED NORMAL 2457600 1634903
SQL> select name, path, mode_status, state, disk_number from v$asm_disk;
NAME PATH MODE_ST STATE DISK_NUMBER
------------------ ------------------- -------------- ------------------
DATA_0000 /dev/ASM_DATA_Disk1 ONLINE NORMAL 0
DATA_0001 /dev/ASM_DATA_Disk2 ONLINE NORMAL 1
DATA_0002 /dev/ASM_DATA_Disk3 ONLINE NORMAL 2
DATA2_0000 /dev/ASM_DATA_Disk4 ONLINE NORMAL 0
DATA2_0001 /dev/ASM_DATA_Disk5 ONLINE NORMAL 1
DATA2_0002 /dev/ASM_DATA_Disk6 ONLINE NORMAL 2
DATA2_0003 /dev/ASM_DATA_Disk7 ONLINE NORMAL 3
DATA2_0004 /dev/ASM_DATA_Disk8 ONLINE NORMAL 4
DATA2_0005 /dev/ASM_DATA_Disk9 ONLINE NORMAL 5
FRA_0000 /dev/ASM_FRA_Disk1 ONLINE NORMAL 0
FRA_0001 /dev/ASM_FRA_Disk2 ONLINE NORMAL 1
NAME PATH MODE_ST STATE DISK_NUMBER
------------------ ------------------- -------------- ------------------
OCR_0000 /dev/ASM_OCRVOTA_Disk1 ONLINE NORMAL 0
OCR_0001 /dev/ASM_OCRVOTA_Disk2 ONLINE NORMAL 1
OCR_0002 /dev/ASM_OCRVOTA_Disk3 ONLINE NORMAL 2
REDO_0000 /dev/ASM_REDO_Disk1 ONLINE NORMAL 0
REDO_0001 /dev/ASM_REDO_Disk2 ONLINE NORMAL 1
REDO_0002 /dev/ASM_REDO_Disk3 ONLINE NORMAL 2
SQL> select INSTANCE_NAME,DB_NAME,STATUS,SOFTWARE_VERSION,COMPATIBLE_VERSION from v$asm_client;
INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
----------------------------------------------------------------------------------------------------------------------------------
+ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
+ASM1 +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0
DB1 DB CONNECTED 11.2.0.4.0 11.2.0.4.0
INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
----------------------------------------------------------------------------------------------------------------------------------
DB1 DB CONNECTED 11.2.0.4.0 11.2.0.4.0
DBG1 DBG CONNECTED 11.2.0.4.0 11.2.0.4.0
DBG1 DBG CONNECTED 11.2.0.4.0 11.2.0.4.0
SQL> select file_number , sum(bytes)/(1024*1024) from v$asm_file group by file_number;
FILE_NUMBER SUM(BYTES)/(1024*1024)
----------- ----------------------
253 .001464844
255 260.121094
256 5550.01563
257 3787.26563
258 4775.97949
259 1721.26563
260 403.257813
261 100.000977
262 1634.32715
263 34745.0156
264 1321.26563
FILE_NUMBER SUM(BYTES)/(1024*1024)
----------- ----------------------
265 200.008301
266 113.782227
267 63.7861328
268 337920.012
269 24132.6875
270 12288.0156
271 67611.0791
272 3303.13281
274 13.65625
275 92.9921875
276 13.78125
SQL>
set linesize 200
col g_name format a10
col g_n format 99
col d_n format 999
col m_status format a7
col mo_status format a7
col h_status format a11
col name format a30
col path format a45
col failgroup format a15
select g.group_number g_n,
g.disk_number d_n,
g.name name,
g.failgroup,
g.mount_status m_status,
g.header_status h_status,
g.mode_status mo_status,
g.path ,
to_char(g.mount_date, 'YYYY/MM/DD HH24:MI:SS') m_date
from v$asm_disk g
order by g_n, d_n;
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
1 0 FRA_0000 FRA_0000 CACHED MEMBER ONLINE /dev/ASM_FRA_Disk1 2016/01/27 16:48:27
1 1 FRA_0001 FRA_0001 CACHED MEMBER ONLINE /dev/ASM_FRA_Disk2 2016/01/27 16:48:27
2 0 OCR_0000 OCR_0000 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk1 2015/12/23 16:28:21
2 1 OCR_0001 OCR_0001 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk2 2015/12/23 16:28:21
2 2 OCR_0002 OCR_0002 CACHED MEMBER ONLINE /dev/ASM_OCRVOTA_Disk3 2015/12/23 16:28:21
3 0 DATA_0000 DATA_0000 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk1 2016/01/27 16:48:28
3 1 DATA_0001 DATA_0001 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk2 2016/01/27 16:48:28
3 2 DATA_0002 DATA_0002 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk3 2016/01/27 16:48:28
4 0 REDO_0000 REDO_0000 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk1 2016/01/27 16:48:28
4 1 REDO_0001 REDO_0001 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk2 2016/01/27 16:48:28
4 2 REDO_0002 REDO_0002 CACHED MEMBER ONLINE /dev/ASM_REDO_Disk3 2016/01/27 16:48:28
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
5 0 DATA2_0000 DATA2_0000 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk4 2016/03/31 16:45:02
5 1 DATA2_0001 DATA2_0001 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk5 2016/03/31 16:45:02
5 2 DATA2_0002 DATA2_0002 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk6 2016/03/31 16:45:02
5 3 DATA2_0003 DATA2_0003 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk7 2016/06/10 14:20:22
G_N D_N NAME FAILGROUP M_STATU H_STATUS MO_STAT PATH M_DATE
--- ---- ------------------------------ --------------- ------- ----------- ------- --------------------------------------------- -------------------
5 4 DATA2_0004 DATA2_0004 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk8 2016/06/10 14:20:22
5 5 DATA2_0005 DATA2_0005 CACHED MEMBER ONLINE /dev/ASM_DATA_Disk9 2016/06/10 14:20:22
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
FRA MOUNTED
OCR MOUNTED
DATA MOUNTED
REDO MOUNTED
DATA2 MOUNTED
Header Status of ASM Disks
SQL> select HEADER_STATUs, path from v$asm_disk where GROUP_NUMBER = 0;
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string REDO, FRA, DATA, DATA2
asm_diskstring string /dev/ASM*
asm_power_limit integer 1
asm_preferred_read_failure_groups string
SQL> select NAME, STATE, TOTAL_MB, FREE_MB, HOT_USED_MB, COLD_USED_MB, DATABASE_COMPATIBILITY, VOTING_FILES from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB DATABASE_COMPATIBILITY V
------------------------------ ----------- ---------- ---------- ----------- ------------ ------------------------------------------------------------ -
FRA MOUNTED 1024000 294103 0 729897 10.1.0.0.0 N
OCR MOUNTED 6144 5218 0 926 10.1.0.0.0 Y
DATA MOUNTED 1228800 1060302 0 168498 10.1.0.0.0 N
REDO MOUNTED 46080 45795 0 285 10.1.0.0.0 N
DATA2 MOUNTED 2457600 1634903 0 822697 10.1.0.0.0 N
ASMCMD commands:
--------
md_backup, md_restore
lsattr, setattr
cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias
chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount
dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup
chtmpl, lstmpl, mktmpl, rmtmpl
chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 2457600 1634903 409600 612651 0 N DATA2/
MOUNTED EXTERN N 512 4096 1048576 1024000 294361 0 294361 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 6144 5218 2048 1585 0 Y OCR/
MOUNTED NORMAL N 512 4096 1048576 1228800 1060302 409600 325351 0 N DATA/
MOUNTED NORMAL N 512 4096 1048576 46080 45795 15360 15217 0 N REDO/
No comments:
Post a Comment