Common commands for viewing ASM disk Information

Common commands for viewing ASM disk Information

1.1 obtain disk Group Management Information
1.1.1 view the disk path
SQL> selectname, path, group_number from v $ asm_disk_stat;

1.1.2 view disk group information
SQL> selectstate, name, type, total_mb, free_mb from v $ asm_diskgroup_stat;

The status of the disk group is Mounted, indicating that the status of the disk group is normal;

If total_mb and free_mb are not 0, the disk information can be read to obtain the disk size.

1.1.3 view disk groups
Select * fromv $ asm_operation

Opera statpower actual sofar EST_WORK EST_RATE EST_MINUTES

----------------------------------------------------------------------

1 REBAL WAIT11 0 0 0 0 0

1 dscv wait 110 0 0 0 0

(Timepasses ..............)

Opera statpower actual sofar EST_WORK EST_RATE EST_MINUTES

-----------------------------------------------------------------------

1 REBAL REAP11 2 25 219 485 0

1.1.4 view disk group attributes
View disk group attributes in view V $ ASM_ATTRIBUTE

SQL> SELECT dg. name AS diskgroup, SUBSTR (a. name, 1, 18) AS name,

SUBSTR (a. value, 1, 24) AS value, read_only from v $ ASM_DISKGROUP_STAT dg,

V $ ASM_ATTRIBUTE a WHERE dg. name = 'data'

AND dg. group_number = a. group_number;

1.1.5 view the compatibility attributes of a disk group
SQL> SELECT name, COMPATIBILITY, DATABASE_COMPATIBILITY FROM V $ ASM_DISKGROUP_STAT;

1.1.6 view disk status
SQL> SELECT SUBSTR (d. name, 1, 16) AS asmdisk, d. mount_status, HEADER_STATUS, d. state,

Dg. name AS diskgroup from v $ ASM_DISKGROUP_STAT dg, V $ ASM_DISK_STAT d

WHERE dg. group_number = d. group_number;

 

1.1.7 view disk client information
SQL> SELECT dg. name AS diskgroup, SUBSTR (c. instance_name, 1, 12) AS instance,

SUBSTR (c. db_name,) AS dbname, SUBSTR (c. SOFTWARE_VERSION,) AS software,

SUBSTR (c. COMPATIBLE_VERSION, 1, 12) AS compatible

From v $ ASM_DISKGROUP_STAT dg, V $ ASM_CLIENT c

WHERE dg. group_number = c. group_number;

1.1.8 view disk access control user information
SQL> SELECT dg. name AS diskgroup, u. group_number, u. user_number, u. OS _id, u. OS _name

From v $ ASM_DISKGROUP_STAT dg, V $ ASM_USER u

WHERE dg. group_number = u. group_number AND dg. name = 'data ';

1.1.9 view disk access control group information
SQL> SELECT dg. name AS diskgroup, ug. group_number, ug. owner_number, u. OS _name,

Ug. usergroup_number, ug. name from v $ ASM_DISKGROUP_STAT dg, V $ ASM_USER u, V $ ASM_USERGROUP ug

WHERE dg. group_number = ug. group_number AND dg. name = 'data'

AND ug. owner_number = u. user_number;

1.1.10 view Smart Data Distribution
SQL> SELECT dg. name AS diskgroup, f. file_number, f. primary_region, f. pai_region, f. hot_reads, f. hot_writes, f. cold_reads, f. cold_writes

From v $ ASM_DISKGROUP_STAT dg, V $ ASM_FILE f

WHERE dg. group_number = f. group_number and dg. name = 'data ';

How to change the password of ASM sys

How to copy data files in ASM to the Operating System

Restoration After all Oracle 11g rac asm disks are lost

Oracle 11g from entry to proficient in PDF + CD source code

Installing Oracle 11g R2 using RHEL6 ASM

Oracle 10g manual creation of the ASM Database

Solutions to various problems after installing Oracle 11gR2 in Ubuntu 12.04 (amd64)

How to change the sys password of Oracle 10g ASM