Oracle Rac 11.2.0.3迁移OCR和VOTEDISK

mac2022-06-30  81

环境:AIX7.1+Oracle Rac 11.2.0.3 迁移描述:今天在装Oracle Rac的时候,错误的将500G的数据盘用作OCRDG了,遂后续比较麻烦,只能讲ocr和votedisk迁移到新建的OCRDG上,并把DATADG删除并格式化该盘。(OCRDG为normal 冗余)   操作如下: grid@rac1:/home/grid>/oraapp/grid/gridhome/bin/ocrcheck Status 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                                     Device/File not configured          Cluster registry integrity check succeeded          Logical corruption check bypassed due to non-privileged user   添加ocr信息到+OCRDG中: root@rac1:./root>/oraapp/grid/gridhome/bin/ocrconfig -add +OCRDG 删除+DATADG中ocr: root@rac1:./root>/oraapp/grid/gridhome/bin/ocrconfig -delete +DATADG 然后迁移votedisk: grid@rac1:/home/grid>crsctl replace votedisk +OCRDG   查看votedisk的信息: grid@rac1:/home/grid>crsctl query css votedisk;   查看diskgroup的信息: sqlplus / as sysasm   SQL> select group_number,name,state,type from V$asm_diskgroup;     此时spfile存放在+DATADG中,需要重建spfile: SQL>create pfile='/tmp/asmpfile.ora' from spfile;   SQL>create spfile='+OCRDG' from pfile='/tmp/asmpfile.ora';     然后使用root用户重启crs即可(两边顺序重启) root@rac1:./root>/oraapp/grid/gridhome/bin/crsctl stop crs root@rac1:./root>/oraapp/grid/gridhome/bin/crsctl start crs 删除磁盘组+DATADG: SQL>alter diskgroup DATADG dismount;   SQL>drop diskgroup DATADG including contents;

转载于:https://www.cnblogs.com/seven-dba/p/4354873.html

最新回复(0)