關於oracle 11g ASM使用時要注意的點,11gasm
1. 配置最少2個data group (datagroup 存放資料檔案; fra datagroup 作為閃回區方歸檔 ,備份等)主要考慮的是io 效能問題
2. oracle 官方文檔建議每個dg 最少4塊盤且大小,效能一樣。否者io 將會受限於速度最慢的那個盤
3. 硬體raid 條帶大小取2的冪,且要<= asm au size
4.支援儲存:
Disk Partition
A disk partition can be the entire disk drive or a section of a disk drive. 注意使用磁碟分割不能後分區表,因為分區表會被覆蓋。
Logical Unit Number (LUN):
A LUN is a disk presented to a computer system by a storage array. oracle建議使用硬raid
Logical Volume:
A logical volume is supported in less complicated configurations where a logical volume is mapped to a LUN, or a logical volume uses disks or raw partitions。oracle 不太建議使用邏輯卷,因為他們和oracle asm 有功能( mirroring)上的重複
Network File System (NFS):
An Oracle ASM disk group can be created from NFS files, including Oracle Direct NFS (dNFS), as well as whole disks, partitions, and LUNs.
Direct NFS can be used to store data files, but is not supported for Oracle Clusterware files.