OCR磁盘的导出和导入、备份和恢复以及移动(ocrconfig命令的应用)

简介:

数据库版本:10.2.0.1

一,使用导出、导入进行备份和恢复

Oracle推荐在对集群做调整时,比如增加、删除节点之前,应该对OCR做一个备份,可以使用export 备份到指定文件。如果做了replace或restore等操作,Oracle建议使用"cluvfy comp ocr -n all" 命令做一次全面检查。

1.首先关闭所有节点的CRS

复制代码
复制代码
[oracle@rac3 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac3        
ora....C3.lsnr application    ONLINE    ONLINE    rac3        
ora.rac3.gsd   application    ONLINE    ONLINE    rac3        
ora.rac3.ons   application    ONLINE    ONLINE    rac3        
ora.rac3.vip   application    ONLINE    ONLINE    rac3        
ora....SM2.asm application    ONLINE    ONLINE    rac4        
ora....C4.lsnr application    ONLINE    ONLINE    rac4        
ora.rac4.gsd   application    ONLINE    ONLINE    rac4        
ora.rac4.ons   application    ONLINE    ONLINE    rac4        
ora.rac4.vip   application    ONLINE    ONLINE    rac4        
ora.racdb.db   application    ONLINE    ONLINE    rac3        
ora....b1.inst application    ONLINE    ONLINE    rac3        
ora....b2.inst application    ONLINE    ONLINE    rac4        
ora....rver.cs application    ONLINE    ONLINE    rac3        
ora....db2.srv application    ONLINE    ONLINE    rac3  


[root@rac3 bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
复制代码
复制代码
复制代码
复制代码
[oracle@rac4 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac3        
ora....C3.lsnr application    ONLINE    ONLINE    rac3        
ora.rac3.gsd   application    ONLINE    ONLINE    rac3        
ora.rac3.ons   application    ONLINE    ONLINE    rac3        
ora.rac3.vip   application    ONLINE    ONLINE    rac3        
ora....SM2.asm application    ONLINE    ONLINE    rac4        
ora....C4.lsnr application    ONLINE    ONLINE    rac4        
ora.rac4.gsd   application    ONLINE    ONLINE    rac4        
ora.rac4.ons   application    ONLINE    ONLINE    rac4        
ora.rac4.vip   application    ONLINE    ONLINE    rac4        
ora.racdb.db   application    ONLINE    ONLINE    rac3        
ora....b1.inst application    ONLINE    ONLINE    rac3        
ora....b2.inst application    ONLINE    ONLINE    rac4        
ora....rver.cs application    ONLINE    ONLINE    rac3        
ora....db2.srv application    ONLINE    ONLINE    rac3        


[root@rac4 bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
复制代码
复制代码

 


2.导出OCR内容(需要root用户导出)

[root@rac4 bin]# ./ocrconfig -export /home/oracle/ocr.exp
[root@rac4 bin]# ll /home/oracle/ocr.exp 
-rw-r--r--  1 root root 98847 Jan 27 11:23 /home/oracle/ocr.exp

 

3.重新启动CRS

复制代码
复制代码
[root@rac3 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly


[root@rac4 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly
复制代码
复制代码

 

4.检查CRS状态

复制代码
复制代码
[root@rac3 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

[root@rac4 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
复制代码
复制代码

 

5.破坏ocr内容

[root@rac4 bin]# dd if=/dev/zero of=/dev/raw/raw1 bs=1M count=120
dd: writing `/dev/raw/raw1': No space left on device
102+0 records in
101+0 records out

 

6.现在检查ocr一致性

[root@rac4 bin]# ./ocrcheck
PROT-601: Failed to initialize ocrcheck

[root@rac3 bin]# ./ocrcheck
PROT-601: Failed to initialize ocrcheck

 

7.使用cluvfy工具检查一致性

复制代码
复制代码
[root@rac3 cluvfy]# pwd
/opt/clusterware/cluvfy
[root@rac3 cluvfy]# ./runcluvfy.sh  comp ocr -n all

Verifying OCR integrity 
Unable to retrieve nodelist from Oracle clusterware.

Verification cannot proceed.
复制代码
复制代码

同样是检查失败

 

8.现在查看集群状态

[oracle@rac3 ~]$ crs_stat -t    --ocr被破坏,集群已经宕掉
CRS-0184: Cannot communicate with the CRS daemon.

[oracle@rac4 ~]$ crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.

 

9.使用import恢复OCR内容

[root@rac4 bin]# ./ocrconfig -import /home/oracle/ocr.exp 
[root@rac4 bin]#

 

10.再次检查OCR

复制代码
复制代码
[root@rac4 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded
复制代码
复制代码
复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded
复制代码
复制代码

 

11.检查通过,用cluvfy工具检查

复制代码
复制代码
[oracle@rac3 cluvfy]$ ./runcluvfy.sh  comp ocr -n all

Verifying OCR integrity 

Checking OCR integrity...

Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations.

Uniqueness check for OCR device passed.

Checking the version of OCR...
OCR of correct Version "2" exists.

Checking data integrity of OCR...
Data integrity check for OCR passed.

OCR integrity check passed.

Verification of OCR integrity was successful. 
复制代码
复制代码

 

12.启动CRS

复制代码
复制代码
[root@rac3 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly


[root@rac4 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly
复制代码
复制代码
复制代码
复制代码
[oracle@rac4 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    OFFLINE               
ora....C3.lsnr application    ONLINE    OFFLINE               
ora.rac3.gsd   application    ONLINE    OFFLINE               
ora.rac3.ons   application    ONLINE    OFFLINE               
ora.rac3.vip   application    ONLINE    OFFLINE               
ora....SM2.asm application    ONLINE    OFFLINE               
ora....C4.lsnr application    ONLINE    OFFLINE               
ora.rac4.gsd   application    ONLINE    OFFLINE               
ora.rac4.ons   application    ONLINE    OFFLINE               
ora.rac4.vip   application    ONLINE    OFFLINE               
ora.racdb.db   application    ONLINE    OFFLINE               
ora....b1.inst application    ONLINE    OFFLINE               
ora....b2.inst application    ONLINE    OFFLINE               
ora....rver.cs application    ONLINE    OFFLINE               
ora....db2.srv application    ONLINE    OFFLINE 
复制代码
复制代码

 

13.最后检查CRS的状态

复制代码
复制代码
[root@rac3 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

[root@rac4 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
复制代码
复制代码

 

二,移动OCR文件的位置

以下示例将演示如何把OCR从/dev/raw/raw1移动到/dev/raw/raw8上

1.首先查看是否有最近的OCR备份

复制代码
复制代码
[root@rac3 bin]# ./ocrconfig -showbackup

rac4     2015/01/23 17:54:53     /opt/ora10g/product/10.2.0/crs_1/cdata/crs

rac3     2014/10/10 16:51:14     /opt/ora10g/product/10.2.0/crs_1/cdata/crs

rac3     2014/10/10 12:51:11     /opt/ora10g/product/10.2.0/crs_1/cdata/crs

rac4     2015/01/23 17:54:53     /opt/ora10g/product/10.2.0/crs_1/cdata/crs

rac4     2015/01/23 17:54:53     /opt/ora10g/product/10.2.0/crs_1/cdata/crs
复制代码
复制代码

 

更改备份位置 ocrconfig -backuploc /oracle/backup/ocr

如果没有备份,可以立即执行一次导出作为备份

[root@rac3 bin]# ./ocrconfig -export /home/oracle/ocr.bak2 -s online

[root@rac3 bin]#

 

 

2.查看当前ocr配置

复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded
复制代码
复制代码

输出显示当前只有一个Primary OCR,位于 /dev/raw/raw1,没有Mirror OCR

 

 

3.因为现在只有一个OCR文件,位于/dev/raw/raw1,所以不能直接改变这个OCR的位置,
必须先添加镜像后再修改,否则会出现错误:

[root@rac3 bin]# ./ocrconfig -replace ocr /dev/raw/raw8
PROT-16: Internal Error

 

4.添加一个Mirror OCR

[root@rac3 bin]# ./ocrconfig -replace ocrmirror /dev/raw/raw7
[root@rac3 bin]# 

 

5.确认添加成功

复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded
         Device/File Name         : /dev/raw/raw7    --新添加的Mirror OCR
                                    Device/File integrity check succeeded

         Cluster registry integrity check succeeded
复制代码
复制代码

现在有两个OCR了,可以修改原来的Primary OCR了

 

6.修改Primary OCR为/dev/raw/raw8

 

[root@rac3 bin]# ./ocrconfig -replace ocr /dev/raw/raw8
[root@rac3 bin]# 

 

7.确认修改成功

复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :    2096364
         Used space (kbytes)      :       4340
         Available space (kbytes) :    2092024
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw8   --Primary OCR改变了
                                    Device/File integrity check succeeded
         Device/File Name         : /dev/raw/raw7
                                    Device/File integrity check succeeded

         Cluster registry integrity check succeeded
复制代码
复制代码

 

8.确认修改被同步到了其他节点

--在另一节点也能看到更新的信息

复制代码
复制代码
[root@rac4 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :    2096364
         Used space (kbytes)      :       4340
         Available space (kbytes) :    2092024
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw8
                                    Device/File integrity check succeeded
         Device/File Name         : /dev/raw/raw7
                                    Device/File integrity check succeeded

         Cluster registry integrity check succeeded
复制代码
复制代码

 

9.使用ocrconfig -replace命令后,所有节点上的/etc/oracle/ocr.loc文件内容也都自动同步了,
如果有点节点没有同步,也可以手工修改使其同步:

[root@rac4 bin]# more /etc/oracle/ocr.loc 
#Device/file /dev/raw/raw1 getting replaced by device /dev/raw/raw8 
ocrconfig_loc=/dev/raw/raw8
ocrmirrorconfig_loc=/dev/raw/raw7
local_only=false

 

 

三,解决PROT-22: Storage too small错误

现在我想改回原来的Primary OCR

[root@rac3 bin]# ./ocrconfig -replace ocr /dev/raw/raw1
PROT-22: Storage too small

查询metalink发现,这是一个10.2.0.1上的bug,要求ocrmirror设备的大小要比原始ocr设备大128M,详细描述可以参考:ID 317628.1。

 

那如何更改过来????  可参考 http://blog.itpub.net/14284241/viewspace-442842/
尝试直接修改/etc/oracle/orc.loc文件

1.查看目前的OCR配置

复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :    2096364
         Used space (kbytes)      :       4340
         Available space (kbytes) :    2092024
         ID                       :  945144556
         Device/File Name         : /dev/raw/raw8
                                    Device/File integrity check succeeded
         Device/File Name         : /dev/raw/raw7
                                    Device/File integrity check succeeded

         Cluster registry integrity check succeeded
复制代码
复制代码

 

2.对目前的OCR备份

[root@rac3 bin]# ./ocrconfig -export /home/oracle/ocr.bak3 -s online
[root@rac3 bin]# 

 

3.停掉所有节点的CRS

复制代码
复制代码
[root@rac3 bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources 
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.


[root@rac4 bin]# ./crsctl stop crs
Stopping resources.
Error while stopping resources. Possible cause: CRSD is down.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
复制代码
复制代码

 

4.手动修改所有节点的/etc/oracle/ocr.loc文件

复制代码
复制代码
[root@rac3 bin]# more /etc/oracle/ocr.loc 
#Device/file /dev/raw/raw1 getting replaced by device /dev/raw/raw8 
ocrconfig_loc=/dev/raw/raw8
ocrmirrorconfig_loc=/dev/raw/raw7
local_only=false
[root@rac3 bin]# vi /etc/oracle/ocr.loc
[root@rac3 bin]# more /etc/oracle/ocr.loc 
#Device/file /dev/raw/raw1 getting replaced by device /dev/raw/raw8 
ocrconfig_loc=/dev/raw/raw1
#ocrmirrorconfig_loc=/dev/raw/raw7
local_only=false


[root@rac4 bin]# more /etc/oracle/ocr.loc 
#Device/file /dev/raw/raw1 getting replaced by device /dev/raw/raw8 
ocrconfig_loc=/dev/raw/raw8
ocrmirrorconfig_loc=/dev/raw/raw7
local_only=false
[root@rac4 bin]# vi /etc/oracle/ocr.loc
[root@rac4 bin]# more /etc/oracle/ocr.loc 
#Device/file /dev/raw/raw1 getting replaced by device /dev/raw/raw8 
ocrconfig_loc=/dev/raw/raw1
#ocrmirrorconfig_loc=/dev/raw/raw7
local_only=false
复制代码
复制代码

 

5.检查一下ocr  

--可以看到ocr现在检查报错

[root@rac3 bin]# ./ocrcheck
PROT-601: Failed to initialize ocrcheck

 

6.导入之前备份的OCR数据

[root@rac3 bin]# ./ocrconfig -import /home/oracle/ocr.bak3

 

7.现在检查ocr 

--两个节点检查正常,且ocr盘实现已经改过来了

复制代码
复制代码
[root@rac3 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       : 1887132889
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded



[root@rac4 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     104344
         Used space (kbytes)      :       4340
         Available space (kbytes) :     100004
         ID                       : 1887132889
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded
复制代码
复制代码

 

8.启动crs

复制代码
复制代码
[root@rac3 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly


[root@rac4 bin]# ./crsctl start crs
Attempting to start CRS stack 
The CRS stack will be started shortly
复制代码
复制代码
复制代码
复制代码
[oracle@rac3 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac3        
ora....C3.lsnr application    ONLINE    ONLINE    rac3        
ora.rac3.gsd   application    ONLINE    ONLINE    rac3        
ora.rac3.ons   application    ONLINE    ONLINE    rac3        
ora.rac3.vip   application    ONLINE    ONLINE    rac3        
ora....SM2.asm application    ONLINE    ONLINE    rac4        
ora....C4.lsnr application    ONLINE    ONLINE    rac4        
ora.rac4.gsd   application    ONLINE    ONLINE    rac4        
ora.rac4.ons   application    ONLINE    ONLINE    rac4        
ora.rac4.vip   application    ONLINE    ONLINE    rac4        
ora.racdb.db   application    ONLINE    ONLINE    rac4        
ora....b1.inst application    ONLINE    ONLINE    rac3        
ora....b2.inst application    ONLINE    ONLINE    rac4        
ora....rver.cs application    ONLINE    ONLINE    rac3        
ora....db2.srv application    ONLINE    ONLINE    rac4
复制代码
复制代码

 

9.检查crs状态

复制代码
复制代码
[root@rac3 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy


[root@rac4 bin]# ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
复制代码
复制代码

至此我么把ocr盘通过手动的方式更改过来了,RAC正常。

 

--本文章 部分参考张晓明<<大话Oracle RAC>>及其他

 转:http://www.cnblogs.com/myrunning/p/4253696.html



本文转自 张冲andy 博客园博客,原文链接: http://www.cnblogs.com/andy6/p/5898015.html  ,如需转载请自行联系原作者


相关文章
|
7月前
|
存储 人工智能 文字识别
极速搭建基于人工智能的OCR识别应用
本场景将使用阿里云函数计算,Serverless 应用中心,带大家 1分钟 Serverless 极速部署基于人工智能的OCR识别应用。
65 1
|
3月前
|
机器学习/深度学习 人工智能 文字识别
印刷文字识别:技术与应用的新纪元
印刷文字识别:技术与应用的新纪元
|
9月前
|
文字识别
使用ModelScope社区搭建OCR应用
使用ModelScope社区搭建OCR应用
|
9月前
|
文字识别
使用ModelScope社区搭建表格OCR应用
使用ModelScope社区搭建表格OCR应用
|
10月前
|
机器学习/深度学习 人工智能 文字识别
深度学习应用篇-计算机视觉-OCR光学字符识别[7]:OCR综述、常用CRNN识别方法、DBNet、CTPN检测方法等、评估指标、应用场景
深度学习应用篇-计算机视觉-OCR光学字符识别[7]:OCR综述、常用CRNN识别方法、DBNet、CTPN检测方法等、评估指标、应用场景
深度学习应用篇-计算机视觉-OCR光学字符识别[7]:OCR综述、常用CRNN识别方法、DBNet、CTPN检测方法等、评估指标、应用场景
|
文字识别 小程序 Java
基于发票增值税OCR API设计自动识别应用系统,从此解放财务双手
增值税发票识别OCR API是一种基于光学字符识别(OCR)技术的API,旨在帮助用户自动识别和提取增值税发票中的文字信息。通过使用这个API,用户可以将增值税发票扫描或拍照后上传至云端,API将自动识别和提取发票中的关键信息,例如发票号码、日期、销售方名称、购买方名称等等。
286 0
基于发票增值税OCR API设计自动识别应用系统,从此解放财务双手
|
文字识别 计算机视觉 Python
使用ModelScope社区搭建OCR应用
简介: 本文介绍通过ModelScope来完成光学字符识别(OCR)这一应用,该应用使用两个模型: ● 文本检测(ocr_detection) ● 文本识别(ocr_recognition)
使用ModelScope社区搭建OCR应用
|
机器学习/深度学习 人工智能 编解码
HaaS轻应用(Python):基于HaaS-AI的文字识别
HaaS 即 Hardware as a Service,它是加速AIoT开发者创新的一个积木平台.
HaaS轻应用(Python):基于HaaS-AI的文字识别
|
文字识别
OCR:实现信息结构化提取 助力信息数字化管理 ——基于OCR的机动车销售统一发票识别提取自动化应用案例
为降低信息提取成本、优化业务处理效率,深源恒际依托自身在OCR技术上的积累,打造了机动车销售统一发票信息识别提取自动化解决方案,自动检测、识别、提取发票信息,并根据实际应用需求输出结构化文本,由计算机替代人工作业,高效、准确地完成信息提取。
|
机器学习/深度学习 算法 文字识别
OCR如何读取皱巴巴的文件?深度学习在文档图像形变矫正的应用详解
OCR作为智能审核的重要环节,其识别准确率影响着最终审核效果的好坏,而来自扫描仪、智能手机的文档图像多存在卷曲、折叠。本文旨在利用深度学习算法对文档图像的形变进行矫正,从而提高OCR识别效果,为智能审核保驾护航。
2593 0

热门文章

最新文章