Moving GRID disk group files to another disk group
November 30, 2021 Leave a comment
To migrate all content from +GRID diskgroup to another newly created one, we need to know what is the list of necessary files that are located on it:
- ASM password file
- ASM Spfile
- OCR
- Voting files
- OCR backups (if configured on the same diskgroup)
Let’s migrate all of them one by one:
Migrate ASM password file
1. Locate the Oracle ASM password file:
[grid@rac1 ~]$ asmcmd pwget --asm +GRID/orapwASM
2. Migrate the password file:
[grid@rac1 ~]$ asmcmd pwmove --asm -f +GRID/orapwASM +GRID2/orapwASM moving +GRID/orapwASM -> +GRID2/orapwASM
3. Verify that the file has a new path:
[grid@rac1 ~]$ asmcmd pwget --asm +GRID2/orapwASM
Migrate ASM Spfile
1. Locate the Oracle ASM SPFILE:
[grid@rac1 ~]$ asmcmd spget +GRID/marirac/ASMPARAMETERFILE/registry.253.1088678891
2. Migrate the spfile:
[grid@rac1 ~]$ asmcmd spmove +GRID/marirac/ASMPARAMETERFILE/registry.253.1088678891 +GRID2/marirac/ASMPARAMETERFILE/spfileASM ORA-15032: not all alterations performed ORA-15028: ASM file '+GRID/marirac/ASMPARAMETERFILE/registry.253.1088678891' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
The error message can be ignored, the new location will be used after we restart CRS.
3. Verify:
[grid@rac1 ~]$ asmcmd spget +GRID2/marirac/ASMPARAMETERFILE/spfileASM
Migrate OCR
1. Get the current OCR location:
[grid@rac1 ~]$ ocrcheck -config Oracle Cluster Registry configuration is : Device/File Name : +GRID
2. Move OCR:
[grid@rac1 ~]$ ocrconfig -add +GRID2 PROT-20: Insufficient permission to proceed. Require privileged user [grid@rac1 ~]$ exit logout [root@rac1 ~]# ocrconfig -add +GRID2 [root@rac1 ~]# ocrconfig -delete +GRID
3. Verify:
[root@rac1 ~]# ocrcheck -config Oracle Cluster Registry configuration is : Device/File Name : +GRID2
Migrate voting files
1. Get the current location:
[root@rac1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 544b7b2dc9f14f8dbf8f5c560a32a95f (/dev/flashgrid/rac2.xvdba) [GRID] 2. ONLINE c4035c7009be4f26bffd663651e4d520 (/dev/flashgrid/rac1.xvdba) [GRID] 3. ONLINE 5737c31731574fa8bf2acc107fbbd364 (/dev/flashgrid/racq.xvdba) [GRID] Located 3 voting disk(s).
2. Move:
[root@rac1 ~]# crsctl replace votedisk +GRID2 Successful addition of voting disk 26221fd4d7334fa8bfc98be1908ee3ef. Successful addition of voting disk 093f9c21b9864f87bfc4853547f05a16. Successful addition of voting disk 9c2a9fd2fc334f7ebfb44c04bdb0cf57. Successful deletion of voting disk 544b7b2dc9f14f8dbf8f5c560a32a95f. Successful deletion of voting disk c4035c7009be4f26bffd663651e4d520. Successful deletion of voting disk 5737c31731574fa8bf2acc107fbbd364. Successfully replaced voting disk group with +GRID2. CRS-4266: Voting file(s) successfully replaced
3. Verify:
[root@rac1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 26221fd4d7334fa8bfc98be1908ee3ef (/dev/flashgrid/rac1.xvdbc) [GRID2] 2. ONLINE 093f9c21b9864f87bfc4853547f05a16 (/dev/flashgrid/rac2.xvdbc) [GRID2] 3. ONLINE 9c2a9fd2fc334f7ebfb44c04bdb0cf57 (/dev/flashgrid/racq.xvdbz) [GRID2] Located 3 voting disk(s).
Moving OCR backup
Please note that having OCR backup on the same location where OCR is located is not a good practice, you should have another disgroup for that. So let’s assume, we have separate DG for that.
1. Check the current location:
[root@rac1 ~]# ocrconfig -showbackup rac2 2021/11/29 17:07:02 +GRID:/marirac/OCRBACKUP/backup00.ocr.276.1089911215 1443639413 rac2 2021/11/25 16:52:08 +GRID:/marirac/OCRBACKUP/backup01.ocr.275.1089564721 1443639413 rac2 2021/11/21 14:13:23 +GRID:/marirac/OCRBACKUP/backup02.ocr.277.1089209597 1443639413 rac2 2021/11/29 17:07:02 +GRID:/marirac/OCRBACKUP/day.ocr.272.1089911223 1443639413 rac1 2021/11/15 15:05:26 +GRID:/marirac/OCRBACKUP/week.ocr.273.1088694327 1443639413 PROT-25: Manual backups for the Oracle Cluster Registry are not available
2. Reconfigure:
[root@rac1 ~]# ocrconfig -backuploc +FRA
There are automatic OCR backups that are taken in the past 4 hours, 8 hours, 12 hours, and in the last day and week. Until this time passes, we can run manual backup for safety:
[root@rac1 ~]# ocrconfig -manualbackup rac2 2021/11/30 12:20:15 +FRA:/marirac/OCRBACKUP/backup_20211130_122015.ocr.257.1089980415 1443639413
3. Verify:
[root@rac1 ~]# ocrconfig -showbackup rac2 2021/11/29 17:07:02 +GRID:/marirac/OCRBACKUP/backup00.ocr.276.1089911215 1443639413 rac2 2021/11/25 16:52:08 +GRID:/marirac/OCRBACKUP/backup01.ocr.275.1089564721 1443639413 rac2 2021/11/21 14:13:23 +GRID:/marirac/OCRBACKUP/backup02.ocr.277.1089209597 1443639413 rac2 2021/11/29 17:07:02 +GRID:/marirac/OCRBACKUP/day.ocr.272.1089911223 1443639413 rac1 2021/11/15 15:05:26 +GRID:/marirac/OCRBACKUP/week.ocr.273.1088694327 1443639413 rac2 2021/11/30 12:20:15 +FRA:/marirac/OCRBACKUP/backup_20211130_122015.ocr.257.1089980415 1443639413
DBA Knowledge Base 