您好,登錄后才能下訂單哦!
在SQLPLUS中對ASM實例進行操作
1、查看ASM磁盤組狀況
SELECT GROUP_NUMBER, NAME, TYPE, STATE, TOTAL_MB, FREE_MB, OFFLINE_DISKS FROM V$ASM_DISKGROUP;
GROUP_NUMBER NAME TYPE STATE TOTAL_MB FREE_MB OFFLINE_DISKS
------------ ---------- ------ ----------- ---------- ---------- -------------
1 DG1 NORMAL MOUNTED 102365 102208
2、查看ASM磁盤信息
SELECT GROUP_NUMBER, DISK_NUMBER, LABEL, STATE, FAILGROUP, NAME, PATH, TOTAL_MB, FREE_MB FROM V$ASM_DISK;
GROUP_NUMBER DISK_NUMBER LABEL STATE FAILGROUP NAME
------------ ----------- ----- -------- ---------- ----------
PATH TOTAL_MB FREE_MB
------------------------- ---------- ----------
1 4 NORMAL DG1_0004 DG1_0004
/dev/oracleasm/disks/D5 20473 20443
1 3 NORMAL DG1_0003 DG1_0003
/dev/oracleasm/disks/D4 20473 20443
1 2 NORMAL DG1_0002 DG1_0002
/dev/oracleasm/disks/D3 20473 20442
GROUP_NUMBER DISK_NUMBER LABEL STATE FAILGROUP NAME
------------ ----------- ----- -------- ---------- ----------
PATH TOTAL_MB FREE_MB
------------------------- ---------- ----------
1 1 NORMAL DG1_0001 DG1_0001
/dev/oracleasm/disks/D2 20473 20439
1 0 NORMAL DG1_0000 DG1_0000
/dev/oracleasm/disks/D1 20473 20441
3、增加磁盤組:
CREATE DISKGROUP dgd NORMAL REDUNDANCY
FAILGROUP failgroup1 DISK
'/dev/raw/raw1' NAME diskA1 SIZE 120G FORCE,
'/dev/raw/raw2',
'/dev/raw/raw3'
FAILGROUP failgroup2 DISK
'/dev/raw/raw4',
'/dev/raw/raw5',
'/dev/raw/raw6';
4、增加fail組:
ALTER DISKGROUP dg1 ADD FAILGROUP fail3 DISK '/dev/raw/raw22' name disk5 REBALANCE POWER 11;
5、添加ASM磁盤:
ALTER DISKGROUP dg1 add failgroup fail1 DISK '/dev/raw/raw19' name disk3;
6、刪除ASM磁盤:
ALTER DISKGROUP dg1 DROP DISK disk4;
7、卸載磁盤組,要先關(guān)閉安裝在ASM上的rdbms數(shù)據(jù)庫實例
ALTER DISKGROUP dg2 DISMOUNT;
8、檢測磁盤組或磁盤:
ALTER DISKGROUP dg1 CHECK ALL;
ALTER DISKGROUP DG1 CHECK DISK VOL1;
7、控制均衡容錯組數(shù)據(jù)的速度:
ALTER DISKGROUP dg2 REBALANCE POWER 11;
平衡速度控制參數(shù):
asm_power_limit = 1~11
8、檢查數(shù)據(jù)庫平衡速度:
SELECT GROUP_NUMBER, OPERATION, STATE, EST_WORK, SOFAR, EST_RATE, EST_MINUTES FROM V$ASM_OPERATION;
9、刪除磁盤組:
DROP DISKGROUP GROUP1 INCLUDING CONTENTS;
10、取消刪除:
ALTER DISKGROUP group1 UNDROP DISKS;
11、添加目錄:
ALTER DISKGROUP DG1 ADD DIRECTORY '+DG1/ad';
CREATE TABLESPACE T1 DATAFILE '+DG1/ad/t1.dbf' SIZE 100M AUOEXTEND ON;
12、重命名目錄:表空間不受任何影響
ALTER DISKGROUP DG1 RENAME DIRECTORY '+DG1/ad' to '+DG1/add';
13、刪除目錄:
ALTER DISKGROUP DG1 DROP DIRECTORY '+DG1/ad/demo' FORCE;
14、創(chuàng)建別名:
ALTER DISKGROUP DG1 ADD ALIAS '+DG1/ad/spfilead.ora' FOR '+DG1/ad/parameterfile/spfile.269.777212438';
15、重命名別名:
alter diskgroup dg1 rename alias '+DG1/ASMDB/spfile.ora' to '+DG1/ASMDB/spfileasmdb.ora';
16、刪除別名:刪除別名文件不會被刪除
DROP DISKGROUP DG1 DROP ALIAS '+DG1/ASMDB/spfileasmdb.ora';
免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。