Oracle ASM管理监控命令
目的:
查看目前Oracle ASM相关的信息。
1.查看磁盘组
[root@newarpdb01 ~]# su - oracle
[oracle@newarpdb01 ~]$ sqlplus "/as sysdba"
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ----------- ---------- ----------
1 OCR MOUNTED 30720 29794
2 DATA CONNECTED 2097152 1935206
可以看到目前RAC数据库是DATA和OCRasm磁盘组。并且data磁盘组，总共是2TB左右。
2.查看目前归档
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/archivelog
Oldest online log sequence 4695
Next log sequence to archive 4696
Current log sequence 4696
3.查看ASM的磁盘路径
SQL> col name format a10;
SQL> col path format a20;
SQL> col STATE format a20;
SQL> select path, name ,STATE,TOTAL_MB,FREE_MB from v$asm_disk;
PATH NAME STATE TOTAL_MB FREE_MB
-------------------- ---------- -------------------- ---------- ----------
/dev/ocr1 OCR_0000 NORMAL 10240 9933
/dev/ocr2 OCR_0001 NORMAL 10240 9931
/dev/ocr3 OCR_0002 NORMAL 10240 9930
/dev/datadisk2 DATA_0001 NORMAL 1048576 967628
/dev/datadisk1 DATA_0000 NORMAL 1048576 967578
/dev/datadisk8 NORMAL 0 0
/dev/datadisk6 NORMAL 0 0
/dev/datadisk3 NORMAL 0 0
/dev/datadisk5 NORMAL 0 0
/dev/datadisk10 NORMAL 0 0
/dev/datadisk9 NORMAL 0 0
PATH NAME STATE TOTAL_MB FREE_MB
-------------------- ---------- -------------------- ---------- ----------
/dev/datadisk4 NORMAL 0 0
/dev/datadisk7 NORMAL 0 0
13 rows selected.
4. asmcmd
4.1 进入asmcmd
[root@newarpdb01 ~]# su - grid
[grid@newarpdb01 ~]$ asmcmd
ASMCMD> help ---可以看到asmcmd的帮助文档
asmcmd [-V] [-v <errors|warnings|normal|info|debug>] [--privilege <sysasm|sysdba>] [-p] [command]
asmcmd_no_conn_str
Starts asmcmd (if no parameters) or executes the command with given parameters
asmcmd [-V] [-v <errors|warnings|normal|info|debug>] [--privilege <sysasm|sysdba>] [-p] [command]
Specify the connect string after the -c option to use the listener to
connect. By default, ASMCMD asks for a password in a non-echoing
prompt, unless the password is specified as part of the connect string.
The connect identifier is in the form of "host:port:sid", with the
host and the port being option. Host defaults to "localhost" and port
to 1521. If the sid is not specified as a part of the connect
identifier, then it is read from the environment variable ORACLE_SID.
If no connect string is used, then environment variables
ORACLE_HOME and ORACLE_SID determine the instance to which the program
connects, and asmcmd establishes a bequeath connection to the it, in
the same manner as a SQLPLUS / AS SYSASM. The user must be a member
of the SYSDBA group to exercise this option.
Specifying the -V option prints the asmcmd version number and
exits immediately.
Specifying the -v option prints extra information that can help
advanced users diagnose problems.
Specify the --privilege option to choose the type of connection. There are
only two possibilities: connecting as SYSASM or as SYSDBA.
The default value if this option is unspecified is SYSASM:
Specifying the -p option allows the current directory to be displayed
in the command prompt, like so:
ASMCMD [+DATA/ORCL/CONTROLFILE] >
The parameter command specifies one of the following commands, along
with its parameters.
Type "help [command]" to get help on a specific ASMCMD command.
commands:
--------
md_backup, md_restore
analyze
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
4.2 lsdg 查看磁盘组信息
查看lsdg的帮忙命令
ASMCMD> help lsdg
lsdg
Lists disk groups and their information. lsdg queries
V$ASM_DISKGROUP_STAT by default. If the --discovery flag is specified,
the V$ASM_DISKGROUP is queried instead. The output also includes
notification of any current rebalance operation for a disk group. If
a disk group is specified, then lsdg returns only information about
that disk group.
使用lsdg，查看asm磁盘组的详细信息，如磁盘大小，可用大小。
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 EXTERN N 512 4096 1048576 2097152 1935206 0 1935206 0 N DATA/
MOUNTED NORMAL N 512 4096 1048576 30720 29794 10240 9777 0 Y OCR/
其他命令，和linux的相关命令类似。可自我探索。
例如:在Oracle asm中找到归档日志的位置。如下:
[grid@newarpdb01 ~]$ asmcmd
ASMCMD> ls
DATA/
OCR/
ASMCMD> cd DATA
ASMCMD> ls
NEWARPDB/
archivelog/
ASMCMD> cd archivelog
ASMCMD> ls -l arch_5136_1002312928_0002.arc
Type Redund Striped Time Sys Name
N arch_5136_1002312928_0002.arc => +DATA/NEWARPDB/ARCHIVELOG/2019_11_26/thread_2_seq_5136.1628.1025345465