理解ASM（五）ASM工具：asmcmd

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 107 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wencan-gz/archive/2012/11/11/2765260.html

文章标签：

#数据库

[sql] view plaincopyprint?

[oracle@localhost ~]$ asmcmd help=y
commands:
--------
cd
du
find
help
ls
lsct
lsdg
mkalias
mkdir
pwd
rm
rmalias

[oracle@localhost ~]$ asmcmd help=y
        commands: 
        --------  
        cd
        du
        find
        help
        ls
        lsct
        lsdg
        mkalias
        mkdir
        pwd
        rm
        rmalias

① 列出目录信息

[sql] view plaincopyprint?

ASMCMD> ls
DATA/
ASMCMD> ls -al
State Type Rebal Unbal Name
MOUNTED NORMAL N N DATA/

ASMCMD> ls
DATA/
ASMCMD> ls -al
State    Type    Rebal  Unbal  Name
MOUNTED  NORMAL  N      N      DATA/

② 别名

[sql] view plaincopyprint?

ASMCMD> ls -al
Type Redund Striped Time Sys Name
ONLINELOG MIRROR FINE NOV 04 19:00:00 Y none => group_4.256.798491239
ASMCMD> mkalias group_4.256.798491239 redo_log_group_3.log
ASMCMD> ls -al
Type Redund Striped Time Sys Name
ONLINELOG MIRROR FINE NOV 04 19:00:00 Y +DATA/ORCL/ONLINELOG/redo_log_group_3.log => group_4.256.798491239
N redo_log_group_3.log => +DATA/ORCL/ONLINELOG/group_4.256.798491239

ASMCMD> ls -al
Type       Redund  Striped  Time             Sys  Name
ONLINELOG  MIRROR  FINE     NOV 04 19:00:00  Y    none => group_4.256.798491239
ASMCMD> mkalias group_4.256.798491239 redo_log_group_3.log
ASMCMD> ls -al
Type       Redund  Striped  Time             Sys  Name
ONLINELOG  MIRROR  FINE     NOV 04 19:00:00  Y    +DATA/ORCL/ONLINELOG/redo_log_group_3.log => group_4.256.798491239
                                             N    redo_log_group_3.log => +DATA/ORCL/ONLINELOG/group_4.256.798491239

③ 查看空间

[sql] view plaincopyprint?

ASMCMD> du
Used_MB Mirror_used_MB
89 179
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N N 512 4096 1048576 701 358 101 128 0 DATA/

ASMCMD> du
Used_MB      Mirror_used_MB
     89                 179
ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  NORMAL  N      N         512   4096  1048576       701      358              101             128              0  DATA/

④ 查找文件

[sql] view plaincopyprint?

ASMCMD> find +DATA redo*
+DATA/ORCL/ONLINELOG/redo_log_group_3.log

ASMCMD> find +DATA redo*
+DATA/ORCL/ONLINELOG/redo_log_group_3.log

⑤ 显示ASM和数据库实例的连接情况

[sql] view plaincopyprint?

ASMCMD> lsct

ASMCMD> lsct

⑥ 删除文件

[sql] view plaincopyprint?

ASMCMD> rm +DATA/ORCL/ONLINELOG/redo_log_group_3.log

转载于:https://www.cnblogs.com/wencan-gz/archive/2012/11/11/2765260.html