Home > Workload Solutions > Oracle > White Papers > Oracle RAC High Availability on PowerStore T > PowerStore T storage configuration for Oracle
The PowerStore T Manager is a web-based interface that allows you to create, monitor, and delete Logical Unit Numbers (LUNs) that provide host-accessible allocations of physical storage. For the Oracle RAC production databases, we created 15 LUNs to support two Oracle RAC nodes. The exact mapping of LUNs to Volume Groups and hosts is shown in Tables 4 and 5 below.
|
Oracle RAC node 1 |
Oracle RAC node 2 |
||||
Volume group |
Name |
Description |
Size (GB) |
Name |
Description |
Size |
VM_OCR |
PROD_VM1 |
Guest VM operating system |
250 |
PROD_VM2 |
Guest VM operating system |
250 |
|
Oracle RAC node 1 and 2 |
|
|
||
Volume group |
Name |
Description |
Size (GB) |
Number of volumes |
Total size (GB) |
VM_OCR |
PROD_OCR(1-3) |
Oracle Cluster registry and voting files |
50 |
3 |
150 |
ORA_DATA |
PROD_DATA(1-4) |
Data files |
600 |
4 |
2,400 |
PROD_REDO(1-4) |
Redo logs |
25 |
4 |
100 |
|
PROD_FRA |
Fast Recovery Area |
100 |
1 |
100 |
|
ORA_TEMP |
PROD_TEMP |
Temporary tablespace |
500 |
1 |
500 |
All volume groups are distributed across four or more physical NVMe drives. This distribution meets the Oracle recommendation that each disk group have a minimum of four drives. All disk groups are configured with ASM external redundancy except for the PROD_OCR group, which uses ASM triple mirroring. The volume groups and storage volumes are described as follows:
ASM enables DBAs to manage database files and volumes using database commands and tools, thereby simplifying management. We used ASM to manage the database files in the following storage volumes:
Drive selection is one part of the performance equation. Equally crucial is the number of drives and channels serving the data. The general rule is to maximize the number of drives and channels to optimize I/O bandwidth. The greater the number of drives and channels serving the database I/O, the better the bandwidth and performance.
PowerStore T arrays automatically stripe data at the storage level. Oracle ASM provides redundancy through two- or three-way mirroring of database files. In our lab tests, we used ASM external redundancy with all disk groups except the PROD_OCR, which we created using the normal redundancy. ASM external redundancy relies on the RAID data protection from the PowerStore T appliance. All disk groups were configured with an allocation unit (AU) size of 1 MB.