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 ] [--privilege ] [-p] [command]

asmcmd_no_conn_str

Starts asmcmd (if no parameters) or executes the command with given parameters

asmcmd [-V] [-v ] [--privilege ] [-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