Hello Friends,

Here with one more topic on database administration guide.

Create ASM RECO DISKGROUP using ASMCA
=====================================
show parameter string

set pages 1000
set lines 1000
col path for a50
select GROUP_NUMBER, GROUP_NUMBER, PATH, MOUNT_STATUS from v$asm_disk

asmcmd -p
lsdg
select GROUP_NUMBER, NAME from V$ASM_DISKGROUP
asmca

CREATE DISKGROUP TEST EXTERNAL REDUNDANCY DISK 'ORCL:TEST01' NAME TEST01;
ALTER DISKGROUP TEST ADD DISK 'ORCL:TEST02' NAME TEST02;
ALTER DISKGROUP TEST MOUNT;
ALTER DISKGROUP TEST DROP DISK TEST02;
ALTER DISKGROUP TEST UNDROP DISKS;

CREATE DISKGROUP disk_group_1 NORMAL REDUNDANCY
FAILGROUP failure_group_1 DISK
'/devices/diska1' NAME diska1,
'/devices/diska2' NAME diska2
FAILGROUP failure_group_2 DISK
'/devices/diskb1' NAME diskb1,
'/devices/diskb2' NAME diskb2;

#exadata #oracle #oracledatabase #oracledba #rac #database #databaseadministration #databases


Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA