1. 查看 ocr 和 votedisk
- [oracle:/home/oracle:RACTEST1] ocrcheck
- Status of Oracle Cluster Registry is as follows :
- Version : 3
- Total space (kbytes) : 262120
- Used space (kbytes) : 3104
- Available space (kbytes) : 259016
- ID : 44728649
- Device/File Name : +OCR1
- Device/File integrity check succeeded
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Cluster registry integrity check succeeded
- Logical corruption check bypassed due to non-privileged user
- [oracle:/home/oracle:RACTEST1] crsctl query CSS votedisk
- *## STATE File Universal Id File Name Disk group
- ONLINE a5ef8885d1564f99bf0e0d77286c3b1f (/dev/oracleasm/disks/OCR11) [OCR1]
- Located 1 voting disk(s).
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- DATA 512 1048576 MOUNTED EXTERN N
- OCR1 512 1048576 MOUNTED EXTERN Y
2. 创建新的 ASM diskgroup(asmca 图形界面创建)
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- DATA 512 1048576 MOUNTED EXTERN N
- OCR1 512 1048576 MOUNTED EXTERN Y
- OCR 512 1048576 MOUNTED NORMAL N
3.votedisk 从 + OCR1 更改到 +OCR
- [oracle:/home/oracle:RACTEST1] crsctl replace votedisk +OCR
- Successful addition of voting disk 9b4ac868901f4f89bf191e59baa3442b.
- Successful addition of voting disk 2c2eff1ca2ad4f7bbfcdf8fc913dcc45.
Successful addition of voting disk 652d503ff1154fd6bfdfe3273a12d529.
Successful deletion of voting disk a5ef8885d1564f99bf0e0d77286c3b1f.
Successfully replaced voting disk group with +OCR.
- CRS-4266: Voting file(s) successfully replaced
- [oracle:/home/oracle:RACTEST1] crsctl query CSS votedisk
- *## STATE File Universal Id File Name Disk group
- ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
- ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
- ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
- Located 3 voting disk(s).
4. 更改 ocr
- [[email protected] disks]# ocrconfig -add +OCR
- [[email protected] disks]# ocrcheck
- Status of Oracle Cluster Registry is as follows :
- Version : 3
- Total space (kbytes) : 262120
- Used space (kbytes) : 3108
- Available space (kbytes) : 259012
- ID : 44728649
- Device/File Name : +OCR1
- Device/File integrity check succeeded
- Device/File Name : +OCR
- Device/File integrity check succeeded
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Cluster registry integrity check succeeded
- Logical corruption check succeeded
- [[email protected] disks]# ocrconfig -delete +OCR1
- [[email protected] disks]# ocrcheck
- Status of Oracle Cluster Registry is as follows :
- Version : 3
- Total space (kbytes) : 262120
- Used space (kbytes) : 3108
- Available space (kbytes) : 259012
- ID : 44728649
- Device/File Name : +OCR
- Device/File integrity check succeeded
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Cluster registry integrity check succeeded
- Logical corruption check succeeded
5. 查看 asm 参数文件存放的位置并修改到 + OCR 上
- SQL> show parameter spfile
- NAME TYPE VALUE
- spfile string +OCR1/ractest-cluster/asmparam
- eterfile/registry.253.10297677
- 13
- SQL> create pfile='/oracle/app/product/grid/dbs/pfile_ASM1.ora' from spfile;
File created.
SQL> create spfile='+OCR' from pfile='/oracle/app/product/grid/dbs/pfile_ASM1.ora';
File created.
- SQL> show parameter spfile
- NAME TYPE VALUE
- spfile string +OCR1/ractest-cluster/asmparam
- eterfile/registry.253.10297677
- 13
6. 一节点重启 crs
- [[email protected] disks]# crsctl stop crs
- [[email protected] disks]# crsctl start crs
- [[email protected] disks]# su - oracle
- [oracle:/home/oracle:RACTEST1] srvctl start instance -d RACTEST -n ractest1
- [oracle:/home/oracle:RACTEST1] crs
- --------------------------------------------------------------------------------
- NAME TARGET STATE SERVER STATE_DETAILS
- --------------------------------------------------------------------------------
- Local Resources
- *--------------------------------------------------------------------------------
- ora.DATA.dg
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.LISTENER.lsnr
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.OCR.dg
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.OCR1.dg
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.asm
- ONLINE ONLINE ractest1 Started
- ONLINE ONLINE ractest2 Started
- ora.gsd
- OFFLINE OFFLINE ractest1
- OFFLINE OFFLINE ractest2
- ora.net1.network
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.ons
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- ora.registry.acfs
- ONLINE ONLINE ractest1
- ONLINE ONLINE ractest2
- Cluster Resources
- ora.cvu
- 1 ONLINE ONLINE ractest2
- ora.oc4j
- 1 OFFLINE OFFLINE
- ora.ractest.db
- 1 ONLINE ONLINE ractest1 Open
- 2 ONLINE ONLINE ractest2 Open
- ora.ractest1.vip
- 1 ONLINE ONLINE ractest1
- ora.ractest2.vip
- 1 ONLINE ONLINE ractest2
- ora.testdb.db
- 1 ONLINE OFFLINE Instance Shutdown
- SQL> show parameter spfile
- NAME TYPE VALUE
- spfile string +OCR/ractest-cluster/asmparame
- terfile/registry.253.102983977
- 5
7.2 节点重启 crs
- [[email protected] ~]# crsctl stop crs
- [[email protected] ~]# crsctl start crs
- [[email protected] ~]# su - oracle
- [oracle:/home/oracle:RACTEST2] srvctl start instance -d RACTEST -n ractest2
- SQL> show parameter spfile
- NAME TYPE VALUE
- spfile string +OCR/ractest-cluster/asmparame
- terfile/registry.253.102983977
- 5
8. 删除 +OCR1
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- DATA 512 1048576 MOUNTED EXTERN N
- OCR1 512 1048576 MOUNTED EXTERN N
- OCR 512 1048576 MOUNTED NORMAL Y
- SQL> drop diskgroup OCR1 including contents;
- drop diskgroup OCR1 including contents
- *
- ERROR at line 1:
- ORA-15039: diskgroup not dropped
- ORA-15073: diskgroup OCR1 is mounted by another ASM instance
- SQL> alter diskgroup OCR1 dismount;
Diskgroup altered.
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- 1 DATA 512 1048576 MOUNTED EXTERN N
- 0 OCR1 0 0 DISMOUNTED N
- 3 OCR 512 1048576 MOUNTED NORMAL Y
- SQL> drop diskgroup OCR1 including contents;
- drop diskgroup OCR1 including contents
- *
- ERROR at line 1:
- ORA-15039: diskgroup not dropped
- ORA-15001: diskgroup "OCR1" does not exist or is not mounted
- SQL> alter diskgroup OCR1 mount;
Diskgroup altered.
SQL> drop diskgroup OCR1 including contents;
Diskgroup dropped.
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- 1 DATA 512 1048576 MOUNTED EXTERN N
- 3 OCR 512 1048576 MOUNTED NORMAL Y
2 节点查看:
- SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,VOTING_FILES from v$asm_diskgroup;
- GROUP_NUMBER NAME SECTOR_SIZE ALLOCATION_UNIT_SIZE STATE TYPE VOT
- 1 DATA 512 1048576 MOUNTED EXTERN N
- 3 OCR 512 1048576 MOUNTED NORMAL Y
9. 最后在 2 个节点都查看一下
- [oracle:/home/oracle:+ASM1] crsctl query CSS votedisk
- *## STATE File Universal Id File Name Disk group
- ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
- ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
- ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
- Located 3 voting disk(s).
- [oracle:/home/oracle:+ASM1] ocrcheck
- Status of Oracle Cluster Registry is as follows :
- Version : 3
- Total space (kbytes) : 262120
- Used space (kbytes) : 3088
- Available space (kbytes) : 259032
- ID : 44728649
- Device/File Name : +OCR
- Device/File integrity check succeeded
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Cluster registry integrity check succeeded
- Logical corruption check bypassed due to non-privileged user
- [oracle:/home/oracle:+ASM2] crsctl query CSS votedisk
- *## STATE File Universal Id File Name Disk group
- ONLINE 9b4ac868901f4f89bf191e59baa3442b (/dev/oracleasm/disks/OCR01) [OCR]
- ONLINE 2c2eff1ca2ad4f7bbfcdf8fc913dcc45 (/dev/oracleasm/disks/OCR02) [OCR]
- ONLINE 652d503ff1154fd6bfdfe3273a12d529 (/dev/oracleasm/disks/OCR03) [OCR]
- Located 3 voting disk(s).
- [oracle:/home/oracle:+ASM2] ocrcheck
- Status of Oracle Cluster Registry is as follows :
- Version : 3
- Total space (kbytes) : 262120
- Used space (kbytes) : 3088
- Available space (kbytes) : 259032
- ID : 44728649
- Device/File Name : +OCR
- Device/File integrity check succeeded
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Device/File not configured
- Cluster registry integrity check succeeded
- Logical corruption check bypassed due to non-privileged user
来源: http://www.bubuko.com/infodetail-3383376.html