Oracle ASM查看信息

一 查看有关ASM 的视图

SQL> select table\_name from dict where table\_name like '%ASM%';
ASM相关管理视图

• v$ASM\_ALIAS：每个disk group的列的别名
• V$ASM\_ATTRIBUTE：显示每一列属性定义
• v$ASM\_CLIENT：ASM实例
• V$ASM\_DISK：显示DISK属性
• V$ASM\_DISK\_IOSTAT：显示DISK IO操作统计
• V$ASM\_DISK\_STAT：与v$ASM\_DISK显示一样，但是基于性能考虑不进行扫描硬盘操作
• V$ASM\_DISKGROUP：显示ASM DISKGROUP信息
• V$ASM\_FILE：显示基于ASM存储的文件信息
• VASM\_OPERATION：查看基于ASM大型运行操作信息

二 查看磁盘组信息

SQL> col name for a15
SQL> col state a8
SQL> col type for a10
SQL> select group\_number,name,state,type from v$asm\_diskgroup;
GROUP\_NUMBER NAME STATE TYPE
------------ --------------- -------- ----------
1 DATADG MOUNTED NORMAL
2 SYSTEDG CONNECTE NORMAL

三 查看磁盘组中的成员名称，路径，大小

SQL> select group\_number,name,path,os\_mb,free\_mb from v$asm\_disk order by 1 desc;

GROUP\_NUMBER NAME  PATH  OS\_MB FREE\_MB
2  SYSTEDG\_0001 /dev/asm-diskh 2048 207
2  SYSTEDG\_0000 /dev/asm-diskg 2048 207
1  DATADG\_0001 /dev/asm-diskc 210 175
1  DATADG\_0000 /dev/asm-diskb 208 172
1  DATADG\_0004 /dev/asm-diskf 200 164
1  DATADG\_0002 /dev/asm-diskd 211 173
1  DATADG\_0003 /dev/asm-diske 210 172

四 ASMCMD 工具

[root@ogg1 ~]\# su - grid
[grid@ogg1 ~]$ which asmcmd
/g01/11ggrid/app/11.2.0/grid/bin/asmcmd
[grid@ogg1 ~]$ asmcmd
ASMCMD> help
ASMCMD> ls
DATADG/
SYSTEDG/
ASMCMD> cd systedg
ASMCMD> ls
PROD1/
ASMCMD> cd prod1
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileprod1.ora
ASMCMD> cd datafile
ASMCMD> ls
EXAMPLE.265.885576627
SYSAUX.257.885576451
SYSTEM.256.885576449
UNDOTBS1.258.885576451
USERS.259.885576451
ASMCMD> lsdsk
Path
/dev/asm-diskb
/dev/asm-diskc
/dev/asm-diskd
/dev/asm-diske
/dev/asm-diskf
/dev/asm-diskg
/dev/asm-diskh
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 1039 856 211 322 0 N DATADG/
MOUNTED NORMAL N 512 4096 1048576 4096 374 0 187 0 N SYSTEDG/

转载自chenoracle