Oracle Administration ASM

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 …

Monitoring ASM Operations in Oracle Database, Using thev$asm_operationView SQL 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 code …

Removing a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL 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 environment. …

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 primary purpose of …

Creating 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 diskgroup data3 …

Querying 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 Management (ASM) disks within the database. …

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 …

Checking 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 …