ASM之OCR所在磁碟組損壞後的恢復
How to restore ASM based OCR after complete loss of the CRS diskgroup on Linux/Unix systems [ID 1062983.1] 當OCR存於ASM且損壞時,不能直接恢復; 因為ocrconfig -restore需要ASM處於執行狀態才能執行成功,而OCR丟失又導致ASM無法啟動,由此產生了悖論; 對於11202,可採用如下方法應對: 背景 When using an ASM disk group for CRS there are typically 3 different types of files located in the disk group that potentially need to be restored/recreated: the Oracle Cluster Registry file (OCR) the Voting file(s) the shared SPFILE for the ASM instances The following example assumes that the OCR was located in a single disk group used exclusively for CRS. The disk group has just one disk using external redundancy. Since the CRS disk group has been lost the CRS stack will not be available on any node. 如果將OCR恢復到新的磁碟組,還應修改/etc/oracle/ocr.loc檔案 This document assumes that the name of the OCR diskgroup remains unchanged, however there may be a need to use a different diskgroup name, in which case the name of the OCR diskgroup would have to be modified in /etc/oracle/ocr.loc across all nodes prior to executing the following steps. 首先確定OCR存有備份,在跳過CRS的前提下啟動clusterware,先後恢復OCR/voting disk OCR自動備份集可位於叢集中任一節點,應逐個查詢 [oracle@justin ~]$ ocrconfig -showbackup
justin 2013/05/16 04:43:30 /orasw/app/11.2.0.3/grid/cdata/backup00.ocr
justin 2013/05/16 00:43:29 /orasw/app/11.2.0.3/grid/cdata/backup01.ocr
justin 2013/05/15 20:43:29 /orasw/app/11.2.0.3/grid/cdata/backup02.ocr
justin 2013/05/14 08:43:26 /orasw/app/11.2.0.3/grid/cdata/day.ocr
justin 2013/05/02 22:14:05 /orasw/app/11.2.0.3/grid/cdata/week.ocr
關閉所有GI服務
# $CRS_HOME/bin/crsctl stop crs -f
跳過CRS以排他方式啟動GI
# $CRS_HOME/bin/crsctl start crs -excl -nocrs CRS-4123: Oracle High Availability Services has been started.
...
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'auw2k3'
CRS-2672: Attempting to start 'ora.ctssd' on 'racnode1'
CRS-2676: Start of 'ora.drivers.acfs' on 'racnode1' succeeded
CRS-2676: Start of 'ora.ctssd' on 'racnode1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racnode1'
CRS-2676: Start of 'ora.asm' on 'racnode1' succeeded
登陸ASM建立丟失的磁碟組,然後匯入最新OCR備份
SQL> create diskgroup CRS external redundancy disk 'ORCL:ASMD40' attribute 'COMPATIBLE.ASM' = '11.2';
Diskgroup created.
# cd $CRS_HOME/cdata/rac_cluster1/
# $CRS_HOME/bin/ocrconfig -restore backup00.ocr
重建voting disk
# $CRS_HOME/bin/crsctl replace votedisk +CRS
Successful addition of voting disk 00caa5b9c0f54f3abf5bd2a2609f09a9.
Successfully replaced voting disk group with +CRS.
CRS-4266: Voting file(s) successfully replaced
關閉並重啟CRS
# $CRS_HOME/bin/crsctl stop crs -f
...
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'auw2k3' has completed
CRS-4133: Oracle High Availability Services has been stopped.
# $CRS_HOME/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25462274/viewspace-2148846/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 存貯在asm中的ocr/votedisk/asm磁碟組損害的恢復ASM
- Oracle asm磁碟損壞異常恢復OracleASM
- RAC 11G ASM磁碟損壞恢復ASM
- 遷移ocr/votedisk/asm spfile所在磁碟組ASM
- master資料庫損壞之後的恢復AST資料庫
- ASM磁碟頭資訊損壞和修復(kfed/dd)ASM
- 當前日誌組全部損壞的恢復
- 探索ORACLE之RMAN_07 磁碟損壞資料丟失恢復Oracle
- index損壞恢復Index
- RAC共享磁碟物理路徑故障導致OCR、Votedisk所在ASM磁碟組不可訪問的案例分析ASM
- 恢復表空間到不同的ASM磁碟組ASM
- 磁碟損壞造成RMAN備份檔案有壞塊的恢復案例
- Oracle資料庫UNDO損壞後的恢復Oracle資料庫
- ASM 仲裁盤OCR DG損壞,重建步驟ASM
- 針對11.2 RAC丟失OCR和Votedisk所在ASM Diskgroup的恢復手段ASM
- asm磁碟組中的磁碟頭資訊丟失恢復實驗ASM
- 磁碟損壞導致資料檔案丟失的恢復
- 恢復之單個控制檔案損壞
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- Oracle database 11g rac損壞ocr和votedisk恢復實驗OracleDatabase
- linux下修復磁碟損壞Linux
- ASM重新命名包含OCR/vote file的磁碟組ASM
- inactive狀態日誌組檔案損壞的恢復
- Sql server日誌損壞後的資料恢復(轉)SQLServer資料恢復
- 介質恢復,即磁碟或作業系統檔案損壞的恢復-非RMAN方法作業系統
- oracle grid 其中一個節點asm 磁碟組後設資料損壞處理案例OracleASM
- 損壞控制檔案的恢復方法
- Oracle 11g RAC ASM VOTEDISK所在磁碟全部丟失重大故障恢復OracleASM
- 備份與恢復--重建控制檔案後資料檔案損壞的恢復
- 一次控制檔案損壞後的恢復經歷
- 損壞聯機日誌 恢復
- 備份&恢復之十三:損壞全部控制檔案
- u盤檔案損壞怎麼恢復資料 u盤恢復損壞資料的有效方法
- 11gR2 基於ASM磁碟組的資料庫恢復ASM資料庫
- 損壞聯機日誌的恢復方法
- 單個控制檔案損壞的恢復
- 聯機日誌檔案損壞後的恢復方法[轉帖]
- Oracle重做日誌檔案損壞或丟失後的恢復Oracle