使用备份恢复ocr和votedisk

最新推荐文章于 2021-07-25 06:01:36 发布
最新推荐文章于 2021-07-25 06:01:36 发布
阅读量284 收藏
点赞数
原文链接：https://blog.csdn.net/rhys_oracle/article/details/22112133
版权
  •   11Gr2RAC使用备份恢复ocr和votedisk

                                          

1）检查环境，准备工作

[root@rac2 bin]# ./crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.FRA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.asm

               ONLINE  ONLINE       rac1                     Started             

               ONLINE  ONLINE       rac2                     Started             

ora.gsd

               OFFLINE OFFLINE      rac1                                         

               OFFLINE OFFLINE      rac2                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.ons

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.registry.acfs

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac2                                         

ora.cvu

      1        ONLINE  ONLINE       rac2                                         

ora.oc4j

      1        ONLINE  ONLINE       rac2                                         

ora.orcl.db

      1        ONLINE  ONLINE       rac1                     Open                

      2        ONLINE  ONLINE       rac2                     Open                

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                         

ora.rac2.vip

      1        ONLINE  ONLINE       rac2                                         

ora.scan1.vip

      1        ONLINE  ONLINE       rac2                                         

[root@rac2 bin]# ./ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3112

         Available space (kbytes) :     259008

         ID                       :  257970053

         Device/File Name         : +CRSVOTEDISK

                                    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@rac2 bin]# ./crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   1c33b77017d34f94bf17db020e40edc0 (/dev/raw/raw1) [CRSVOTEDISK]

 2. ONLINE   1f6c69dab3344fa6bf605ab2a7601948 (/dev/raw/raw2) [CRSVOTEDISK]

 3. ONLINE   8273e16873b94ff3bf213b5597027cd1 (/dev/raw/raw3) [CRSVOTEDISK]

Located 3 voting disk(s).

资源正常，手工备份一下ocr

[root@rac2 bin]# ./ocrconfig -manualbackup

rac2     2016/05/19 03:41:38     /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160519_034138.ocr

rac2     2016/05/16 07:35:30     /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160516_073530.ocr

[root@rac2 bin]# ./ocrconfig -showbackup

PROT-24: Auto backups for the Oracle Cluster Registry are not available

 

rac2     2016/05/19 03:41:38     /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160519_034138.ocr

rac2     2016/05/16 07:35:30     /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160516_073530.ocr

 

创建一份参数文件，因为asm实例的启动参数放在ocr上，可以用show parameter spfile查看

