导航：首页 > 数据库 >

RAC11G恢复OCR的方法是什么

发表于：2024-11-23 作者：千家信息网编辑

千家信息网最后更新 2024年11月23日，本篇内容主要讲解"RAC11G恢复OCR的方法是什么"，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习"RAC11G恢复OCR的方法是什么"吧!1.检查ocr[

千家信息网最后更新 2024年11月23日RAC11G恢复OCR的方法是什么

本篇内容主要讲解"RAC11G恢复OCR的方法是什么"，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习"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

[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的方法是什么"有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！

很赞哦！