理解ASM（五）ASM工具

[oracle@localhost ~]$ asmcmd help=y

commands:

--------

cd

du

find

help

ls

lsct

lsdg

mkalias

mkdir

pwd

rm

rmalias

① 列出目錄資訊

ASMCMD> ls

DATA/

ASMCMD> ls -al

State Type Rebal Unbal Name

MOUNTED NORMAL N N DATA/

② 別名

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> 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> find +DATA redo*

+DATA/ORCL/ONLINELOG/redo_log_group_3.log

⑤ 顯示ASM和資料庫執行個體的串連情況

ASMCMD> lsct

⑥ 刪除檔案

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

oracle視頻教程請關注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html