Problém 51:
Jak lze zjistit, které zařízení (devices) náleží ASM diskům, které využívá má ASM instance?
Řešení:
SQL> set pages 50000 lines 120select path,redundancy,total_mb,free_mb,failgroupfrom v$asm_diskwhere mount_status=’CACHED‘ and header_status=’MEMBER‘ andmode_status=’ONLINE‘ and state=’NORMAL’order by path;SQL> 2 3 4 5PATH————————————————————————————————————————REDUNDANCY TOTAL_MB FREE_MB
——————— ———- ———-FAILGROUP——————————————————————————————ORCL:BACKUP_DISK1UNKNOWN 419274 417034BACKUP_DISK1ORCL:DISK1UNKNOWN 419274 137261DISK1server:~ # /etc/init.d/oracleasm listdisksBACKUP_DISK1DISK1server:~ # /etc/init.d/oracleasm querydisk DISK1Disk „DISK1“ is a valid ASM disk on device [8, 1]ls -l /dev | grep 8,| grep 1brw-rw—- 1 root disk 8, 1 Nov 17 2005 sda1server:~ # /etc/init.d/oracleasm querydisk BACKUP_DISK1Disk „BACKUP_DISK1“ is a valid ASM disk on device [8, 17]brw-rw—- 1 root disk 8, 17 Nov 17 2005 sdb1