Posts

Showing posts from September, 2020

Migrate the data from one disk to another or Add new disk and remove old disk in oracle ASM

old disk: DATA_DISK New disk: DATA12_DISK Step-1: check what disks are allocate to the diskgroup . oraenv +ASM1 sqlplus / as sysasm set linesize 300 set pagesize 1000 set colsep | col name for a15 col PATH for a44 col HEADER_STATUS for a10 col MODE_STATUS for a10 col DN for 9999 col STATE for a10 col LABEL for a25 select group_number,name from v$asm_diskgroup order by name; select        a.GROUP_NUMBER gn,       b.name,       a.DISK_NUMBER DN,       a.PATH,       a.MOUNT_STATUS M_Status,       a.HEADER_STATUS H_Status,       a.MODE_STATUS,       a.STATE,       a.OS_MB,       a.TOTAL_MB,       a.FREE_MB from         v$asm_disk A,        v$asm_diskgroup B        Where A.group_number=B.group_number(+)         and a.GROUP_NUMBER = ...