How to Verify the Configuration of Storage Resources for Oracle Database Files

Language:

Perform this task only if your configuration of storage management schemes requires storage resources for Oracle Database files.

Assume the root role on a cluster node.

Verify that all resource groups that contain storage resources for Oracle Database files are correctly configured.
```
# clresourcegroup show rac-storage-rg-list
```
rac-storage-rg-list

Specifies a comma-separated list of resource groups that contain storage resources for Oracle Database files.

Take offline the resource group that contains the resources on which the Oracle RAC database resource depends.
```
# clresourcegroup offline rac-storage-rg
```
rac-storage-rg
Specifies the name of the resource group that contains the resources on which the RAC database resource depends. The resource group to take offline depends on your choice of storage management schemes for Oracle Database files.
- If you are using a shared file system for Oracle Database files, take offline the resource group that contains scalable file-system mount-point resources.
- If you are using a volume manager without a file system for Oracle Database files, take offline the resource group that contains scalable device-group resources.
This step might require several minutes to complete.

Verify that the resource groups for Support for Oracle RAC behave as follows:
- The status of the resource group that you took offline in Step 3 is offline.
- The status of the Support for Oracle RAC database resource group is offline.
- The status of the Support for Oracle RAC framework resource group is pending online blocked.
```
# clresourcegroup status
```
Verify that the Oracle Grid Infrastructure resources are offline.
To verify that the Oracle Grid Infrastructure resources are offline, consult the system messages file to find messages to indicate that Oracle Grid Infrastructure resources are being shut down.
Bring online the resource group that you took offline in Step 3.
```
# clresourcegroup online -eM rac-storage-rg
```
rac-storage-rg

Specifies the name of the resource group that you took offline in Step 3.

This step might require several minutes to complete.
On each node, restart the Oracle Grid Infrastructure.
```
# Grid_home/bin/crsctl start crs
Startup will be queued to init within 30 seconds.
```
Grid_home

Specifies the Oracle Grid Infrastructure home directory. This directory contains the Oracle Grid Infrastructure binary files and Oracle Grid Infrastructure configuration files.

This step might require several minutes to complete.
On each node, verify that the Oracle Grid Infrastructure resources are online.
Use the Oracle command crstat for this purpose.
```
# Grid_home/bin/crsctl stat res -t
```
Note - The startup of Oracle Grid Infrastructure on all nodes might require several minutes to complete. If you perform this step before the Oracle Grid Infrastructure resources are online on all nodes, the status on some nodes might be offline. In this situation, repeat this step until the status of the Oracle Grid Infrastructure is online on all nodes.

Verify that all resource groups for Support for Oracle RAC are online.
```
# clresourcegroup status
```
Note - Bringing online the resource group that contains the resources on which the Oracle RAC database resource depends also brings online the Oracle RAC database resource group. If you perform this step before the Oracle RAC database resource group is online on all nodes, the status on some nodes might be online faulted. In this situation, repeat this step until the status of the Oracle RAC database resource group is online on all nodes.