某客户核心系统DG库重建（包括OCR恢复、重建DG库、failover、闪回）.txt

明靓

云和恩墨交付战队

795

11页

9次

2022-04-13

25墨值下载

10.135.128.120（原老环境） hdisk0 是系统盘、hdisk61 是/、hdisk18 大小 50G、76 个 1TB 的盘

当前环境老的磁盘全部被摘除（包括 OCR 磁盘组），需要恢复 OCR

##参考

How to restore ASM based OCR after complete loss of the CRS diskgroup on

Linux/Unix systems [ID 1062983.1]

恢复步骤如下：

一、OCR 恢复

1.查看 OCR 备份信息

bash-4.2$ ocrconfig -showbackup

PROT-26: Oracle Cluster Registry backup locations were retrieved from a local

copy

fhcs 2021/12/23 10:48:28 /picclife/app/grid_2/cdata/fhcs-

cluster/backup00.ocr

fhcs 2021/12/23 06:48:28 /picclife/app/grid_2/cdata/fhcs-

cluster/backup01.ocr

fhcs 2021/12/23 02:48:28 /picclife/app/grid_2/cdata/fhcs-

cluster/backup02.ocr

fhcs 2021/12/22 10:48:26 /picclife/app/grid_2/cdata/fhcs-cluster/day.ocr

fhcs 2021/12/09 22:47:50 /picclife/app/grid_2/cdata/fhcs-

cluster/week.ocr

fhcs 2021/05/24 10:51:15 /picclife/app/grid/cdata/fhcs-

cluster/backup_20210524_105115.ocr

2.关闭所有 GI 服务--root 执行

/picclife/app/grid_2/bin/crsctl stop crs -f

[root@fhcs:/]#/picclife/app/grid_2/bin/crsctl stop crs -f

CRS-2791: Starting shutdown of Oracle High Availability Services-managed

resources on 'fhcs'

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

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

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

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

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

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

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

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

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on

'fhcs' has completed

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

3.跳过 CRS 以排他方式启动 GI

/picclife/app/grid_2/bin/crsctl start crs -excl -nocrs

##说明：

--excl 该参数指定使用独占模式

--nocrs 该参数指定忽略查找 crs 及 voting

[root@fhcs:/]#/picclife/app/grid_2/bin/crsctl start crs -excl -nocrs

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

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

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

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

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

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

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

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

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

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

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

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

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

CRS-2672: Attempting to start 'ora.drivers.acfs' on 'fhcs'

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

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

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

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

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

CRS-2676: Start of 'ora.drivers.acfs' on 'fhcs' succeeded

CRS-5017: The resource action "ora.cluster_interconnect.haip start" encountered

the following error:

Start action for HAIP aborted. For details refer to "(:CLSN00107:)" in

"/picclife/app/grid_2/log/fhcs/agent/ohasd/orarootagent_root//orarootagent_root.

log".

CRS-2674: Start of 'ora.cluster_interconnect.haip' on 'fhcs' failed

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

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

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

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

4.登陆 ASM 创建 OCR 磁盘组

***这里需要注意如果将 OCR 恢复到新的磁盘组，还应修改/etc/oracle/ocr.loc 文件

bash-4.2$ cat /etc/oracle/ocr.loc

ocrconfig_loc=+OCR

local_only=FALSE

#hdisk0 是系统盘、hdisk61 是/、hdisk18 大小 50G、76 个 1TB 的盘

[root@fhcs:/]#bootinfo -s hdisk18 --确认磁盘大小

51200

su - root

for i in {1..60}; do chown -R grid:asmadmin /dev/rhdisk$i; done

for i in {1..60}; do chmod 660 /dev/rhdisk$i; done

for i in {1..60} ; do chdev -l hdisk$i -a reserve_policy=no_reserve; done

for i in {62..78}; do chown -R grid:asmadmin /dev/rhdisk$i; done

for i in {62..78}; do chmod 660 /dev/rhdisk$i; done

for i in {62..78} ; do chdev -l hdisk$i -a reserve_policy=no_reserve; done

#创建 CRS 磁盘

SQL> create diskgroup CRS external redundancy disk '/dev/rhdisk18' attribute

'COMPATIBLE.ASM' = '11.2';

Diskgroup created.

5.Restore the latest OCR backup

su - root

cd /picclife/app/grid_2/cdata/fhcs-cluster

/picclife/app/grid_2/bin/ocrconfig -restore backup00.ocr

[root@fhcs:/picclife/app/grid_2/cdata/fhcs-

cluster]#/picclife/app/grid_2/bin/ocrconfig -restore backup00.ocr

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

需要修改下/etc/oracle/ocr.loc

ocrconfig_loc=+OCR -->修改为+CRS

local_only=FALSE

再次执行没有问题

6.重建 voting disk

/picclife/app/grid_2/bin/crsctl replace votedisk +CRS

of 11

25墨值下载

关注

评论