ASM Storage/Disk Group
- A Disk Group in ASM which is visible to the RDBMS as a file beginning with ”+DB_DATA01″;
- When tablespaces are created, they refer to a Data Group for storage such as “+Db_DATA01/…/…”
- Diskgroup are made one or more failure groups
- “Disks” can be based on raw physical volumes, a disk partition, a LUN presenting a disk array, or even an LVM or NAS device.
- Failover Groups should have disks defined that have a common failure component, otherwise ASM redundancy will not be effective
Q. If you have 3 TB size storage and you will create a ASM disk group there with High Redundancy, then how big database you can keep in that disk group?
A. Yes, with normal redundancy Oracle copy all data into 2 places. With high redundancy all data are placed in 3 places in total, so if you want to use your all 3TB storage you can use only 1TB, because 2TB will be reserved for redundancy. But I don’t think put all your data into 1 disk group is good idea. Better think about creating several disk groups with normal and high redundancy depends on files that you will be store on it.
Responses