ORACLE CLOUD ADVANTAGES

OTN Tour 2017
                              

La presentacion completa la pueden ver en

https://www.slideshare.net/OracleUserGroupMexic/oracle-cloud-advantages-78862686

ASM

Architecture for Oracle Database 11g

ASM Commands

########################

# Check de +ASM Disks  #

########################

set lines 188
col path for a39
col name for a33
set pagesize 200
select GROUP_NUMBER,DISK_NUMBER,NAME,PATH,TOTAL_MB,FREE_MB,TOTAL_MB,MODE_STATUS,STATE,HEADER_STATUS
from  v$asm_disk
order by 10,4,1,2
/

###################################

# To monitor rebalance +ASM Disks #

###################################

select * from v$asm_operation;

###################################

# Check status for +ASM Disks     #

###################################

set lines 180

col PATH for a40

SELECT group_number, disk_number, mount_status, header_status, state, path from v$asm_disk;

/

To Check ASM Disks and Paths

 /etc/init.d/oracleasm listdisks | xargs /etc/init.d/oracleasm querydisk -p

ASMLIB

To Start/Stop ASMLIB

/etc/init.d/oracleasm start

/etc/init.d/oracleasm stop

To Check ASM Disks in ASMLIB

/etc/init.d/oracleasm listdisks

To find device on /dev/*

[oracle@addb01 ~]$ ls -l /dev/* | grep '253,' | grep 56

brw-rw----  1 root root 253,   56 Jan 31 16:29 /dev/dm-56

brw-rw----  1 root   disk     253, 56 Jan 31 16:29 mpath11p1

For ASMLIB level, you can check

ls -al /dev/oracleasm/disks/*

/usr/sbin/oracleasm-discover 'ORCL:*'