10 Managing Storage
Understand the storage options and how to manage storage for your Oracle Database Appliance deployment.
- About Managing Storage
Understand Oracle Database Appliance storage options. - About Managing Oracle ASM Disks
Understand the Oracle ASM disk management features that Oracle Database Appliance supports. - Managing Storage on Single-Node Systems
Understand the storage options for your Oracle Database Appliance X9-2S and X9-2L systems. - Managing Storage on High-Availability Systems
Understand the storage for your Oracle Database Appliance X9-2-HA system.
About Managing Storage
Understand Oracle Database Appliance storage options.
Oracle Database Appliance uses raw storage to protect data in the following ways:
-
Fast Recovery Area (FRA) backup. FRA is a storage area (directory on disk or Oracle ASM diskgroup) that contains redo logs, control file, archived logs, backup pieces and copies, and flashback logs.
-
Mirroring. Double or triple mirroring provides protection against mechanical issues.
The amount of available storage is determined by the location of the FRA backup (external or internal) and if double or triple mirroring is used. External NFS storage is supported for online backups, data staging, or additional database files.
Oracle Database Appliance X9-2L and X9-2-HA models provide storage expansion options from the base configuration. In addition, on Oracle Database Appliance X9-2-HA multi-node platforms, you can add an optional storage expansion shelf.
The redundancy level for FLASH is based on the DATA and RECO selection. If you choose High redundancy (triple mirroring), then FLASH is also High redundancy.
Parent topic: Managing Storage
About Managing Oracle ASM Disks
Understand the Oracle ASM disk management features that Oracle Database Appliance supports.
Oracle Database Appliance enables you to manage your Oracle ASM disks.
Bringing Oracle ASM Disk Groups Online Automatically
Oracle Database Appliance periodically checks the status of Oracle ASM disks in disk groups. If any Oracle ASM disk is OFFLINE due to transient disk errors, then Oracle Database Appliance attempts to bring the disk ONLINE.
Optimizing Oracle ASM Disk Group Rebalance Operations
odacli modify-agentconfig-parameters -n ASMRM_CPU_RQ -v 50 -d "CPU RUN QUEUE THRESHOLD" -u
odacli modify-agentconfig-parameters -n ASMRM_MAX_HDD_DISK_RQ -v 2 -d "HDD DISK QUEUE THRESHOLD" -u
odacli modify-agentconfig-parameters -n ASMRM_MAX_SSD_DISK_RQ -v 32 -d "SSD DISK QUEUE THRESHOLD" -u
odacli modify-agentconfig-parameters -n ASMRM_MAX_NVME_DISK_RQ -v 50 -d "NVME DISK QUEUE THRESHOLD" -u
The above command options set custom threshold limits for rebalance monitoring of Oracle ASM disks.
You can monitor rebalance operations using the odacli describe-schedule -i
Schedule ID
and odacli
list-scheduled-executions
commands.
Parent topic: Managing Storage
Managing Storage on Single-Node Systems
Understand the storage options for your Oracle Database Appliance X9-2S and X9-2L systems.
- About Storage on Oracle Database Appliance X9-2S and X9-2L
Understand the storage for your Oracle Database Appliance single-node system. - Adding NVMe Storage Disks
Depending on the available drives, you can expand Oracle Database Appliance X9-2 storage to add NVMe disks or replace existing NVMe disks. - Replacing NVMe Storage Disks
Understand how you can replace existing NVMe disks on Oracle Database Appliance.
Parent topic: Managing Storage
About Storage on Oracle Database Appliance X9-2S and X9-2L
Understand the storage for your Oracle Database Appliance single-node system.
Oracle Database Appliance X9-2S has two 6.8TB NVMe disks that host DATA and RECO disk groups. There are two partitions, one each for DATA and RECO for Oracle ASM storage information. The storage capacity is fixed and cannot be expanded.
Oracle Database Appliance X9-2L has two 6.8TB NVMe disks that host DATA and RECO disk groups. There are two partitions, one each for DATA and RECO for Oracle ASM storage information. When you first deploy and configure X9-2L in this release, you can set the storage on X9-2L in multiple of 2 packs of NVMe drives, such as 2, 4, 6, 8, and 10 disks, up to a maximum of 12 disks.
The table describes the NVMe storage configurations with expansion memory and storage options for single-node systems.
Table 10-1 Storage Options for Oracle Database Appliance X9-2S and X9-2L
Configuration | Oracle Database Appliance X9-2S | Oracle Database Appliance X9-2L |
---|---|---|
Base Configuration |
2 x 6.8 TB NVMe = 13.6 TB NVMe |
2 x 6.8 TB NVMe = 13.6 TB NVMe |
Storage addition options |
None |
10 x 6.8 TB NVMe storage drives for a total storage of 81.6 TB NVMe. Order Qty 1 - 7603394 (Two 6.8 TB 2.5-inch NVMe PCIe 4.0 SSD with coral-d bracket for Oracle Database Appliance X9-2L) Pack of two 6.8 TB NVMe disks to a maximum of 12 disks. |
Parent topic: Managing Storage on Single-Node Systems
Adding NVMe Storage Disks
Depending on the available drives, you can expand Oracle Database Appliance X9-2 storage to add NVMe disks or replace existing NVMe disks.
Use the ODAADMCLI commands to perform appliance storage maintenance tasks, including perform storage diagnostics and collect diagnostic logs for storage components.
Preparing for a Storage Upgrade
-
Check the disk health of the existing storage disks.
# odaadmcli show disk
-
Run the the
odaadmcli show disk
andasmcmd lsdsk -p
commands to view and review the storage disk information in OAKD and Oracle Automatic Storage Management (Oracle ASM).# odaadmcli show disk
# asmcmd lsdsk -p
-
Use ORAchk to confirm Oracle ASM and Oracle Clusterware health.
Adding NVMe Storage Disks
The default configuration for Oracle Database Appliance X9-2S or X9-2L includes two (2) NVMe disks. You cannot expand storage for Oracle Database Appliance X9-2S.
For Oracle Database Appliance X9-2L, you can expand storage by adding 2, 4, 6, 8, and 10 disks, up to a maximum of 12 disks. When you expand storage, adding odd numbers of NVMe drives is not supported.
WARNING:
Pulling a drive before powering it off will crash the kernel, which can lead to data corruption. Do not pull the drive when the LED is an amber or green color. When you need to replace an NVMe drive, use the software to power off the drive before pulling the drive from the slot. If you have more than one disk to replace, complete the replacement of one disk before starting replacement of the next disk.
Follow all these steps to add NVMe storage disks:
- Before adding the NVMe disks, ensure that the
current disks are online in
oakd
and Oracle ASM. Otherwise, the prechecks fail. For example, for 2-disks expansion to slots 2 and 3, the disks in slots 0 and 1 must be online in Oracle ASM andoakd
. For 4-disks expansion from slots 2 to 5 when slots 0 to 5 are filled, then all disks in slots 0 to 1 must be online. For 10-disks expansion from slots 2 to 11, all disks in slots 0 to 1 must be online. - Insert each disk one at a time in the appropriate slot and wait for the disk to power ON.
- The disk automatically powers on when you insert the disk in the
slot. Wait for one minute and then check disk status. If
the disk is in the ON state, then you need not power
on the disk manually. If the disk state is OFF
as per the disk status, and then power on the disk manually,
and then check the status
again.
# odaadmcli power disk status slot_number
# odaadmcli power disk on slot_number
For example, to add two (2) NVMe disks, insert the disks in slots 2 and 3.# odaadmcli power disk status pd_02 # odaadmcli power disk on pd_02 # odaadmcli power disk status pd_03 # odaadmcli power disk on pd_03
- Repeat steps 2 and 3 for each disk to be added.
- Run the
odaadmcli expand storage
command to add the new storage disks. Note: You must run this step to add the storage disk. Otherwise, the newly-added disk is not visible to OAKD and hence does not display when you run theodaadmcli show disk
orodaadmcli show storage
commands. The newly-added disk is recognized by OAKD after theodaadmcli expand storage
command completes running successfully.# odaadmcli expand storage -ndisk number_of_disks
For example, to add two (2) NVMe drives:#odaadmcli expand storage -ndisk 2 Running precheck, it may take a few minutes. Precheck passed. Check the progress of expansion of storage by executing 'odaadmcli show disk' Waiting for expansion to finish. It may take several minutes to complete depending upon the number of disks being expanded
- Check the status of the new disk in OAKD with the
odaadmcli show disk
command. The disk must have the statusOnline
andGood
in OAKD. Check the status of the new disk in Oracle ASM with theasmcmd lsdsk -p
command. The disk must be inCACHED MEMBER ONLINE NORMAL
state.# odaadmcli show disk
# asmcmd lsdsk -p
Parent topic: Managing Storage on Single-Node Systems
Replacing NVMe Storage Disks
Understand how you can replace existing NVMe disks on Oracle Database Appliance.
Preparing for a Storage Upgrade
-
Update Oracle Database Appliance to the latest Patch Bundle before expanding storage.
# odacli describe-component
-
Check the disk health of the existing storage disks.
# odaadmcli show disk
-
Run the the
odaadmcli show disk
andasmcmd lsdsk -p
commands to view and review the storage disk information in OAKD and Oracle Automatic Storage Management (Oracle ASM).# odaadmcli show disk
# asmcmd lsdsk -p
-
Use ORAchk to confirm Oracle ASM and Oracle Clusterware health.
Replacing NVMe Storage Disks
Follow all these steps to replace NVMe storage disks:
WARNING:
Pulling a drive before powering it off will crash the kernel, which can lead to data corruption. Do not pull the drive when the LED is an amber or green color. When you need to replace an NVMe drive, use the software to power off the drive before pulling the drive from the slot. If you have more than one disk to replace, complete the replacement of one disk before starting replacement of the next disk.
- Power OFF the NVMe disk before removing it from the slot.
- Wait for one minute for OAKD to complete the operation for disk removal.
- Insert the new disk in the slot.
- Wait for at least 2-3 minutes between inserting each disk for OAKD to complete the operation to add the disk to Oracle ASM and OAK.
- Check the status of the new disk in OAKD with the
odaadmcli show disk
command. The disk must have the statusOnline
andGood
in OAKD. Check the status of the new disk in Oracle ASM with theasmcmd lsdsk -p
command. The disk must be inCACHED MEMBER ONLINE NORMAL
state.# odaadmcli show disk
# asmcmd lsdsk -p
Parent topic: Managing Storage on Single-Node Systems
Managing Storage on High-Availability Systems
Understand the storage for your Oracle Database Appliance X9-2-HA system.
- About Storage Options for Oracle Database Appliance X9-2-HA
Oracle Database Appliance High-Availability systems have options for high performance and high capacity storage configurations. - Adding Solid-State Drives (SSDs) for Data Storage
Add a pack of solid-state drives (SSDs) for data storage into the existing Oracle Database Appliance X9-2-HA base configuration to fully populate the base storage shelf. - Adding the Storage Expansion Shelf
After the base storage shelf is fully populated, you can add the storage expansion shelf to expand your data storage on your multi-node platform.
Parent topic: Managing Storage
About Storage Options for Oracle Database Appliance X9-2-HA
Oracle Database Appliance High-Availability systems have options for high performance and high capacity storage configurations.
The base configuration of Oracle Database Appliance X9-2-HA hardware model has six slots (slots 0-5) with 7.68 TB drives of SSD raw storage. If you choose to order and deploy the full storage capacity, then you can fill the remaining 18 slots (slots 6-23) with either SSD or HDD drives. For even more storage, you can add a storage expansion shelf to double the storage capacity of your appliance.
In all configurations, the base storage and the storage expansion shelf each have six SSDs for DATA/RECO in the SSD option or FLASH in the HDD option.
Oracle Database Appliance X9-2-HA does not allocate dedicated SSD drives for REDO disk groups. Instead, the space for REDO logs is allocated on SSD drives as required.
For Oracle ASM storage, the REDO logs are stored in the available disk group space during database creation, based on the database shape selected. For Oracle ACFS storage, the space for REDO logs is allocated during the database storage creation assuming the minimum db shape (odb1s). If you create the database storage without database, then the space allocated for REDO logs is 4 GB, assuming the minimum db shape (odb1s). Subsequently, when you create a database with your required database shape on the existing database storage, the REDO logs space is extended based on shape of the database.
On Oracle Database Appliance X9-2-HA High Performance configurations, with only SSD drives, the DATA and RECO disk groups use all the SSD drives whether 6, 12, 18, 24, or 48 with storage expansion shelf. REDO logs are stored in the RECO disk group.
On Oracle Database Appliance X9-2-HA High Capacity configurations, with both HDD and SSD drives, the DATA and RECO disk groups use the HDD drives, and the SSD drives store the FLASH disk group. REDO logs are stored in the FLASH disk group.
On both High Performance and High Capacity configurations, REDO logs are always created on SSD drives, similar to earlier Oracle Database Appliance hardware models. REDO logs are always created with high redundancy irrespective of the redundancy level of the disk group, whether RECO or FLASH.
High Performance
A high performance configuration uses solid state drives (SSDs) for DATA and RECO storage. The base configuration has six disks, each with 7.68 TB SSD raw storage for DATA and RECO.
You can add up to three (3) 6-Pack SSDs on the base configuration, for a total of 184.32 TB SSD raw storage. If you need more storage, you can double the capacity by adding an expansion shelf of SSD drives. The expansion shelf provides an additional 24 SSDs, each with 7.68TB raw storage for DATA and RECO, for a total of another 184.32 TB SSD raw storage.
Adding an expansion shelf requires that the base storage shelf and expansion shelf are fully populated with SSD drives. When you expand the storage, there is no downtime.
A system fully configured for high performance has 368.64 TB SSD raw storage for DATA and RECO.
High Capacity
A high capacity configuration uses a combination of SSD and HDD drives.
The base configuration has six disks, each with 7.68 TB SSD raw storage for FLASH.
The following expansion options are available:
-
Base shelf: additional 324 TB HDD raw storage for DATA and RECO (18 HDDs, each with 18 TB storage)
-
Expansion Storage shelf: additional shelf storage configuration must be identical to the storage configuration of the base shelf.
A system fully configured for high capacity has a total of 740.16 TB raw storage for DATA, RECO, and FLASH, with 92.16 TB SSD and 648 TB HDD.
Table 10-2 Storage Options for Oracle Database Appliance X9-2-HA
Configuration | Oracle Database Appliance X9-2-HA SSD-Only Configuration for High Performance | Oracle Database Appliance X9-2-HA SSD and HDD Configuration for High Capacity |
---|---|---|
Base configuration |
Base storage shelf contains 6 SSDs of 7.68 TB.
|
Base storage shelf is fully populated with 6-pack SSDs of 7.68 TB and 18-drives of HDDs with 18 TB.
|
Storage addition options |
Base shelf contains 6 SSDs. Additional 18 SSDs must be added in packs of 6.
|
Not applicable. Base storage shelf is fully populated. |
Storage shelf expansion options |
|
|
Parent topic: Managing Storage on High-Availability Systems
Adding Solid-State Drives (SSDs) for Data Storage
Add a pack of solid-state drives (SSDs) for data storage into the existing Oracle Database Appliance X9-2-HA base configuration to fully populate the base storage shelf.
If you need to add storage to the base configuration, you can order one, two, or three 6-pack of SSDs to complete the base configuration on Oracle Database Appliance X9-2-HA.
You must fully populate the base configuration before you can add an expansion shelf to Oracle Database Appliance X9-2-HA. If you add an expansion shelf, the shelf must have the same disk storage configuration as the base configuration.
Note:
For a high-performance configuration, you can add SSDs to the base storage shelf or add a storage expansion shelf. For high-capacity base configuration with 6-SSDs, if you want to expand storage to use HDDs, then you must reimage and deploy the appliance.Parent topic: Managing Storage on High-Availability Systems
Adding the Storage Expansion Shelf
After the base storage shelf is fully populated, you can add the storage expansion shelf to expand your data storage on your multi-node platform.
The expansion shelf is available on Oracle Database Appliance multi-node platforms, such as Oracle Database Appliance X9-2-HA. The addition of the storage expansion shelf includes checks across both nodes. It is important to confirm that SSH does work across the nodes and all users can connect as expected using their shared password.
You must fully populate the base configuration before you can add an expansion shelf. If you add an expansion shelf, the shelf must have the same disk storage configuration as the base storage shelf.
Note:
Oracle recommends that you add a storage expansion shelf when you have relatively little activity on your databases. When the system discovers the new storage, Oracle Automatic Storage Management (Oracle ASM) automatically rebalances the disk groups. The rebalance operation may degrade database performance until the operation completes.Parent topic: Managing Storage on High-Availability Systems