ASM manage script

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 dg, V$ASM_ATTRIBUTE a
 WHERE dg.name = 'DATA'
   AND dg.group_number = a.group_number;

DATA disk_repair_time   3.6h        N      
DATA au_size             1048576    Y              
DATA sector_size        512         Y              
DATA compatible.asm     11.2.0.0.0  N  
DATA compatible.rdbms   10.1.0.0.0  N
DATA cell.smart_scan_ca FALSE       N    
DATA access_control.ena FALSE       N    

SELECT name AS diskgroup, compatibility AS asm_compat, 
     database_compatibility AS db_compat FROM V$ASM_DISKGROUP;

ACFS 11.2.0.0.0 10.1.0.0.0
DATA 11.2.0.0.0 10.1.0.0.0
FLASH 11.2.0.0.0 10.1.0.0.0
DGA   10.1.0.0.0 10.1.0.0.0

SELECT SUBSTR(d.name,1,16) AS asmdisk, d.mount_status, d.state, 
     dg.name AS diskgroup FROM V$ASM_DISKGROUP dg, V$ASM_DISK d 
     WHERE dg.group_number = d.group_number;

ACFS_0000   CACHED   NORMAL ACFS
DATA_0000   CACHED   NORMAL DATA
FLASH_0000 CACHED   NORMAL FLASH
DGA_0000   CACHED   NORMAL DGA

    
    SELECT dg.name AS diskgroup,
           SUBSTR(c.instance_name, 1, 12) AS instance,
           SUBSTR(c.db_name, 1, 12) AS dbname,
           SUBSTR(c.SOFTWARE_VERSION, 1, 12) AS software,
           SUBSTR(c.COMPATIBLE_VERSION, 1, 12) AS compatible
      FROM V$ASM_DISKGROUP dg, V$ASM_CLIENT c
     WHERE dg.group_number = c.group_number;

ACFS +ASM1   asmvol 11.2.0.2.0 11.2.0.2.0
DATA henry1 henry   11.2.0.2.0 11.2.0.0.0
DATA +ASM1   +ASM   11.2.0.2.0 11.2.0.2.0
FLASH henry1 henry   11.2.0.2.0 11.2.0.0.0

 SELECT dg.name AS diskgroup, f.file_number, f.primary_region, f.mirror_region, f.hot_reads,
       f.hot_writes,  f.cold_reads, f.cold_writes
       FROM V$ASM_DISKGROUP dg, V$ASM_FILE f 
       WHERE dg.group_number = f.group_number and dg.name = 'DATA';
       
DATA 256 COLD COLD 0 0 4041 6087
DATA 257 COLD COLD 0 0 6310 108412
DATA 258 COLD COLD 0 0 119 22253
DATA 259 COLD COLD 0 0 93 17
DATA 260 COLD COLD 0 0 2181637 305527
DATA 261 COLD COLD 0 0 26 26686
DATA 262 COLD COLD 0 0 25 32832
DATA 255 COLD COLD 0 0 0 0
DATA 253 COLD COLD 0 0 0 0
DATA 263 COLD COLD 0 0 103 110
DATA 267 COLD COLD 0 0 0 0
DATA 266 COLD COLD 0 0 0 0
DATA 265 COLD COLD 0 0 0 0
DATA 264 COLD COLD 0 0 92 17

SELECT dg.name AS diskgroup, t.name, t.stripe, t.redundancy, t.primary_region, t.mirror_region 
       FROM V$ASM_DISKGROUP dg, V$ASM_TEMPLATE t 
       WHERE dg.group_number = t.group_number and dg.name = 'DATA' ORDER BY t.name;       
DATA ARCHIVELOG           COARSE UNPROT COLD COLD
DATA ASMPARAMETERFILE     COARSE UNPROT COLD COLD
DATA AUTOBACKUP           COARSE UNPROT COLD COLD
DATA BACKUPSET             COARSE UNPROT COLD COLD
DATA CHANGETRACKING       COARSE UNPROT COLD COLD
DATA CONTROLFILE FINE     UNPROT COLD   COLD
DATA DATAFILE COARSE     UNPROT COLD   COLD
DATA DATAGUARDCONFIG       COARSE UNPROT COLD COLD

SELECT fs_name, available_time, block_size, state, corrupt FROM V$ASM_FILESYSTEM;
/opt/app/grid/acfsmounts/acfs_acfs 2011-5-4 18:14:10 4 AVAILABLE FALSE
/opt/app/grid/acfsmounts/acfs_hxz   2011-5-4 18:14:11 4 AVAILABLE FALSE                   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/46907/viewspace-697419/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/46907/viewspace-697419/