Administering ASM

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE
SANADMIN                       FALSE FALSE TRUE


col instance_name format a23

select db_name, status, instance_name from v$asm_client
DB_NAME  STATUS       INSTANCE_NAME
-------- ------------ -----------------------
 +ASM     CONNECTED    +ASM2
 +ASM     CONNECTED    +ASM2
asmvol   CONNECTED    +ASM2


col volume_device format a32
col mountpath format a23
col usage format a9
set linesize 132

To check a ASM cluster file system (ACFS)

select volume_name, state, usage, volume_device, mountpath
from v$asm_volume


VOLUME_NAME                    STATE    USAGE     VOLUME_DEVICE                    MOUNTPATH
------------------------------ -------- --------- -------------------------------- -----------------------
DATALOGS                       ENABLED  ACFS      /dev/asm/datalogs-94             /data/oracle/logfiles


+ASM2 > acfsutil info fs
/data/oracle/logfiles
    ACFS Version: 11.2.0.1.0.0
    flags:        MountPoint,Available
    mount time:   Mon Feb 21 12:37:06 2011
    volumes:      1
    total size:   10737418240
    total free:   10581868544
    primary volume: /dev/asm/datalogs-94
        label:                
        flags:                 Primary,Available,ADVM
        on-disk version:       39.0
        allocation unit:       4096
        major, minor:          252, 48129
        size:                  10737418240
        free:                  10581868544
        ADVM diskgroup         DG_DBA_DF501
        ADVM resize increment: 268435456
        ADVM redundancy:       unprotected
        ADVM stripe columns:   4
        ADVM stripe width:     131072
    number of snapshots:  0
    snapshot space usage: 0
   
   
   

SQL> select name, state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
GRID_OCRVOTE                   MOUNTED
OCR_VOTE                       MOUNTED
DG_DBA_DD501                   MOUNTED
DG_TRX_DD501                   MOUNTED
DG_DBA_DF501                   MOUNTED

You can use srvctl to mount or dismount an ASM diskgroup.
+ASM2 > srvctl start diskgroup -g DG_DBA_DD501 -n lltcind02
+ASM2 > srvctl stop diskgroup -g DG_TRX_DD501 -n lltcind01

To check integrity of ASM diskgroup

SQL> alter diskgroup OCR_VOTE check;

Diskgroup altered.

If there is a problem, it will show in the alert.log.  If you specify the REPAIRT keywork, ASM will tryp to address any reported problem.

adrci> set homepath diag/asm/+asm/+ASM2
adrci> show alert -tail -f

NOTE: starting check of diskgroup OCR_VOTE
kfdp_checkDsk(): 19
kfdp_checkDsk(): 20
kfdp_checkDsk(): 21
2011-02-21 19:33:09.339000 -06:00
SUCCESS: check of diskgroup OCR_VOTE found no errors
SUCCESS: alter diskgroup OCR_VOTE check

To see spfile from ASM using asmcmd

+ASM2 > asmcmd ls -l +GRID_OCRVOTE/racpoc/asmparameterfile/spfileasm.ora
Type              Redund  Striped  Time             Sys  Name
                                                    N    spfileasm.ora => +GRID_OCRVOTE/racpoc/ASMPARAMETERFILE/REGISTRY.253.726177105

To check permission:
ASMCMD> ls --permission
User  Group  Permission  Name
                         ASMPARAMETERFILE/
                         OCRFILE/
  
To be continued...