sqlplus sys as sysasm进入ASM管理工具
1、1：配置oracle用户PATH
[oracle@node1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_SID=orcl1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/11.2.0.4/oracle
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
[oracle@node1 ~]$ echo $PATH
/u01/app/11.2.0.4/oracle/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
注意：因为ASM管理工具需要使用PLSQL工具，吩沟所以PATH中需要配置oracle关键安装目录
2、2：export增加集群软件安装目录
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ export ORACLE_SID=+ASM1
[oracle@node1 ~]$ export ORACLE_HOME=/u01/app/11.2.0.4/grid/
[oracle@node1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
3、3：sqlplus sys as sysasm 进入工具
4、4：查看DG和磁盘信息
[oracle@node1 ~]$ sqlplus sys as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 22 16:21:47 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> col name for a20
SQL> col path for a30
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- ------------------------------
/dev/mapper/dataB04
/dev/mapper/crsB13
/dev/mapper/dataB02
/dev/mapper/dataA04
/dev/mapper/crsB11
/dev/mapper/crsA12
/dev/mapper/dataA01
/dev/mapper/crsB12
/dev/mapper/dataA05
/dev/mapper/dataA03
/dev/mapper/crsA13
NAME PATH
-------------------- ------------------------------
/dev/mapper/crsA11
/dev/mapper/dataA02
怕态肺 /dev/mapper/dataB03
/dev/mapper/dataB01
/dev/mapper/dataB05
GRIDDG_0002 /dev/mapper/crsB14
GRIDDG_0001 季伟 /dev/mapper/crsA15
GRIDDG_0003 /dev/mapper/crsB15
GRIDDG_0000 /dev/mapper/crsA14
20 rows selected.
只有集群信息
5、5：查看实例名和spfile
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM1
lock_name_space string
service_names string +ASM
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +GRIDDG/node-cluster/asmparame
terfile/registry.253.885742421
6、6：相关ASM视图
V$ASM_ALIAS,
V$ASM_CLIENT,
V$ASM_DISK,
V$ASM_DISK_IOSTAT,
V$ASM_DISK_STAT,
V$ASM_DISKGROUP,
V$ASM_DISKGROUP_STAT,
V$ASM_FILE,
V$ASM_TEMPLATE,
V$ASM_USER,
V$ASM_USERGROUP,
V$ASM_USERGROUP_MEMBER