OracleRac11.2.0.3 migrate OCR and VOTEDISK
Environment: AIX7.1 + Oracle Rac 11.2.0.3
Migration Description: When Oracle Rac is installed today, the GB Data disk is incorrectly used as OCRDG. Therefore, it will be troublesome to migrate ocr and votedisk to the newly created OCRDG, delete DATADG and format the disk. (OCRDG is normal redundancy:
Grid @ rac1:/home/grid>/oraapp/grid/gridhome/bin/ocrcheckStatus of Oracle Cluster Registry is as follows: Version: 3 Total space (kbytes ): 1469612 Used space (kbytes): 3784 Available space (kbytes): 1465828 ID: 1820175369 Device/File Name: + DATADG Device/File integrity check succeeded Device/File not configured Cluster registry integrity check succeeded Logical authentication uption check bypassed due to non-privileged user add ocr information to + OCRDG: root @ rac1 :. /root>/oraapp/grid/gridhome/bin/ocrconfig-add + OCRDG
Delete + ocr: root @ rac1:./root>/oraapp/grid/gridhome/bin/ocrconfig-delete + DATADG
Migrate votedisk: grid @ rac1:/home/grid> crsctl replace votedisk + OCRDG to view votedisk information: grid @ rac1:/home/grid> crsctl query css votedisk;
View diskgroup information: sqlplus/as sysasm SQL> select group_number, name, state, type from V $ asm_diskgroup;
In this case, spfile is stored in + DATADG, and spfile must be rebuilt: SQL> create pfile = '/tmp/asmpfile. ora 'from spfile; SQL> create spfile = '+ OCRDG' from pfile = '/tmp/asmpfile. ora ';
Then restart crs with the root user (restart sequentially on both sides)
Root @ rac1:./root>/oraapp/grid/gridhome/bin/crsctl stop crsroot @ rac1:./root>/oraapp/grid/gridhome/bin/crsctl start crs
Delete a disk group + DATADG:
SQL> alter diskgroup DATADG dismount; SQL> drop diskgroup DATADG including contents;