Checking All Disks in Diskgroup Data
This SQL code instructs Oracle to perform a thorough check of all disks within the diskgroup named data1.
Check the internal consistency of a diskgroup
SQL Code
1alter diskgroup data1 check all 2/
Sample Oracle Output:
1no rows selected 2SQL>
Description of the Oracle Database SQL code:
Purpose:
- To initiate a …
Read MoreMonitoring ASM Operations in Oracle Database, Using the v$asm_operation
Jan 14, 2024 · 2 min read · oracle asm oracle disk information storage management diskgroup v$asm_operation ·Monitoring ASM Operations in Oracle Database, Using the
v$asm_operation
ViewSQL Code
1select * 2from v$asm_operation 3/
Mount/dismount disk groups
1alter diskgroup all mount 2/
1alter diskgroup data1 mount 2/
1alter diskgroup all dismount 2/
1alter diskgroup data1 dismount 2/
Description of the Oracle Database SQL …
Read MoreRemoving a Disk Group Permanently in Oracle Database, The drop diskgroup
Removing a Disk Group Permanently in Oracle Database, The
drop diskgroup
CommandSQL Code
1drop diskgroup '<name>' 2/
Description of the Oracle Database SQL code:
Purpose:
- The primary purpose of this SQL code is to permanently remove an entire disk group, identified by its name, from the Oracle database …
Read MoreExpanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1
Jan 10, 2024 · 2 min read · Oracle ASM - Oracle - Disk Information - Storage Management - diskgroup ·Expanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1
SQL Code
Note: Wildcards can be used for raw device names (eg. raw*
1alter diskgroup data1 2add disk '/dev/raw/raw4' 3/
Sample Oracle Output:
1no rows selected 2SQL>
Description of the Oracle Database SQL code:
Purpose:
- The …
Read MoreCreating an ASM Disk Group with External Redundancy in Oracle
SQL Code
1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1' 4/
Or with multiple raw partitions
SQL Code
1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1' 4/
Or with multiple fail groups...
SQL Code
1create …
Read MoreQuerying ASM Disk Information in Oracle
SQL Code
1select name 2, group_number 3, disk_number 4, total_mb 5, free_mb 6from v$asm_disk 7order by group_number 8/
Sample Oracle Output:
1no rows selected 2SQL>
Purpose:
- Retrieves and displays key information about Automatic Storage …
Read MoreVisualizing Disk Groups in Oracle ASM with SQL
Jan 6, 2024 · 2 min read · disk space analysis oracle storage capacity monitoring asm disk utilization asm ·Visualizing Disk Groups in Oracle ASM with SQL
Note: A group number of zero his indicates that a disk is available but hasn't yet been assigned to a disk group.
SQL Code
1set lines 100 2col name format a10 3col path format a30 4select name 5, group_number 6, disk_number 7, mount_status 8, state 9, path 10from …
Read MoreChecking Cluster Health with crsctl check cssd
SQL Command
1crsctl check cssd
Purpose:
- To verify the status and health of the Cluster Synchronization Services (CSS) daemon (cssd), a crucial component of Oracle Clusterware.
- It's typically used in Oracle Real Application Clusters (RAC) and Oracle Automatic Storage …
Read More