oracle11gRAC之asm管理

oracle11gRAC之asm管理

一：透過sqlplus檢視asm磁碟組與磁碟基本資訊

[grid@dbserver1:/home/grid]$sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 27 13:54:32 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
------------------------------------------------ ------------------------------------
+ASM1 STARTED

SQL> select group_number,name,state,type,total_mb,free_mb from v$asm_diskgroup;
SQL> col name format a15
SQL> /

GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB
------------ --------------- --------------------------------- ------------------ ---------- ----------
1 CRS MOUNTED EXTERN 15360 14960
2 DATADG MOUNTED EXTERN 3072000 1662844

SQL> col path format a15
SQL> col failgroup format a15
SQL> select group_number, name,failgroup, path,os_mb,free_mb,total_mb,state from V$asm_disk order by 1;

GROUP_NUMBER NAME FAILGROUP PATH OS_MB FREE_MB TOTAL_MB STATE
------------ --------------- --------------- --------------- ---------- ---------- ---------- ------------------------
1 CRS_0002 CRS_0002 /dev/rhdisk8 5120 4997 5120 NORMAL
1 CRS_0001 CRS_0001 /dev/rhdisk7 5120 4999 5120 NORMAL
1 CRS_0000 CRS_0000 /dev/rhdisk6 5120 4964 5120 NORMAL
2 DATADG_0003 DATADG_0003 /dev/rhdisk13 204800 110841 204800 NORMAL
2 DATADG_0004 DATADG_0004 /dev/rhdisk14 204800 110857 204800 NORMAL
2 DATADG_0005 DATADG_0005 /dev/rhdisk15 204800 110863 204800 NORMAL
2 DATADG_0006 DATADG_0006 /dev/rhdisk16 204800 110853 204800 NORMAL
2 DATADG_0007 DATADG_0007 /dev/rhdisk17 204800 110858 204800 NORMAL
2 DATADG_0008 DATADG_0008 /dev/rhdisk18 204800 110857 204800 NORMAL
2 DATADG_0009 DATADG_0009 /dev/rhdisk19 204800 110850 204800 NORMAL
2 DATADG_0010 DATADG_0010 /dev/rhdisk20 204800 110863 204800 NORMAL

GROUP_NUMBER NAME FAILGROUP PATH OS_MB FREE_MB TOTAL_MB STATE
------------ --------------- --------------- --------------- ---------- ---------- ---------- ------------------------
2 DATADG_0011 DATADG_0011 /dev/rhdisk21 204800 110860 204800 NORMAL
2 DATADG_0012 DATADG_0012 /dev/rhdisk22 204800 110864 204800 NORMAL
2 DATADG_0013 DATADG_0013 /dev/rhdisk23 204800 110858 204800 NORMAL
2 DATADG_0002 DATADG_0002 /dev/rhdisk12 204800 110849 204800 NORMAL
2 DATADG_0014 DATADG_0014 /dev/rhdisk9 204800 110857 204800 NORMAL
2 DATADG_0000 DATADG_0000 /dev/rhdisk10 204800 110858 204800 NORMAL
2 DATADG_0001 DATADG_0001 /dev/rhdisk11 204800 110856 204800 NORMAL

二：透過asmcmd命令檢視磁碟資訊：

[grid@dbserver1:/home/grid]$asmcmd
與unix命令很像
ASMCMD> l
commands:
--------

md_backup, md_restore

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

ASMCMD> ls
CRS/
DATADG/
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 15360 14960 0 14960 0 N CRS/
MOUNTED EXTERN N 512 4096 1048576 3072000 1662844 0 1662844 0 N DATADG/
ASMCMD> cd datadg
ASMCMD> ls
DB_UNKNOWN/
ORCLFI/
ORCLQT/
RMAN/
TEST/
ASMCMD> ASMCMD> cd orclfi
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y ARCHIVELOG/
Y CONTROLFILE/
Y DATAFILE/
Y ONLINELOG/
Y TEMPFILE/
N spfileorclfi.ora => +DATADG/DB_UNKNOWN/PARAMETERFILE/SPFILE.295.757283423
ASMCMD> cd datafile
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y APPPREDATA.275.766762363
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y APPPREDATA.756.766761795
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1043.751707999
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.1045.766399299
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1085.751707775
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1119.751711581
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1131.751708671
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1156.751709343
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1164.751712029
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1216.751711805
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1217.751711357
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.1248.766399625
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.328.751712253
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.354.751709565
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.363.751710011
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.400.751710235
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.425.751711131
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.470.751708447
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.524.751710907
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.542.751708223
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.632.766398931
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.658.751708895
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.701.751710459
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.750.751709789
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.835.751707387
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.859.751710685
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.900.766398565
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.902.751709119
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXEMATEVIEW.1204.753533061
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y SYSAUX.280.743846019
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y SYSTEM.279.743846019
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y UNDOTBS1.281.743846019
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y UNDOTBS2.290.743846287
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y USERS.282.743846019

ASMCMD> du
Used_MB Mirror_used_MB
965984 965984

[@more@]