Chinaunix首页 | 论坛 | 博客
  • 博客访问: 651948
  • 博文数量: 70
  • 博客积分: 145
  • 博客等级: 入伍新兵
  • 技术积分: 1150
  • 用 户 组: 普通用户
  • 注册时间: 2012-10-11 08:15
个人简介

没有简介就是最好的简介

文章分类

全部博文(70)

文章存档

2020年(1)

2018年(2)

2017年(3)

2016年(11)

2015年(12)

2014年(16)

2013年(19)

2012年(6)

我的朋友

分类: Oracle

2016-10-19 13:57:00

环境描述

操作系统: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                File Name Disk group

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

 1. ONLINE   a9c137005f334ff7bf56f8f2408ca179 (/dev/raw/raw1) [OCR]

 2. ONLINE   6530356142514f56bf448324bd6b58e8 (/dev/raw/raw2) [OCR]

 3. ONLINE   64eb22cead5d4fb7bf1964f7222b9351 (/dev/raw/raw3) [OCR]

# ./ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       2600

         Available space (kbytes) :     259520

         ID                       : 1634961206

         Device/File Name         :       +OCR

                                    Device/File integrity check succeeded


                                    Device/File not configured


                                    Device/File not configured


                                    Device/File not configured


                                    Device/File not configured


         Cluster registry integrity check succeeded


         Logical corruption check succeeded

查看OCR备份情况

#  ./ocrconfig -showbackup

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

PROT-25: Manual backups for the Oracle Cluster Registry are not available

由于新安装还没有进行备份,手动进行备份

# ./ocrconfig -local -manualbackup


vincent1     2016/10/19 13:53:17     /u01/app/11.2/grid/cdata/vincent1/backup_20161019_135317.olr


vincent1     2016/10/19 13:35:56     /u01/app/11.2/grid/cdata/vincent1/backup_20161019_133556.olr


vincent1     2016/10/19 12:33:03     /u01/app/11.2/grid/cdata/vincent1/backup_20161019_123303.olr

也可以在asm里面进行备份

[grid@vincent1 ~]$ asmcmd -p

ASMCMD [+] > md_backup /home/grid/bakup1019.ocr -G OCR

Disk group metadata to be backed up: OCR

Current alias directory path: ncdb-cluster/OCRFILE

Current alias directory path: ncdb-cluster

Current alias directory path: ncdb-cluster/ASMPARAMETERFILE

手动导出ocr内容

[root@vincent1 bin]# pwd

/u01/app/11.2/grid/bi


[root@vincent1 bin]# ./ocrconfig -export /home/grid/ocrbak1019

底层ocr磁盘更换,然后进行恢复
开始进行恢复的时候报错


[root@vincent1 grid]# /u01/app/11.2/grid/bin/ocrconfig  -restore /home/grid/bakup1019.ocr

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



强制关闭

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

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

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

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

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

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

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

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

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

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

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

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

以独占模式启用

[root@vincent2 bin]# ./crsctl start crs -excl -nocrs

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

CRS-2672: Attempting to start 'ora.mdnsd' on 'vincent2'

CRS-2676: Start of 'ora.mdnsd' on 'vincent2' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'vincent2'

CRS-2676: Start of 'ora.gpnpd' on 'vincent2' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vincent2'

CRS-2672: Attempting to start 'ora.gipcd' on 'vincent2'

CRS-2676: Start of 'ora.cssdmonitor' on 'vincent2' succeeded

CRS-2676: Start of 'ora.gipcd' on 'vincent2' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'vincent2'

CRS-2672: Attempting to start 'ora.diskmon' on 'vincent2'

CRS-2676: Start of 'ora.diskmon' on 'vincent2' succeeded

CRS-2676: Start of 'ora.cssd' on 'vincent2' succeeded

CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'vincent2'

CRS-2672: Attempting to start 'ora.ctssd' on 'vincent2'

CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'vincent2' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'vincent2'

CRS-2676: Start of 'ora.ctssd' on 'vincent2' succeeded

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

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

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

创建ocr磁盘组

[root@vincent2 bin]# su - grid

[grid@vincent2 ~]$ sqlplus / as sysasm

 

SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 19 19:57:18 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 diskgroup ocr normal redundancy disk '/dev/raw/raw1', '/dev/raw/raw2', '/dev/raw/raw3' attribute 'au_size'='1M','compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.2.0.0.0';

 

Diskgroup created.
使用备份的文件进行恢复

[root@vincent2 ~]# /u01/app/11.2/grid/bin/ocrconfig  -restore /u01/app/11.2/grid/cdata/ncdb-cluster/backup_20161019_173806.ocr
查看状态

[root@vincent2 ~]# /u01/app/11.2/grid/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       2600

         Available space (kbytes) :     259520

         ID                       : 1634961206

         Device/File Name         :       +OCR

                                    Device/File integrity check succeeded

 

                                    Device/File not configured

 

                                    Device/File not configured

 

                                    Device/File not configured

 

                                    Device/File not configured

 

         Cluster registry integrity check succeeded

 

         Logical corruption check succeeded
已经恢复完成
下面一个步骤必须做,不然不会成功

[root@vincent2 ~]# /u01/app/11.2/grid/bin/crsctl replace votedisk +ocr

Successful addition of voting disk 09d04232d0eb4fb7bf944a21f1dd5ff0.

Successful addition of voting disk 69e5a5b7a9d94febbf63198c693966ea.

Successful addition of voting disk a3d2fdcf7ec44f63bfddc18c5bcd2cfc.

Successfully replaced voting disk group with +ocr.

CRS-4266: Voting file(s) successfully replaced

[root@vincent2 ~]# /u01/app/11.2/grid/bin/crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   09d04232d0eb4fb7bf944a21f1dd5ff0 (/dev/raw/raw1) [OCR]

 2. ONLINE   69e5a5b7a9d94febbf63198c693966ea (/dev/raw/raw2) [OCR]

 3. ONLINE   a3d2fdcf7ec44f63bfddc18c5bcd2cfc (/dev/raw/raw3) [OCR]
vote也恢复正常

Located 3 voting disk(s).
强制关闭

[root@vincent2 ~]# /u01/app/11.2/grid/bin/crsctl stop crs -f

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[root@vincent2 ~]# /u01/app/11.2/grid/bin/crsctl start crs

CRS-4123: Oracle High Availability Services has been started.
查看状态
[grid@vincent1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.ARCH.dg    ora....up.type ONLINE    ONLINE    vincent1
ora.DATA.dg    ora....up.type ONLINE    ONLINE    vincent1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    vincent1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    vincent2
ora.OCR.dg     ora....up.type ONLINE    ONLINE    vincent1
ora.asm        ora.asm.type   ONLINE    ONLINE    vincent1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    vincent1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    vincent1
ora....R1.lsnr application    ONLINE    ONLINE    vincent1
ora....er1.gsd application    OFFLINE   OFFLINE               
ora....er1.ons application    ONLINE    ONLINE    vincent1
ora....er1.vip ora....t1.type ONLINE    ONLINE    vincent1
ora....SM2.asm application    ONLINE    ONLINE    vincent2
ora....R2.lsnr application    ONLINE    ONLINE    vincent2
ora....er2.gsd application    OFFLINE   OFFLINE               
ora....er2.ons application    ONLINE    ONLINE    vincent2
ora....er2.vip ora....t1.type ONLINE    ONLINE    vincent2
ora....network ora....rk.type ONLINE    ONLINE    vincent1
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    vincent1
ora.ons        ora.ons.type   ONLINE    ONLINE    vincent1
ora.orcl.db    ora....se.type OFFLINE   OFFLINE               
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    vincent2

阅读(4206) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~