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 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 …
Read MoreRemoving a Disk Group Permanently in Oracle Database, The drop diskgroup
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. …
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 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: The primary purpose of …
Read More