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 …

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 …

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 …

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 …