OCR_VOTE disk 磁盘模拟全部损坏恢复试验

ASM集群现有状况

查询集群状态

$ORACLE_SID: +ASM1
$ORACLE_HOME: /grid/grid_home

root@testdb1[+ASM1]/root$crsctl check cluster -all
**************************************************************
testdb1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
testdb2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

查询OCR状态

root@testdb1[+ASM1]/root$date
Thu May 27 18:47:15 CST 2021
root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3260
     Available space (kbytes) :     258860
     ID                       :  545177980
     Device/File Name         :  +OCR_VOTE
                                    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

OCR备份

root@testdb1[+ASM1]/root$ocrconfig -manualbackup

testdb1     2021/05/27 18:49:29     /grid/grid_home/cdata/testdb-cluster/backup_20210527_184929.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr
root@testdb1[+ASM1]/root$ocrconfig -showbackup

testdb1     2021/05/27 18:18:40     /grid/grid_home/cdata/testdb-cluster/backup00.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/backup01.ocr

testdb1     2021/05/25 10:05:42     /grid/grid_home/cdata/testdb-cluster/backup02.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/day.ocr

testdb2     2021/05/15 17:47:50     /grid/grid_home/cdata/testdb-cluster/week.ocr

testdb1     2021/05/27 18:49:29     /grid/grid_home/cdata/testdb-cluster/backup_20210527_184929.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr

注意就一份OCR,因此采用如下方法不可用。

root@testdb1[+ASM1]/root$ocrconfig -replace +OCR_VOTE -replacement +OCR_VOTE2
PROT-28: Cannot delete or replace the only configured Oracle Cluster Registry location
root@testdb1[+ASM1]/root$crsctl replace votedisk +OCR_VOTE2
Successful addition of voting disk 1a290cdaac3a4f70bf10797b96d878bf.
Successful deletion of voting disk 531089329c6e4fd7bf55527321648aeb.
Successful deletion of voting disk 2ddb39eaa1a54ff0bf38c48b12a7315c.
Successful deletion of voting disk 735db22d36d14f31bf446493c25cf1bc.
Successful deletion of voting disk 5cc9d45f6ade4f98bf16c78be12fa786.
Successful deletion of voting disk 9aa888a3c13e4f71bf7d220cfde27878.
Successfully replaced voting disk group with +OCR_VOTE2.
CRS-4266: Voting file(s) successfully replaced

查看OCR状态

root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3280
     Available space (kbytes) :     258840
     ID                       :  545177980
     Device/File Name         :  +OCR_VOTE
                                    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@testdb1[+ASM1]/root$crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   1a290cdaac3a4f70bf10797b96d878bf (/dev/asm-diskh) [OCR_VOTE2]
Located 1 voting disk(s).

替换ASM磁盘下的OCR

先添加一个磁盘

root@testdb1[+ASM1]/root$ ocrconfig -add +OCR_VOTE2

root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3280
     Available space (kbytes) :     258840
     ID                       :  545177980
     Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
     Device/File Name         : +OCR_VOTE2
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

root@testdb1[+ASM1]/root$

删除原有的OCR存储磁盘

root@testdb1[+ASM1]/root$ocrconfig -delete +OCR_VOTE
root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3280
     Available space (kbytes) :     258840
     ID                       :  545177980
     Device/File Name         : +OCR_VOTE2
                                    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@testdb1[+ASM1]/root$ocrconfig -manualbackup

testdb1     2021/05/27 19:11:16     /grid/grid_home/cdata/testdb-cluster/backup_20210527_191116.ocr

testdb1     2021/05/27 18:49:29     /grid/grid_home/cdata/testdb-cluster/backup_20210527_184929.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr
root@testdb1[+ASM1]/root$

查看现有状况

SQL> COLUMN PATH FORMAT A20;
COLUMN name FORMAT A20;
SET LINESIZE 500
select dg.NAME as disk_group,d.NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,PATH from V$ASM_DISK d ,V$ASM_DISKGROUP dg
where d.GROUP_NUMBER=dg.GROUP_NUMBER
order by dg.NAME;SQL> SQL> SQL>   2    3  

