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: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: To initiate a …
Read MoreMonitoring ASM Operations in Oracle Database, Using the
v$asm_operationViewJan 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 View 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/ Sample Oracle Output: 1 2no rows selected …
Read MoreRemoving a Disk Group Permanently in Oracle Database, The
drop diskgroupCommandRemoving a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup '<name>' 2/ Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: The primary purpose of this SQL code is to permanently remove an entire disk group, …
Read MoreExpanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1
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: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: The …
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: 1 2no rows selected 3SQL> Purpose: Retrieves and displays key information about Automatic Storage Management (ASM) disks within the …
Read More