[grid@rac2 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 19 03:45:45 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> create pfile='/tmp/pfile1.ora' from spfile; 

File created.

模拟故障

使用dd命令破坏磁盘

[root@rac2 bin]# dd if=/dev/zero of=/dev/raw/raw3 bs=1024 count=1000

[root@rac2 bin]# dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=1000

[root@rac2 bin]# dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1000

关闭两节点

[root@rac2 bin]# ./crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2'

CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac2'

CRS-2673: Attempting to stop 'ora.orcl.db' on 'rac2'

CRS-2673: Attempting to stop 'ora.oc4j' on 'rac2'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2'

CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.cvu' on 'rac1'

CRS-2676: Start of 'ora.cvu' on 'rac1' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'

CRS-2677: Stop of 'ora.registry.acfs' on 'rac2' succeeded

CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.rac2.vip' on 'rac1'

CRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac1'

CRS-2676: Start of 'ora.rac2.vip' on 'rac1' succeeded

CRS-2676: Start of 'ora.scan1.vip' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2677: Stop of 'ora.orcl.db' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'

CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac2'

CRS-2677: Stop of 'ora.FRA.dg' on 'rac2' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac2'

CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded

CRS-2677: Stop of 'ora.oc4j' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.oc4j' on 'rac1'

CRS-2676: Start of 'ora.oc4j' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'rac2'

CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'

CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'

CRS-2673: Attempting to stop 'ora.asm' on 'rac2'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac2'

CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'

CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'

CRS-2677: Stop of 'ora.drivers.acfs' on 'rac2' succeeded

CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'rac2'

CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'

CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'

CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed

CRS-4133: Oracle High Availability Services has been stopped.

由于要使用独占模式所以将rac2关机了，或者停止ohas，下面操作在节点1上完成（也可以使用节点2）

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl start crs

CRS-4640: Oracle High Availability Services is already active

CRS-4000: Command Start failed, or completed with errors.

查看ocr状态

[grid@rac1 rac1]$ ocrcheck

PROT-602: Failed to retrieve data from the cluster registry

PROC-26: Error while accessing the physical storage

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Synchronization Service

查看votedisk

[root@rac1 bin]# ./crsctl query css votedisk

Located 0 voting disk(s).

强制停止集群，以exclusive模式启动

[root@rac1 bin]# ./crsctl stop crs -f

CRS-2797: Shutdown is already in progress for 'rac1', waiting for it to complete

CRS-2797: Shutdown is already in progress for 'rac1', waiting for it to complete

CRS-4133: Oracle High Availability Services has been stopped.

[root@rac1 bin]# ./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-2672: Attempting to start 'ora.drivers.acfs' on 'rac1'

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.drivers.acfs' on 'rac1' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2679: Attempting to clean 'ora.asm' on 'rac1'

CRS-2681: Clean of 'ora.asm' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac1'

CRS-2676: Start of 'ora.asm' on 'rac1' succeeded

打开asm实例创建新磁盘组OCRA

[grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 19 08:13:42 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> shutdown immediate;

ORA-15100: invalid or missing diskgroup name

ORA-15100: invalid or missing diskgroup name

ASM instance shutdown

SQL> startup pfile='/tmp/pfile.ora';  

ASM instance started

SQL> startup pfile='/tmp/pfile.ora';    #pfile文件注意修改asm_diskstring,我的磁盘搜索路径是/dev/raw/*

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size                  2260728 bytes

Variable Size            1108320520 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>  create diskgroup OCRA normal redundancy disk '/dev/raw/raw1','/dev/raw/raw2', '/dev/raw/raw3'

  2  attribute 'compatible.asm'='11.2.0.0.0', 'compatible.rdbms'='11.2.0.0.0';

Diskgroup created.

SQL> create spfile='+OCRA' from pfile='/tmp/pfile.ora';

File created.

SQL> exit 

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

[grid@rac1 ~]$ exit

logout

[root@rac1 bin]# ./ocrconfig -restore /u01/app/

11.2.0/       grid/         oraInventory/ 

[root@rac1 bin]# ./ocrconfig -restore /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160519_073859.ocr 

PROT-35: The configured OCR locations are not accessible.

[root@rac1 bin]# vi /etc/oracle/ocr.loc

ocrconfig_loc=+OCR

local_only=FALSE

/*

/tmp/pfile.ora内容

+ASM1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value

+ASM1.asm_diskgroups='DATA'#Manual Mount

+ASM2.asm_diskgroups='DATA'#Manual Mount

*.asm_diskstring='/dev/raw/*'

*.asm_power_limit=1

*.diagnostic_dest='/u01/app/grid'

*.instance_type='asm'

*.large_pool_size=12M

*.remote_login_passwordfile='EXCLUSIVE'

*/

 

使用备份复原ocr

[root@rac1 bin]# ./ocrconfig -restore /u01/app/

11.2.0/       grid/         oraInventory/ 

[root@rac1 bin]# ./ocrconfig -restore /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160519_073859.ocr 

PROT-35: The configured OCR locations are not accessible.

[root@rac1 bin]# vi /etc/oracle/ocr.loc

ocrconfig_loc=+OCR

local_only=FALSE

将+OCR改为+OCRA

[root@rac1 bin]# ./ocrconfig -restore /u01/app/11.2.0/grid/cdata/rac-cluster/backup_20160519_073859.ocr 

[root@rac1 bin]# ./crsctl replace votedisk +OCRA

Successful addition of voting disk 050efccd74244f05bfa6bf3978895a85.

Successful addition of voting disk 42b911116d5a4fe1bfc26382d48d16da.

Successful addition of voting disk 5d6a633e8f594f8dbff3bdd795671613.

Successfully replaced voting disk group with +OCRA.

CRS-4266: Voting file(s) successfully replaced

[root@rac1 bin]# ./ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3408

         Available space (kbytes) :     258712

         ID                       : 1954953290

         Device/File Name         :      +OCRA

                                    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 bin]# ./crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   050efccd74244f05bfa6bf3978895a85 (/dev/raw/raw1) [OCRA]

 2. ONLINE   42b911116d5a4fe1bfc26382d48d16da (/dev/raw/raw2) [OCRA]

 3. ONLINE   5d6a633e8f594f8dbff3bdd795671613 (/dev/raw/raw3) [OCRA]

Located 3 voting disk(s).

退出独占模式

[root@rac1 bin]# ./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.drivers.acfs' 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.drivers.acfs' 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 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

[root@rac1 bin]# su - grid

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[grid@rac1 ~]$ crsctl query css votedisk

[grid@rac1 ~]$ crsctl query css votedisk

[grid@rac1 ~]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3408

         Available space (kbytes) :     258712

         ID                       : 1954953290

         Device/File Name         :      +OCRA

                                    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 bypassed due to non-privileged user

 [grid@rac1 ~]$ crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   050efccd74244f05bfa6bf3978895a85 (/dev/raw/raw1) [OCRA]

 2. ONLINE   42b911116d5a4fe1bfc26382d48d16da (/dev/raw/raw2) [OCRA]

 3. ONLINE   5d6a633e8f594f8dbff3bdd795671613 (/dev/raw/raw3) [OCRA]

Located 3 voting disk(s).

启动另一个节点

[grid@rac1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.FRA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.OCR.dg

               ONLINE  OFFLINE      rac1                                         

               OFFLINE OFFLINE      rac2                                         

ora.asm

               ONLINE  ONLINE       rac1                     Started             

               ONLINE  ONLINE       rac2                     Started             

ora.gsd

               OFFLINE OFFLINE      rac1                                         

               OFFLINE OFFLINE      rac2                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.ons

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.registry.acfs

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                         

ora.cvu

      1        ONLINE  ONLINE       rac1                                         

ora.oc4j

      1        ONLINE  ONLINE       rac1                                         

ora.orcl.db

      1        ONLINE  ONLINE       rac1                     Open                

      2        ONLINE  ONLINE       rac2                     Open                

ora.orcl.ssss.svc

      1        ONLINE  ONLINE       rac1                                         

      2        ONLINE  ONLINE       rac2                                         

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                         

ora.rac2.vip

      1        ONLINE  ONLINE       rac2                                         

ora.scan1.vip

      1        ONLINE  ONLINE       rac1

————————————————

原文链接：https://blog.csdn.net/huoshuyinhua/article/details/51455462

执笔画情ora
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
通过自动备份重建ocr以及votedisk
whb234174124的博客
01-10 734
查看ocr和votedisk状态 [grid@rac1 bin]$ ocrcheck Status of Oracle Cluster Registry is as follows :          Version                  :          3          Total space (kbytes)     :     262120          Use...
11GR2RAC丢失OCR和CONTROLFILE重建恢复过程
cuanhuai4935的博客
05-17 140
今天准备用自己的rac虚拟机做点实验的，可是虚拟机拉起来时，频频报错，估计好久不用了（前一阵子有厂商来推销虚拟化全在那上做测试了），挨个检查发现是OCR出故障了，没办法重建下吧，顺便记录下重建的过程 1.使用...
11Gr2RAC使用备份恢复ocr和votedisk
huoshuyinhua的专栏
05-19 3365
11Gr2RAC使用备份恢复ocr和votedisk                                            环境： 2节点rac 软件版本：oracle 11.2.0.4 说明：使用备份恢复ocr和votedisk，在生产库中，系统是自动备份的。 1）检查环境，准备工作 [root@rac2 bin]# ./crsctl stat res -t
ORA-15040 ora-15017ASM磁盘无法挂载故障处理
开源世界
05-10 1862
测试环境突然一个节点的数据库无法启动，报错很清楚，找不到控制文件，而控制文件在ASM上，第一个节点正常，下面是处理流程。 数据库启动报错 SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2684354560 bytes Fixed Size 8624312 bytes Var
计算机中丢失oraocr,11GR2RAC丢失OCR和CONTROLFILE重建恢复过程
weixin_35715366的博客
07-25 446
今天准备用自己的rac虚拟机做点实验的，可是虚拟机拉起来时，频频报错，估计好久不用了(前一阵子有厂商来推销虚拟化全在那上做测试了)，挨个检查发现是OCR出故障了，没办法重建下吧，顺便记录下重建的过程1.使用orccheck命令报错[root@rac1 ~]#ocrcheckPROT-602: Failedtoretrieve datafromthe cluster registryPROC-26:...
OCR备份和恢复
08-30
OCR备份和恢复
OCR_磁盘和Votedisk磁盘恢复
12-21
Oracle 11gr2 RAC OCR磁盘和Votedisk磁盘恢复
labview视觉助手VBAI OCR和OCV
最新发布
02-19
labview视觉助手VBAI OCR和OCV
Oracle12c RAC Restore Recover 备份恢复
04-18
Oracle12c RAC Restore Recover 备份恢复 从集群数据库备份、OCR备份、OCR恢复、数据库多种场景下恢复都做了讲解 适合Oracle初学者，可根据文档内脚本命令，跟着教学，逐步掌握Oracle12C集群数据库备份和恢复等知识...
oracle备份文件恢复ocr和voting
05-10
通过OCR备份文件恢复OCR和voting文件 DocMadeByOldunix
安装oracle11g ocr分配,oracle 11g rac 更换ocr磁盘
weixin_34236334的博客
04-02 309
环境描述操作系统：CentOS release 6.7 (Final)Clusterware版本：Oracle Clusterware active version on the cluster is [11.2.0.4.0]查看vote磁盘相关信息：$ crsctl query css votedisk## STATE File Universal Id F...
mysql和ocrcle_oracle 12.1 RAC的ocr磁盘组异常恢复
weixin_33038783的博客
01-19 186
在11.2或者12.1的RAC中,ocr和votedisk可以放到asm中,而很多人安装系统把ocr和votedisk放到一个单独的asm 磁盘组里面,但是如果这个磁盘组坏了,而数据所在的磁盘组是好的,这个时候该怎么恢复呢？这里的恢复分两种情况，一种是有ocr备份的恢复,另外一种是无ocr备份的恢复。但是在一般情况下ocr是每4个小时自动备份一份，因此大部分的系统中都会有ocr的备份。本blog主...
Oracle RAC OCR 磁盘组异常恢复
Aamir 的专栏
06-19 4516
在11.2或者12.1的RAC中,ocr和votedisk可以放到asm中,而很多人安装系统把ocr和votedisk放到一个单独的asm 磁盘组里面,但是如果这个磁盘组坏了,而数据所在的磁盘组是好的,这个时候该怎么恢复呢？这里的恢复分两种情况，一种是有ocr备份的恢复,另外一种是无ocr备份的恢复。但是在一般情况下ocr是每4个小时自动备份一份，因此大部分的系统中都会有ocr的备份。本blog主
11gR2 RAC 独占模式replace votedisk遭遇PROC-26，restore ocr遭遇CRS-4000、PROT-35
Mr.pan felix的专栏
08-12 3467
原文链接：http://blog.itpub.net/23135684/viewspace-748816/ 11gR2 RAC系统的存储数据完全丢失，所有节点的软件都安装在本地磁盘中，本地磁盘保留了OCR的备份，下面讨论通过replace votedisk和restore ocr的方式恢复Clusterware的正常运行：   1.启动CRS到独占模式。 [root@rac1 bin]#./...
Voting Disk和OCR基础、管理、备份和恢复
Martin201609的博客
09-13 5936
Voting Disk和OCR基础、管理、备份和恢复 Voting Disk介绍 voting disk管理 OCR管理 voting disk备份 voting disk恢复 OCR备份 OCR恢复
oracle crs 命令,ORACLE RAC CRSCTL 命令使用 及 执行的用户
weixin_39611413的博客
04-03 668
oracle rac crsctl命令使用查看crs资源状态[grid@db1 ~]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora.DATA.dg ora....up.type ONLINE ONLINE db1ora.FRA...
11g r2 模拟OCR和voting disk不可用，完整恢复过程，以及一些注意事项
wonder_2012的专栏
07-18 7265
环境：RHEL5.8 RAC 11.2.0.3.0 1：查看ORC和voting disk信息： In 11g Release 2 your voting disk data is automatically backed up in the OCR whenever there is a configuration change. 所以恢复时恢复备份OCR即可，这里和10g是不同的，不
OCR和votedisk备份与还原
张小秋博客
05-26 970
—1.执行OCR文件的手动备份[root@rac1 ~]# ocrconfig -manualbackup[root@rac1 ~]# ocrconfig -manualbackuprac1 2016/01/21 19:03:06 /g01/app/11.2.0/grid/cdata/rac-cluster/backup_20160121_190306.ocrrac1 201
备份及恢复votedisk
loryliu的专栏
07-01 523
oracle clusterware 10.2.0.5 on OEL 5.8 配置了三块votesdisk： ./crsctl query css votedisk [root@sdb1 bin]# ./crsctl query css votedisk  0.     0    /dev/raw/raw3  1.     0    /dev/raw/raw4  2.     0
python使用tesseract-ocr
07-29
Python使用Tesseract-OCR进行光学字符识别的步骤如下： 1. 首先，你需要在命令终端中输入命令"tesseract -v"来查看Tesseract-OCR的版本信息。这可以确保你已经正确安装了Tesseract-OCR。\[1\] 2. 接下来，你需要...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值