DISK_GROUP                           NAME         MOUNT_STATUS   HEADER_STATUS        MODE_STATUS    PATH
------------------------------------------------------------ -------------------- -------------- ------------------------ -------------- --------------------
ACFS01                               ACFS01_0000      CACHED     MEMBER           ONLINE     /dev/asm-diskj
DGARCH                               DGARCH_0000      CACHED     MEMBER           ONLINE     /dev/asm-diskl
DGDATA                               DGDATA_0000      CACHED     MEMBER           ONLINE     /dev/asm-diske
DGSYS                                DGSYS_0000       CACHED     MEMBER           ONLINE     /dev/asm-diskk
OCR_VOTE                             OCR_VOTE_0000    CACHED     MEMBER           ONLINE     /dev/asm-diskm
OCR_VOTE                             OCR_VOTE_0005    CACHED     MEMBER           ONLINE     /dev/asm-diskc
OCR_VOTE                             OCR_VOTE_0002    CACHED     MEMBER           ONLINE     /dev/asm-diskg
OCR_VOTE                             OCR_VOTE_0003    CACHED     MEMBER           ONLINE     /dev/asm-diskf
OCR_VOTE                             OCR_VOTE_0004    CACHED     MEMBER           ONLINE     /dev/asm-diskd
OCR_VOTE2                            OCR_VOTE2_0000   CACHED     MEMBER           ONLINE     /dev/asm-diskh

10 rows selected.

OCR损坏恢复试验


刚刚已经将现有环境说明。OCR_VOTE2现在就一块磁盘,我们将该块磁盘进行格式化磁头,然后进行恢复。

查看节点

root@testdb2[+ASM2]/root$olsnodes
testdb1
testdb2
root@testdb2[+ASM2]/root$

格式化磁盘头

root@testdb1[+ASM1]/root$dd if=/dev/zero of=/dev/asm-diskh bs=1024k count=20
20+0 records in
20+0 records out
20971520 bytes (21 MB) copied, 0.0628084 s, 334 MB/s

格式化后关闭两个节点

root@testdb1[+ASM1]/root$crsctl stop crs -f

在一个节点上以EXCL和NOCRS方式启动集群

root@testdb1[+ASM1]/root$crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'testdb1'
CRS-2676: Start of 'ora.mdnsd' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'testdb1'
CRS-2676: Start of 'ora.gpnpd' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'testdb1'
CRS-2672: Attempting to start 'ora.gipcd' on 'testdb1'
CRS-2676: Start of 'ora.cssdmonitor' on 'testdb1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'testdb1'
CRS-2672: Attempting to start 'ora.diskmon' on 'testdb1'
CRS-2676: Start of 'ora.diskmon' on 'testdb1' succeeded
CRS-2676: Start of 'ora.cssd' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'testdb1'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'testdb1'
CRS-2672: Attempting to start 'ora.ctssd' on 'testdb1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'testdb1'
CRS-2676: Start of 'ora.drivers.acfs' on 'testdb1' succeeded
CRS-2676: Start of 'ora.ctssd' on 'testdb1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'testdb1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'testdb1'
CRS-2676: Start of 'ora.asm' on 'testdb1' succeeded

查看磁盘状态,可以发现该OCR_VOTE2已经不存在

root@testdb1[+ASM1]/root$su - grid

$ORACLE_SID: +ASM1
$ORACLE_HOME: /grid/grid_home

grid@testdb1[+ASM1]/home/grid$sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 27 19:23:39 2021

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> set linesize 30
SQL> set linesize 300
SQL> select name,state from v$asm_diskgroup;

NAME                                 STATE
------------------------------------------------------------ ----------------------
ACFS01                               MOUNTED
DGARCH                               MOUNTED
DGDATA                               MOUNTED
DGSYS                                MOUNTED
OCR_VOTE                             DISMOUNTED

对OCR_VOTE2进行再次清理

SQL> drop diskgroup OCR_VOTE2 force including contents;
drop diskgroup OCR_VOTE2 force including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR_VOTE2"

###利用磁盘再创建一个磁盘组


SQL> create diskgroup OCR_VOTE2 external redundancy disk '/dev/asm-diskh' ;

Diskgroup created.

SQL> COLUMN PATH FORMAT A20;
COLUMN name FORMAT A20;
SET LINESIZE 500
select dg.NAME as disk_group,d.NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,PATH from V$ASM_DISK d ,V$ASM_DISKGROUP dg
where d.GROUP_NUMBER=dg.GROUP_NUMBER
order by dg.NAME;SQL> SQL> SQL>   2    3  

