RAC 11.2.0.3 管理OCR文件

最新推荐文章于 2022-07-08 09:50:39 发布
最新推荐文章于 2022-07-08 09:50:39 发布
阅读量130 收藏
点赞数
文章标签： 数据库 运维
1，确认Clusterware版本

[grid@node1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]

2，确认OCR引导文件的信息

[grid@node1 ~]$ cat /etc/oracle/ocr.loc
ocrconfig_loc=+ORCVOTE
local_only=FALSE

3，添加OCR文件到磁盘组+ARCH
[grid@node1 ~]$ ocrconfig -add +ARCH
PROT-20: Insufficient permission to proceed. Require privileged user

需要root权限才可以执行
[grid@node1 ~]$ su -
Password:
[root@node1 ~]#
[root@node1 ~]# ocrconfig -add +ARCH

生成了镜像mirror OCR文件
[root@node1 ~]# cat /etc/oracle/ocr.loc
#Device/file  getting replaced by device +ARCH
ocrconfig_loc=+ORCVOTE
ocrmirrorconfig_loc=+ARCH       
local_only=false[root@node1 ~]# 

再次添加OCR文件到磁盘组+DATA
[root@node1 ~]# ocrconfig -add +DATA
[root@node1 ~]#
[root@node1 ~]# cat /etc/oracle/ocr.loc
#Device/file  getting replaced by device +DATA
ocrconfig_loc=+ORCVOTE
ocrmirrorconfig_loc=+ARCH
ocrconfig_loc3=+DATA
local_only=false[root@node1 ~]# 

