Advertisement

Saturday, April 6, 2019

Oracle Database: Lower Compatibility / Recreate Disk Groups RAC

In this blog, I talk about recreation of Diskgroups, the reason can be any  like you want to change the name, or any other.
(remember data will be lost, so if you are doing this just for fun, don't on a production cluster)

Below are the Steps 

Step 1 - Free the Diskgroup
Shutdown all the Databases and remove any open files from the diskgroup (oracle user)
You can lsof command to check open files in asmcmd prompt. (grid user)

Relocate any OCR copy if there (root user)

Step 2 - Dismount the Diskgroup from Node 1 (grid user)
alter diskgroup <name> dismount;

Step 3- Drop the Diskgroup from Node 2 (grid user)
drop diskgroup <name>;

Step 4 - Free the disks to system (root user)
oracleasm delete disk <name>

Step 5 - Rescan the disk on the other node (root user)
oracleasm scandisks

Step 6  - Recreate the disk (root user)
oracleasm create disk <path> <name>

Step 7 - Rescan the disk on the other node (root user)
oracleasm scandisks

Step 8 - Recreate the diskgroup (grid user)
asmca -silent -sysAsmPassword mypassword -asmsnmpPassword mypassword -createDiskGroup -diskGroupName DATA -diskList  /dev/oracleasm/disks/DISK_DATA -redundancy EXTERNAL -au_size 4 -compatible.asm 18.0.0.0.0 -compatible.rdbms 11.2.0.0.0


Step 9 - Add ocr if required
ocrconfig add <DG_NAME>


No comments:
Write comments