DISK_GROUP                           NAME         MOUNT_STATUS   HEADER_STATUS        MODE_STATUS    PATH
------------------------------------------------------------ -------------------- -------------- ------------------------ -------------- --------------------
ACFS01                               ACFS01_0000      CACHED     MEMBER           ONLINE     /dev/asm-diskj
DGARCH                               DGARCH_0000      CACHED     MEMBER           ONLINE     /dev/asm-diskl
DGDATA                               DGDATA_0000      CACHED     MEMBER           ONLINE     /dev/asm-diske
DGSYS                                DGSYS_0000       CACHED     MEMBER           ONLINE     /dev/asm-diskk
OCR_VOTE                                      CLOSED     MEMBER           ONLINE     /dev/asm-diskc
OCR_VOTE                                      CLOSED     MEMBER           ONLINE     /dev/asm-diskd
OCR_VOTE                                      CLOSED     MEMBER           ONLINE     /dev/asm-diskf
OCR_VOTE                                      CLOSED     MEMBER           ONLINE     /dev/asm-diskg
OCR_VOTE                                      CLOSED     MEMBER           ONLINE     /dev/asm-diskm
OCR_VOTE                                      CLOSED     CANDIDATE        ONLINE     /dev/asm-diski
OCR_VOTE2                            OCR_VOTE2_0000   CACHED     MEMBER           ONLINE     /dev/asm-diskh

11 rows selected.

配置数据磁盘组属性

SQL> ALTER DISKGROUP OCR_VOTE2 SET ATTRIBUTE 'compatible.asm' = '11.2.0.0.0' ;
ALTER DISKGROUP OCR_VOTE2 SET ATTRIBUTE 'compatible.rdbms' = '11.2.0.0.0';
ALTER DISKGROUP OCR_VOTE2 SET ATTRIBUTE 'compatible.advm' = '11.2.0.0.0';
Diskgroup altered.

查看磁盘组状态,可以看到OCR_VOTE2为mounted

SQL>  select name,state from v$asm_diskgroup
  2  ;

NAME             STATE
-------------------- ----------------------
ACFS01           MOUNTED
DGARCH           MOUNTED
DGDATA           MOUNTED
DGSYS            MOUNTED
OCR_VOTE         DISMOUNTED
OCR_VOTE2        MOUNTED

6 rows selected.

SQL> exit

再次查询OCR备份路径

注意我的虚拟机有问题,最新备份没显示出来。
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@testdb1[+ASM1]/home/grid$ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy

testdb1     2021/05/27 18:18:40     /grid/grid_home/cdata/testdb-cluster/backup00.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/backup01.ocr

testdb1     2021/05/25 10:05:42     /grid/grid_home/cdata/testdb-cluster/backup02.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/day.ocr

testdb2     2021/05/15 17:47:50     /grid/grid_home/cdata/testdb-cluster/week.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr
grid@testdb1[+ASM1]/home/grid$date
Thu May 27 19:28:55 CST 2021
grid@testdb1[+ASM1]/home/grid$ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy

testdb1     2021/05/27 18:18:40     /grid/grid_home/cdata/testdb-cluster/backup00.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/backup01.ocr

testdb1     2021/05/25 10:05:42     /grid/grid_home/cdata/testdb-cluster/backup02.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/day.ocr

testdb2     2021/05/15 17:47:50     /grid/grid_home/cdata/testdb-cluster/week.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr
grid@testdb1[+ASM1]/home/grid$cd /grid/grid_home/cdata/testdb-cluster/
grid@testdb1[+ASM1]/grid/grid_home/cdata/testdb-cluster$ll
total 73512
-rw------- 1 root root 7299072 Aug 13  2018 29696603.ocr
-rw------- 1 root root 7585792 May 27 18:18 backup00.ocr
-rw------- 1 root root 7585792 May 27 14:18 backup01.ocr
-rw------- 1 root root 7585792 May 25 10:05 backup02.ocr
-rw------- 1 root root 7557120 May 25 09:13 backup_20210525_091358.ocr
-rw------- 1 root root 7585792 May 27 18:49 backup_20210527_184929.ocr
-rw------- 1 root root 7606272 May 27 19:11 backup_20210527_191116.ocr
-rw------- 1 root root 7585792 May 27 14:18 day.ocr
-rw------- 1 root root 7585792 May 25 10:05 week_.ocr
-rw------- 1 root root 7299072 Oct 31  2018 week.ocr

root@testdb1[+ASM1]/root$ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy

testdb1     2021/05/27 18:18:40     /grid/grid_home/cdata/testdb-cluster/backup00.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/backup01.ocr

testdb1     2021/05/25 10:05:42     /grid/grid_home/cdata/testdb-cluster/backup02.ocr

testdb1     2021/05/27 14:18:39     /grid/grid_home/cdata/testdb-cluster/day.ocr

testdb2     2021/05/15 17:47:50     /grid/grid_home/cdata/testdb-cluster/week.ocr