4，检查OCR文件
[root@node1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2872
         Available space (kbytes) :     259248
         ID                       :  735735915
         Device/File Name         :   +ORCVOTE
                                    Device/File integrity check succeeded
         Device/File Name         :      +ARCH
                                    Device/File integrity check succeeded
         Device/File Name         :      +DATA
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check succeeded

5，删除OCR文件
[root@node1 ~]# ocrconfig -delete +DATA
[root@node1 ~]#
[root@node1 ~]# cat /etc/oracle/ocr.loc
#Device/file +DATA being deleted
ocrconfig_loc=+ORCVOTE
ocrmirrorconfig_loc=+ARCH
local_only=false[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# ocrconfig -delete +ARCH
[root@node1 ~]#
[root@node1 ~]# cat /etc/oracle/ocr.loc
#Device/file +ARCH being deleted
ocrconfig_loc=+ORCVOTE
local_only=false

6，验证OCR完整性
[root@node1 ~]# cluvfy comp ocr -n all -verbose
You must NOT be logged in as root (uid=0) when running /g01/grid/app/11.2.0/grid/bin/cluvfy.

root用户不被允许，切换到grid用户
[root@node1 ~]# su - grid
[grid@node1 ~]$ cluvfy comp ocr -n all -verbose

Verifying OCR integrity

Checking OCR integrity...

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


ASM Running check passed. ASM is running on all specified nodes

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful


Disk group for ocr location "+ORCVOTE" available on all the nodes


NOTE:
This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Verification of OCR integrity was successful. 

7，导入和导出OCR文件
1，在所有节点关闭cluster，在节点node1,node2分别执行
[root@node1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'node1'
CRS-2673: Attempting to stop 'ora.ORCVOTE.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.prod.db' on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'node1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'node1'
CRS-2677: Stop of 'ora.scan1.vip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'node2'
CRS-2676: Start of 'ora.scan1.vip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'node2'
CRS-2677: Stop of 'ora.prod.db' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'node2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.ARCH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'node2'
CRS-2676: Start of 'ora.oc4j' on 'node2' succeeded
CRS-2677: Stop of 'ora.ORCVOTE.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node1'
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'node1'
CRS-2677: Stop of 'ora.crf' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node1'
CRS-2677: Stop of 'ora.gipcd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node1'
CRS-2677: Stop of 'ora.gpnpd' on 'node1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@node2 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.crsd' on 'node2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'node2'
CRS-2673: Attempting to stop 'ora.cvu' on 'node2'
CRS-2673: Attempting to stop 'ora.ORCVOTE.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.prod.db' on 'node2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'node2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'node2'
CRS-2677: Stop of 'ora.node1.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.cvu' on 'node2' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'node2'
CRS-2677: Stop of 'ora.scan1.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.node2.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.prod.db' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node2'
CRS-2677: Stop of 'ora.ARCH.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'node2' succeeded
CRS-2677: Stop of 'ora.ORCVOTE.dg' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node2'
CRS-2677: Stop of 'ora.ons' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node2'
CRS-2677: Stop of 'ora.net1.network' on 'node2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node2' has completed
CRS-2677: Stop of 'ora.crsd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node2'
CRS-2673: Attempting to stop 'ora.evmd' on 'node2'
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node2'
CRS-2677: Stop of 'ora.evmd' on 'node2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'node2' succeeded
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node2'
CRS-2677: Stop of 'ora.ctssd' on 'node2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node2'
CRS-2677: Stop of 'ora.cssd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'node2'
CRS-2677: Stop of 'ora.crf' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node2'
CRS-2677: Stop of 'ora.gipcd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node2'
CRS-2677: Stop of 'ora.gpnpd' on 'node2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node2' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@node2 ~]# ocrconfig -export /home/grid/ocr_export
[root@node2 ~]# ls -al /home/grid
total 164
drwx------ 5 grid oinstall  4096 Jul  2 05:51 .
drwxr-xr-x 4 root root      4096 Jun 11 01:52 ..
-rw------- 1 grid oinstall  5416 Jul  2 02:40 .bash_history
-rw-r--r-- 1 grid oinstall    33 Jun 11 01:52 .bash_logout
-rw-r--r-- 1 grid oinstall   348 Jun 11 23:50 .bash_profile
-rw-r--r-- 1 grid oinstall   124 Jun 11 01:52 .bashrc
-rw-r--r-- 1 grid oinstall   515 Jun 11 01:52 .emacs
drwxr-xr-x 4 grid oinstall  4096 Jun 11 01:52 .mozilla
-rw------- 1 root root     98621 Jul  2 05:51 ocr_export
drwxrwxr-x 3 grid oinstall  4096 Jun 11 10:49 oradiag_grid
drwxr-xr-x 2 grid oinstall  4096 Jun 11 10:30 .ssh
-rw-r--r-- 1 grid oinstall  3931 Jun 12 02:48 t.txt
-rw------- 1 grid oinstall  6845 Jul  1 23:54 .viminfo

2,导入OCR文件
在节点node2下以root用户独占模式启动cluster
[root@node2 ~]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'node2'
CRS-2676: Start of 'ora.mdnsd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node2'
CRS-2676: Start of 'ora.gpnpd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node2'
CRS-2672: Attempting to start 'ora.gipcd' on 'node2'
CRS-2676: Start of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node2'
CRS-2672: Attempting to start 'ora.diskmon' on 'node2'
CRS-2676: Start of 'ora.diskmon' on 'node2' succeeded
CRS-2676: Start of 'ora.cssd' on 'node2' succeeded
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'node2'
CRS-2672: Attempting to start 'ora.ctssd' on 'node2'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node2'
CRS-2676: Start of 'ora.asm' on 'node2' succeeded

导入OCR文件
[root@node2 ~]# ocrconfig -import /home/grid/ocr_export

再次验证OCR完整性
[root@node2 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2840
         Available space (kbytes) :     259280
         ID                       :  684718087
         Device/File Name         :   +ORCVOTE
                                    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

关闭节点node2的独占启动模式
[root@node2 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node2'
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node2'
CRS-2677: Stop of 'ora.mdnsd' on 'node2' succeeded
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node2'
CRS-2677: Stop of 'ora.ctssd' on 'node2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node2'
CRS-2677: Stop of 'ora.cssd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node2'
CRS-2677: Stop of 'ora.gipcd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node2'
CRS-2677: Stop of 'ora.gpnpd' on 'node2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node2' has completed
CRS-4133: Oracle High Availability Services has been stopped.

重新启动所有节点的clusterware，节点node1，node2分别执行
[root@node1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

[root@node2 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

这个过程需要些时间，可以用crsctl status res -t来观察其状态
[root@node1 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.DATA.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.ORCVOTE.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.asm
               ONLINE  ONLINE       node1                    Started            
               ONLINE  ONLINE       node2                    Started            
ora.gsd
               OFFLINE OFFLINE      node1                                       
               OFFLINE OFFLINE      node2                                       
ora.net1.network
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.ons
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node2                                       
ora.cvu
      1        ONLINE  ONLINE       node2                                       
ora.node1.vip
      1        ONLINE  ONLINE       node1                                       
ora.node2.vip
      1        ONLINE  ONLINE       node2                                       
ora.oc4j
      1        ONLINE  ONLINE       node2                                       
ora.prod.db
      1        ONLINE  ONLINE       node1                    Open               
      2        ONLINE  ONLINE       node2                    Open               
ora.scan1.vip
      1        ONLINE  ONLINE       node2        

[root@node2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.DATA.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.ORCVOTE.dg
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.asm
               ONLINE  ONLINE       node1                    Started            
               ONLINE  ONLINE       node2                    Started            
ora.gsd
               OFFLINE OFFLINE      node1                                       
               OFFLINE OFFLINE      node2                                       
ora.net1.network
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
ora.ons
               ONLINE  ONLINE       node1                                       
               ONLINE  ONLINE       node2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node2                                       
ora.cvu
      1        ONLINE  ONLINE       node2                                       
ora.node1.vip
      1        ONLINE  ONLINE       node1                                       
ora.node2.vip
      1        ONLINE  ONLINE       node2                                       
ora.oc4j
      1        ONLINE  ONLINE       node2                                       
ora.prod.db
      1        ONLINE  ONLINE       node1                    Open               
      2        ONLINE  ONLINE       node2                    Open               
ora.scan1.vip
      1        ONLINE  ONLINE       node2        


在节点node1再次执行cluvfy来检查OCR的文件完整性
[grid@node1 ~]$ cluvfy comp ocr -n all -verbose

Verifying OCR integrity

Checking OCR integrity...

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


ASM Running check passed. ASM is running on all specified nodes

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful


Disk group for ocr location "+ORCVOTE" available on all the nodes


NOTE:
This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Verification of OCR integrity was successful.

8，OCRDUMP以ASCII方式打印OCR内容
[grid@node1 ~]$ ocrdump /home/grid/ocr_dump.log -xml
[grid@node1 ~]$ more /home/grid/ocr_dump.log


07/02/2014 06:13:59
/g01/grid/app/11.2.0/grid/bin/ocrdump.bin /home/grid/ocr_dump.log -xml


SYSTEM
UNDEF

PROCR_ALL_ACCESS
PROCR_READ
PROCR_READ
root
root


SYSTEM.version
UB4 (10)

PROCR_ALL_ACCESS
PROCR_READ
PROCR_READ
root
root


SYSTEM.version.activeversion
ORATEXT

PROCR_ALL_ACCESS
PROCR_READ
PROCR_READ 
root
root
……….
……….

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29047826/viewspace-1210608/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29047826/viewspace-1210608/

cuibaodun6837
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle 11.2.0.3 RAC 安装 手册
04-20
Oracle 11.2.0.3 RAC (Real Application Clusters) 是Oracle数据库的一个重要特性，它允许在多台服务器上共享同一个数据库实例，从而提供了高可用性和可伸缩性。RAC使得数据库可以在集群环境中运行，当一台服务器...
Oracle 11.2.0.3 RAC 重建 OCR 和 Voting Disk 案例
最新发布
04-20
Oracle 11.2.0.3 RAC (Real Application Clusters) 是Oracle数据库的一个重要版本，它提供了高可用性和可伸缩性，允许数据库在多台服务器上共享和处理数据。在RAC环境中，OCR（Oracle Cluster Registry）和Voting ...
oracle rac _oifcfg iflist -p -n,RAC维护命令 – 专业Oracle数据库恢复，或许是您恢复数据的最后机会@phone:13429648788 - 专业Oracle数据...
weixin_39556474的博客
04-05 249
一、节点层(olsnodes)rac1-> olsnodes -helpUsage: olsnodes [-n] [-p] [-i] [ | -l] [-g] [-v]where-n print node number with the node name-p print private interconnect name with the node name-i print virtual...
oracle 11g r2 rac修改ocr及votedisk所在磁盘组位置
数据矿工的博客
07-08 349
替换的OCR磁盘组
ORACLE之RAC集群常用命令
XiaoHG_CSDN的博客
02-20 680
ORACLE之RAC集群常用命令 RAC的守护进程 /etc/init.d/init.ohasd RAC的日常管理命令 1）节点层 2）网络层 3）集群层 4）应用层 节点层 olsnodes -n -p -i --这个命令用来显示集群点列表 检查集群节点 [grid@rac1 ~]$ olsnodes -n 网络层 oifcfg --查询，定义和修改Oracle 集群需要的网卡属性，这些属性包括网卡的网段地址，子网掩码，接口类型等。 oifcfg getif oifcfg getif -if eth0 集
OCR和VOTE DISK的一些操作
文档搬运工
03-18 909
RDBMS 11.2.0.4 参考文档： OCR/Vote disk 维护操作: (添加/删除/替换/移动) (Doc ID 1674859.1) CRS-4258: Addition and Deletion of Voting Files are not Allowed Because the Voting Files are on ASM in 11gR2 (Doc ID 1060146.1) 1 查看当前ocr的备份 ocrconfig -showbackup ocrconfig -ma
oracle ocr日志,oracle_OCR自动备份文件撑满GRID目录
weixin_39687881的博客
04-02 161
现在安装新系统，一般是通过克隆现有的patch的环境，进行安装，因为这样可以在安装完成后，不用再对系统一个一个的安装需要的one-off的patch，这样安装很快也很方便，针对上面所说，可能是在克隆过程中跑root.sh出现问题；在MOS上有对应的BUG，ID1191067.1，BUG7313884，文档上介绍fixed版本11.2.0.2，可是我的系统是11.2.0.4，文档内容介绍如下：Due...
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
10-08
本案例重点讲述了如何利用RMAN（Recovery Manager）工具进行Oracle 11.2.0.3单实例到11gR2 RAC的异机恢复操作。这一过程涉及多个关键步骤，包括数据备份、目标环境准备、恢复和配置调整。 首先，RMAN是Oracle数据库...
一步一步在Linux上部署11.2.0.3 RAC+Dataguard.rar
11-30
在部署过程中，"一步一步在Linux上部署11.2.0.3 RAC+Dataguard.pdf"文档将提供详细的指导，包括每个步骤的命令行操作、配置文件修改以及可能遇到的问题和解决方案。这份文档对于初学者和经验丰富的管理员都是宝贵的...
大牛出手Oracle 11.2.0.3 RAC 基于生产环境安装手册
10-03
Oracle 11.2.0.3 Real Application Clusters (RAC) 是Oracle数据库的一个重要特性，它提供了高可用性和可扩展性，使得多个数据库实例能够共享同一个物理数据库，从而在集群环境中实现故障切换和负载均衡。...
给ocr增加ocrmirror时遇到的问题总结
clt3617的博客
03-19 263
原本以为会很顺利，没想到遇到了几个问题，简单总结一下...[@more@][oracle@node1 bin]$ ./ocrconfigName: ocrconfig - Configuration tool fo...
【DB笔试面试720】在Oracle中，OCR备份恢复有哪几种？
小麦苗DBA宝典
12-31 422
♣题目部分在Oracle中，OCR备份恢复有哪几种？ ♣答案部分与Oracle数据库的备份恢复相似，OCR的备份也有物理备份和逻辑备份，因此有两种备份方式和两种恢复方式。物理备份...
RAC环境下的备份与恢复（一）
weixin_33888907的博客
12-13 157
  本节中将演示下rac环境下的数据的备份和完全恢复，rac的备份和恢复同单实例数据库对比，只是在处理归档日志上有些扩展，一般来讲，可以将归档日志存储在ASM磁盘组中，或者存储在集群文件系统上，NFS以及本地文件系统上，当归档日志存储在ASM，集群文件系统或者NFS上的时候，rac备份和恢复和单实例下的操作基本一致，下面的场景归档日志存储在ASM上！ 一：查看rac归档的设置 ...
11204 ASM 在线存储迁移。
weixin_34041003的博客
12-12 168
2.1停止数据库 shutdown immediate 2.2 扫描磁盘 echo 1 > /sys/class/fc_host/host3/issue_lip echo 1 > /sys/class/fc_host/host4/issue_lip 3，更改磁盘属性 chown oracle:oinstall /dev/mapp...
RAC 的维护
qq_23967911的博客
08-02 1123
节点层 olsnodes 网络层 oifcfg 集群层 crsctl、ocrcheck、ocrdump、ocrconfig 应用层 srvctl、onsctl、crs_stat       节点层（olsnodes） $ olsnodes -n  显示节点编号 rac1    1 rac2    2 [oracle@rac1 admin]$ olsnodes -p  显示私有
RAC维护命令
huyangg的专栏
04-05 732
一、节点层（olsnodes） rac1-> olsnodes -help Usage: olsnodes [-n] [-p] [-i] [ | -l] [-g] [-v] where -n print node number with the node name -p print private interconnect name with the node name -i prin
RAC 移动 OCR
weixin_33866037的博客
01-19 71
1、查看是否有OCR备份 # ocrconfig -showbackup 如果没有就备份一份 # ocrconfig -export /oracle/bak/ocr/ocr_11291433_exp.ocr -s online 2、查看当前配置 [root@r3 ocr]# ocrcheck Status of Oracle Cluster Registry is as follows...
RAC上ocr和voting disk维护操作和需求1
Super菜的专栏
11-16 2679
部分转自http://www.lunar2013.com/ Oracle从10.1开始推出了自己真正意义的集群软件（9i和9i之前的版本，Oracle只有集群数据库，集群的存储和网络是由第三方厂商维护的，比如IBM的HACMP，HPUX的MC SERVICE GUARD /OA，SUN的suncluster，True64的Trucluster，linux就用ocfs和check-timer等等）
当OCR备份位于ASM磁盘组中时，如何恢复基于ASM的OCR? (Doc ID 2569847.1)
u010692693的专栏
11-20 690
How to Restore ASM Based OCR when OCR backup is located in ASM diskgroup? (Doc ID 2569847.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this documen...
华为云ECS ORACLE RAC 11.2.0.4 的安装指导
03-29
"华为云ECS ORACLE RAC 11.2.0.4 安装...本指南详尽地介绍了在华为云ECS上部署Oracle RAC 11.2.0.4的每一步，对于数据库管理员和系统运维人员来说，是一份宝贵的参考资料，有助于在云环境中顺利实施Oracle RAC集群。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值