一、ASM磁碟和磁碟組管理

1、建立磁碟組

create diskgroup DG2 EXTERNAL REDUNDANCY DISK ‘ORCL:A1′;

Note:1)磁碟名稱需要大寫

2)磁碟名稱使用V$asm_disk.path

2、磁碟組中新增磁碟

alter diskgroup dg2 add disk ‘ORCL:A2′;

Note:磁碟名稱使用V$asm_disk.path

3、磁碟組中刪除磁碟

alter diskgroup dg2 drop disk ‘a1′;

Note:磁碟名稱使用的是V$asm_disk.name

4、刪除磁碟組

drop diskgroup dg2 including contents;

二、ASM相關檢視

1、檢視是否有資料庫例項連線上ASM例項

select instance_name,db_name,status from v$asm_client;

2、記錄BALANCE操作

select operation,state,power,actual,sofar from v$asm_operation;

3、ASM DISK資訊

select path, state, total_mb, free_mb from v$asm_disk;

4、ASM DISKGROUP資訊

select name,state,type,total_mb,free_mb from v$asm_diskgroup;

三、ASM和表空間管理

1、ASM中建立表空間

create tablespace xff datafile ‘+DG2′ SIZE 100M;

2、ASM表空間中新增資料檔案

alter tablespace xff add datafile ‘+dg2′ size 10m;

3、ASM表空間中刪除資料檔案

alter tablespace xff drop datafile ‘+DG2/xff/datafile/xff.257.747278679′;

或者

alter tablespace xff drop datafile 7;

4、刪除表空間

drop tablespace xff including contents;

ASM簡單管理(2)

oracle之datafile，tablespace

undo異常處理步驟（10g）

undo損壞恢復–無事務

asm備份後設資料之md_backup和md_restore

資料檔案重新命名

undo損壞恢復–有事務

ORACLE線上切換undo表空間

-------------------------------

1、磁碟組解除安裝/掛載

--檢視當前磁碟組狀態

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

1 ARCHIVELOG MOUNTED 12637 12585

2 DATA MOUNTED 10228 7644

3 FLASHBACK MOUNTED 7836 7786

4 DG2 MOUNTED 5114 5012

--解除安裝dg2磁碟組

SQL> alter diskgroup dg2 dismount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

1 ARCHIVELOG MOUNTED 12637 12585

2 DATA MOUNTED 10228 7644

3 FLASHBACK MOUNTED 7836 7786

0 DG2 DISMOUNTED 0 0

--掛載dg2磁碟組

SQL> alter diskgroup dg2 mount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

1 ARCHIVELOG MOUNTED 12637 12585

2 DATA MOUNTED 10228 7644

3 FLASHBACK MOUNTED 7836 7786

4 DG2 MOUNTED 5114 5012

--解除安裝所有磁碟組

SQL> alter diskgroup all dismount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

0 DATA DISMOUNTED 0 0

0 DG2 DISMOUNTED 0 0

0 FLASHBACK DISMOUNTED 0 0

0 ARCHIVELOG DISMOUNTED 0 0

--掛載所有磁碟組

SQL> alter diskgroup all mount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

2 DATA MOUNTED 10228 7644

3 DG2 MOUNTED 5114 5012

4 FLASHBACK MOUNTED 7836 7786

1 ARCHIVELOG MOUNTED 12637 12585

--如果當前磁碟組有例項在訪問，則不能被解除安裝

SQL> alter diskgroup data dismount;

alter diskgroup data dismount

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15027: active use of diskgroup "DATA" precludes its dismount

2、磁碟組目錄

--建立目錄

SQL> alter diskgroup dg2 add directory '+DG2/CHENGFEI';

Diskgroup altered.

--使用asmcmd檢視（export ORACLE_SID=+ASM;asmcmd進入)

ASMCMD> pwd

+DG2

ASMCMD> ls -l

Type Redund Striped Time Sys Name

N CHENGFEI/

--目錄重新命名

SQL> alter diskgroup dg2 rename directory '+DG2/CHENGFEI' TO '+DG2/XIFENFEI';

Diskgroup altered.

ASMCMD> ls

XIFENFEI/

--刪除目錄

SQL> alter diskgroup dg2 drop directory '+DG2/xifenfei';

Diskgroup altered.

ASMCMD> ls

ASMCMD>

3、檔案別名

--新增別名

SQL> alter diskgroup dg2 add alias '+dg2/XIFENFEI' for '+dg2/tasm/datafile/XFF.256.754832383';

Diskgroup altered.

--使用asmcmd檢視別名是否成功

ASMCMD> pwd

+dg2

ASMCMD> ls -l

Type Redund Striped Time Sys Name

Y TASM/

N XIFENFEI => +DG2/TASM/DATAFILE/XFF.256.754832383

--別名重新命名

SQL> alter diskgroup dg2 rename alias '+DG2/XIFENFEI' TO '+DG2/FEIFEI.DBF';

Diskgroup altered.

N XIFENFEI => +DG2/TASM/DATAFILE/XFF.256.754832383

ASMCMD> ls -l

Type Redund Striped Time Sys Name

N FEIFEI.DBF => +DG2/TASM/DATAFILE/XFF.256.754832383

Y TASM/

--刪除別名

SQL> alter diskgroup dg2 drop alias '+dg2/feifei.dbf';

Diskgroup altered.

ASMCMD> ls -l

Type Redund Striped Time Sys Name

Y TASM/

說明：

1）asmcmd命令列操作中，目錄檔名不區分大小寫，命令關鍵字區分大小寫

2）磁碟組中的一個檔案，最多隻能建立一個別名可以透過v$asm_alias檢視檢視別名的相關資訊

ASM簡單管理

相關文章