RAC11G恢复OCR的方法是什么
发表于:2024-10-24 作者:千家信息网编辑
千家信息网最后更新 2024年10月24日,本篇内容主要讲解"RAC11G恢复OCR的方法是什么",感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习"RAC11G恢复OCR的方法是什么"吧!1.检查ocr[
千家信息网最后更新 2024年10月24日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 |
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的方法是什么"有了更深的了解,不妨来实际操作一番吧!这里是网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
方法
备份
字节
星期
内容
注册表
集群
学习
检查
实用
更深
主机
位置
兴趣
副本
名称
实例
实用性
实际
手动
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
网络安全技术员北京工资
腾讯软件开发实习生待遇
燕秀外挂是什么软件开发的
网络安全需要学历
传世服务器怎么调整技能伤害
霍尔果斯游爱网络技术
网络安全健康小报
cepiibaci数据库怎么看
黑龙江数据网络技术设计
数据库的检查点是什么原因
如何利用服务器机器学习
seer数据库分期
网络安全我们要做到什么
网络安全检查优点
数据库添加唯一性约束的操作步骤
软件开发承诺书范文公司
北海软件开发培训
华为软件开发工程师30岁
广东戴尔服务器维修续保
中美软件开发过程中的差异
网站运维服务器安全管理
软件开发别人拿回扣多少
工业互联网 大豪科技
服务端怎么设置redis数据库
matlab 软件开发
堕落帝国者船坞数据库
自己搭建10000小型服务器
丰台区管理软件开发好处
深圳市骉骉互联网科技有限公司
怎样登录惠普服务器管理口