共计 14299 个字符，预计需要花费 36 分钟才能阅读完成。
本篇内容主要讲解“RAC11G 恢复 OCR 的方法是什么”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让丸趣 TV 小编来带大家学习“RAC11G 恢复 OCR 的方法是什么”吧!
1. 检查 ocr
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3232
Available space (kbytes) : 258888
ID : 811139123
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
2. 检查 votedisk
[root@rac2 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 4b031d63f88f4f0cbf5cc8688884d5f2 (/dev/asm-diskb) [OCR]
2. ONLINE 1acaf51067b94fcdbf62f9a4400050d2 (/dev/asm-diskc) [OCR]
3. ONLINE 8b7b21ad7d114f21bf5e703ec4ccc44e (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
3. 导出 ocr
[root@rac2 ~]# ocrconfig -export /tmp/ocr_20160202.dmp
[root@rac2 ~]# ll tmp | grep 2016
ls: 无法访问 tmp: 没有那个文件或目录
[root@rac2 ~]# ll /tmp | grep 2016
-rw——- 1 root root 114426 2 月 2 11:06 ocr_20160202.dmp
4. 查看备份
[root@rac2 ~]# ocrconfig -showbackup
rac2 2016/02/01 17:30:53 /g01/11ggrid/app/11.2.3/grid/backup00.ocr
rac2 2016/02/01 13:30:53 /g01/11ggrid/app/11.2.3/grid/backup01.ocr
rac2 2016/02/01 09:30:52 /g01/11ggrid/app/11.2.3/grid/backup02.ocr
rac2 2016/01/31 01:30:49 /g01/11ggrid/app/11.2.3/grid/day.ocr
rac1 2016/01/26 20:52:17 /g01/11ggrid/app/11.2.3/grid/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
5.
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:07:09 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL create pfile= /home/grid/asm_pfile20160202.txt from spfile;
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[root@rac1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2673: Attempting to stop ora.cssdmonitor on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.cssdmonitor on rac1 succeeded
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ora.mdnsd on rac1
CRS-2676: Start of ora.mdnsd on rac1 succeeded
CRS-2672: Attempting to start ora.gpnpd on rac1
CRS-2676: Start of ora.gpnpd on rac1 succeeded
CRS-2672: Attempting to start ora.cssdmonitor on rac1
CRS-2672: Attempting to start ora.gipcd on rac1
CRS-2676: Start of ora.cssdmonitor on rac1 succeeded
CRS-2676: Start of ora.gipcd on rac1 succeeded
CRS-2672: Attempting to start ora.cssd on rac1
CRS-2672: Attempting to start ora.diskmon on rac1
CRS-2676: Start of ora.diskmon on rac1 succeeded
CRS-2676: Start of ora.cssd on rac1 succeeded
CRS-2679: Attempting to clean ora.cluster_interconnect.haip on rac1
CRS-2672: Attempting to start ora.ctssd on rac1
CRS-2681: Clean of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.cluster_interconnect.haip on rac1
CRS-2676: Start of ora.ctssd on rac1 succeeded
CRS-2676: Start of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.asm on rac1
CRS-2676: Start of ora.asm on rac1 succeeded
[root@rac1 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 4b031d63f88f4f0cbf5cc8688884d5f2 (/dev/asm-diskb) [OCR]
2. ONLINE 1acaf51067b94fcdbf62f9a4400050d2 (/dev/asm-diskc) [OCR]
3. ONLINE 8b7b21ad7d114f21bf5e703ec4ccc44e (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskb bs=1024 count=1000
记录了 1000+0 的读入
记录了 1000+0 的写出
1024000 字节(1.0 MB) 已复制，0.0754203 秒，13.6 MB/ 秒
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskc bs=1024 count=1000
记录了 1000+0 的读入
记录了 1000+0 的写出
1024000 字节(1.0 MB) 已复制，0.0656402 秒，15.6 MB/ 秒
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskd bs=1024 count=1000
记录了 1000+0 的读入
记录了 1000+0 的写出
1024000 字节(1.0 MB) 已复制，0.056022 秒，18.3 MB/ 秒
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:23:17 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL startup pfile= /home/grid/asm_pfile20160202.txt
ASM 实例已启动
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15017: diskgroup OCR cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup OCR
SQL select group_number, disk_number, mount_status, header_status, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
———— ———– ——————— ————————————
PATH
—————————————————————————————————-
0 3 CLOSED CANDIDATE
/dev/asm-diskd
0 4 CLOSED CANDIDATE
/dev/asm-diskb
0 5 CLOSED CANDIDATE
/dev/asm-diskc
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
———— ———– ——————— ————————————
PATH
—————————————————————————————————-
1 2 CACHED MEMBER
/dev/asm-diskg
1 1 CACHED MEMBER
/dev/asm-diskf
1 0 CACHED MEMBER
/dev/asm-diske
6 rows selected.
SQL create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
Diskgroup created.
SQL create spfile= +OCR from pfile= /home/grid/asm_pfile20160202.txt
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ ocrconfig -showbackup
PROT-26: 从本地副本中检索到了 Oracle 集群注册表备份位置
rac2 2016/02/01 13:30:53 /g01/11ggrid/app/11.2.3/grid/backup00.ocr
rac2 2016/02/01 09:30:52 /g01/11ggrid/app/11.2.3/grid/backup01.ocr
rac2 2016/02/01 05:30:52 /g01/11ggrid/app/11.2.3/grid/backup02.ocr
rac2 2016/01/31 01:30:49 /g01/11ggrid/app/11.2.3/grid/day.ocr
rac1 2016/01/26 20:52:17 /g01/11ggrid/app/11.2.3/grid/week.ocr
PROT-25: Oracle 集群注册表的手动备份不可用
[root@rac1 ~]# ocrconfig -restore /g01/11ggrid/app/11.2.3/grid/week.ocr
[root@rac1 ~]# crsctl replace votedisk +OCR
Diskgroup +OCR is already configured with voting files
CRS-4000: Command Replace failed, or completed with errors.
[root@rac1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.ctssd on rac1
CRS-2673: Attempting to stop ora.asm on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.asm on rac1 succeeded
CRS-2673: Attempting to stop ora.cluster_interconnect.haip on rac1
CRS-2677: Stop of ora.ctssd on rac1 succeeded
CRS-2677: Stop of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2673: Attempting to stop ora.cssd on rac1
CRS-2677: Stop of ora.cssd on rac1 succeeded
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ora.mdnsd on rac1
CRS-2676: Start of ora.mdnsd on rac1 succeeded
CRS-2672: Attempting to start ora.gpnpd on rac1
CRS-2676: Start of ora.gpnpd on rac1 succeeded
CRS-2672: Attempting to start ora.cssdmonitor on rac1
CRS-2672: Attempting to start ora.gipcd on rac1
CRS-2676: Start of ora.cssdmonitor on rac1 succeeded
CRS-2676: Start of ora.gipcd on rac1 succeeded
CRS-2672: Attempting to start ora.cssd on rac1
CRS-2672: Attempting to start ora.diskmon on rac1
CRS-2676: Start of ora.diskmon on rac1 succeeded
CRS-2676: Start of ora.cssd on rac1 succeeded
CRS-2679: Attempting to clean ora.cluster_interconnect.haip on rac1
CRS-2672: Attempting to start ora.ctssd on rac1
CRS-2681: Clean of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.cluster_interconnect.haip on rac1
CRS-2676: Start of ora.ctssd on rac1 succeeded
CRS-2676: Start of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.asm on rac1
CRS-2676: Start of ora.asm on rac1 succeeded
[root@rac1 ~]# crsctl query css votedisk
Located 0 voting disk(s).
[root@rac1 ~]# su – grid
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:38:47 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL startup pfile= /home/grid/asm_pfile20160202.txt
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL set lines 1000
SQL select group_number, disk_number, mount_status, header_status, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS PATH
———— ———– ——————— ———————————— ————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
1 2 CACHED MEMBER /dev/asm-diskg
1 1 CACHED MEMBER /dev/asm-diskf
1 0 CACHED MEMBER /dev/asm-diske
2 2 CACHED MEMBER /dev/asm-diskd
2 0 CACHED MEMBER /dev/asm-diskb
2 1 CACHED MEMBER /dev/asm-diskc
6 rows selected.
SQL create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15030: diskgroup name OCR is in use by another diskgroup
SQL create spfile= +OCR from pfile= /home/grid/asm_pfile20160202.txt
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ su –
Password:
[root@rac1 ~]# ocrconfig -restore /g01/11ggrid/app/11.2.3/grid/week.ocr
[root@rac1 ~]# crsctl replace votedisk +OCR
Successful addition of voting disk 263eb678cbb34fdfbf3a7e565be61d35.
Successful addition of voting disk 1c39e6bd1fa34f60bfbf691dd9f4f98b.
Successful addition of voting disk 3ccd631501724f95bfc2f3150a2e4201.
Successfully replaced voting disk group with +OCR.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2860
Available space (kbytes) : 259260
ID : 811139123
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
[root@rac1 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 263eb678cbb34fdfbf3a7e565be61d35 (/dev/asm-diskb) [OCR]
2. ONLINE 1c39e6bd1fa34f60bfbf691dd9f4f98b (/dev/asm-diskc) [OCR]
3. ONLINE 3ccd631501724f95bfc2f3150a2e4201 (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
[root@rac1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.ctssd on rac1
CRS-2673: Attempting to stop ora.asm on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.ctssd on rac1 succeeded
CRS-2677: Stop of ora.asm on rac1 succeeded
CRS-2673: Attempting to stop ora.cluster_interconnect.haip on rac1
CRS-2677: Stop of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2673: Attempting to stop ora.cssd on rac1
CRS-2677: Stop of ora.cssd on rac1 succeeded
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 ~]# reboot
[grid@rac1 ~]$ crs_stat -v -t
名称 类型 R/RA F/FT 目标 状态 主机
———————————————————————-
ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE rac1
ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE rac1
ora….N1.lsnr ora….er.type 0/5 0/0 ONLINE ONLINE rac1
ora.OCR.dg ora….up.type 0/5 0/ ONLINE ONLINE rac1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE rac1
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora.kingsql.db ora….se.type 0/2 0/1 ONLINE ONLINE rac1
ora….network ora….rk.type 0/5 0/ ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE rac1
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1
ora….SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora….C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip ora….t1.type 0/0 0/0 ONLINE ONLINE rac1
ora….SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora….C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip ora….t1.type 0/0 0/0 ONLINE ONLINE rac2
ora.scan1.vip ora….ip.type 0/0 0/0 ONLINE ONLINE rac1
到此，相信大家对“RAC11G 恢复 OCR 的方法是什么”有了更深的了解，不妨来实际操作一番吧！这里是丸趣 TV 网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！
