Oracle 11g RAC CRS磁盘丢失后恢复(二)

2015-07-16 12:07:26 · 作者: · 浏览: 2
Start of 'ora.gpnpd' on 'rac01' succeeded


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


修改/etc/oracle/ocr.loc文件,将OCR修改为DATA,两个节点都需要修改。
查看备份情况,选择一个最近时间节点恢复


查看命令:ocrconfig –showbackup
?[root@rac01 rac-cluster]# ocrconfig -restore /grid/crs_home/product/11.2.0/cdata/rac-cluster/week.ocr


[root@rac01 rac-cluster]# ocrcheck


Status of Oracle Cluster Registry is as follows :


? ? ? ? Version? ? ? ? ? ? ? ? ? :? ? ? ? ? 3


? ? ? ? Total space (kbytes)? ? :? ? 262120


? ? ? ? Used space (kbytes)? ? ? :? ? ? 3088


? ? ? ? Available space (kbytes) :? ? 259032


? ? ? ? ID? ? ? ? ? ? ? ? ? ? ? :? 471595559


? ? ? ? Device/File Name? ? ? ? :? ? ? +DATA


? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 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
?


创建VOTEDISK


在创建时出现以下问题,解决办法如下:


[root@rac01 rac-cluster]# crsctl replace votedisk +DATA


CRS-4602: Failed 27 to add voting file 7255773670ae4fa9bf64a150a9fd5915.


Failure 27 with Cluster Synchronization Services while deleting voting disk.


Failed to replace voting disk group with +DATA.


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


设置ASM磁盘搜索路径


SQL> show parameter asm_diskstring


NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE


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


asm_diskstring? ? ? ? ? ? ? ? ? ? ? string


SQL> alter system set asm_diskstring = '/dev/asm*';


System altered.


SQL> create spfile='+DATA' from memory;


File created.


SQL> startup force mount;
?


再次创建VOTEDISK


[root@rac01 rac-cluster]# crsctl replace votedisk +DATA


Successful addition of voting disk 383b8c3e4db34f72bf9dedd15e47471b.


Successful deletion of voting disk aaaf9f57bc9c4fc7bfb57ac937d2d149.


Successfully replaced voting disk group with +DATA.


CRS-4266: Voting file(s) successfully replaced
?


停止集群服务,再次启动


[root@rac01 rac-cluster]# crsctl stop has –f
……………………
--两个节点顺序启动
[root@rac01 rac-cluster]# crsctl start crs


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


? 通过下面集群状态检查,我们可以看到CRS状态为OFFLINE,需要我们通过asm管理工具重新整理磁盘。


[root@rac01 bin]# crs_stat –t


Name? ? ? ? ? Type? ? ? ? ? Target? ? State? ? Host? ? ? ?


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


ora.CRS.dg? ? ora....up.type ONLINE? OFFNLINE? ? ? ? ? ? ?


ora.DATA.dg? ? or