testdb1     2021/05/25 09:13:58     /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr
root@testdb1[+ASM1]/root$ocrconfig -restore /grid/grid_home/cdata/testdb-cluster/backup_20210527_191116.ocr
root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3280
     Available space (kbytes) :     258840
     ID                       :  545177980
     Device/File Name         : +OCR_VOTE2
                                    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@testdb1[+ASM1]/root$crsctl replace votedisk +OCR_VOTE2
Successful addition of voting disk 98b7549a0c6e4fb8bffcac53aa906b9c.
Successfully replaced voting disk group with +OCR_VOTE2.
CRS-4266: Voting file(s) successfully replaced

root@testdb1[+ASM1]/root$crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   98b7549a0c6e4fb8bffcac53aa906b9c (/dev/asm-diskh) [OCR_VOTE2]
Located 1 voting disk(s).

进行重启

root@testdb1[+ASM1]/root$crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testdb1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'testdb1'
CRS-2673: Attempting to stop 'ora.asm' on 'testdb1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'testdb1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'testdb1'
CRS-2677: Stop of 'ora.mdnsd' on 'testdb1' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'testdb1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'testdb1' succeeded
CRS-2677: Stop of 'ora.asm' on 'testdb1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'testdb1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'testdb1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'testdb1'
CRS-2677: Stop of 'ora.cssd' on 'testdb1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'testdb1'
CRS-2677: Stop of 'ora.gipcd' on 'testdb1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'testdb1'
CRS-2677: Stop of 'ora.gpnpd' on 'testdb1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testdb1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

启动集群节点

root@testdb1[+ASM1]/root$crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
root@testdb1[+ASM1]/root$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
root@testdb1[+ASM1]/root$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
root@testdb1[+ASM1]/root$

root@testdb1[+ASM1]/root$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
root@testdb1[+ASM1]/root$crsctl check cluster -all
**************************************************************
testdb1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
root@testdb1[+ASM1]/root$crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ACFS01.dg
               ONLINE  ONLINE       testdb1                                      
ora.DGARCH.dg
               ONLINE  ONLINE       testdb1                                      
ora.DGDATA.dg
               ONLINE  ONLINE       testdb1                                      
ora.DGSYS.dg
               ONLINE  ONLINE       testdb1                                      
ora.LISTENER.lsnr
               ONLINE  ONLINE       testdb1                                      
ora.OCR_VOTE.dg
               ONLINE  ONLINE       testdb1                                      
ora.OCR_VOTE2.dg
               ONLINE  ONLINE       testdb1                                      
ora.asm
               ONLINE  ONLINE       testdb1                  Started             
ora.gsd
               OFFLINE OFFLINE      testdb1                                      
ora.net1.network
               ONLINE  ONLINE       testdb1                                      
ora.ons
               ONLINE  ONLINE       testdb1                                      
ora.registry.acfs
               ONLINE  ONLINE       testdb1                                      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       testdb1                                      
ora.cvu
      1        ONLINE  ONLINE       testdb1                                      
ora.oc4j
      1        ONLINE  ONLINE       testdb1                                      
ora.scan1.vip
      1        ONLINE  ONLINE       testdb1                                      
ora.testdb.db
      1        ONLINE  ONLINE       testdb1                  Open                
      2        ONLINE  OFFLINE                                                   
ora.testdb1.vip
      1        ONLINE  ONLINE       testdb1                                      
ora.testdb2.vip
      1        ONLINE  INTERMEDIATE testdb1                  FAILED OVER         
root@testdb1[+ASM1]/root$cluvfy comp ocr -n all -verbose
You must NOT be logged in as root (uid=0) when running /grid/grid_home/bin/cluvfy.
root@testdb1[+ASM1]/root$su - grid

$ORACLE_SID: +ASM1
$ORACLE_HOME: /grid/grid_home

grid@testdb1[+ASM1]/home/grid$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 "+OCR_VOTE2" 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. 
grid@testdb1[+ASM1]/home/grid$cluvfy comp vdisk -n all -verbose

Verifying Voting Disk 

Checking Oracle Cluster Voting Disk configuration...

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

Oracle Cluster Voting Disk configuration check passed

UDev attributes check for Voting Disk locations started...
Result: UDev attributes check passed for Voting Disk locations 

Verification of Voting Disk was successful. 
grid@testdb1[+ASM1]/home/grid$ 
上一篇:【DB笔试面试720】在Oracle中,OCR备份恢复有哪几种?


下一篇:【DB笔试面试713】在Oracle中,如何将一个数据库添加到CRS中?