oracle 11g CSS 和OCR 的恢復
檢視當前表決磁碟檔案列表
[grid@vmac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 458f802427764f59bfc6f6f356e74f5c (/dev/asm-diskb) [SYSDG]
2. ONLINE 07874cf03c834f01bf4b0c7c4e0da628 (/dev/asm-diskc) [SYSDG]
3. ONLINE 9725750dde764fa2bf88c892b884d457 (/dev/asm-diskd) [SYSDG]
Located 3 voting disk(s).
檢視當前OCR
[grid@vmac1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3180
Available space (kbytes) : 258940
ID : 1340449286
Device/File Name : +SYSDG
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 bypassed due to non-privileged user
手動備份:
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -manualbackup
vmac2 2014/06/04 15:55:37 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140604_155537.ocr
vmac2 2014/06/04 15:55:22 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140604_155522.ocr
vmac1 2014/05/28 11:47:08 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114708.ocr
vmac1 2014/05/28 11:45:59 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114559.ocr
vmac1 2014/05/28 11:45:46 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114546.ocr
清除表決磁碟和OCR的ASM磁碟組所有磁碟的頭資訊，模擬但磁碟組損壞
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskc bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.226621 s, 9.0 MB/s
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskb bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.206666 s, 9.9 MB/s
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskd bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.188636 s, 10.9 MB/s
以root 使用者，以獨佔模式啟動crs:
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'vmac1'
CRS-2676: Start of 'ora.mdnsd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'vmac1'
CRS-2676: Start of 'ora.gpnpd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vmac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'vmac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'vmac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'vmac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'vmac1'
CRS-2676: Start of 'ora.diskmon' on 'vmac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'vmac1'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'vmac1'
CRS-2672: Attempting to start 'ora.ctssd' on 'vmac1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'vmac1'
CRS-2676: Start of 'ora.ctssd' on 'vmac1' succeeded
CRS-2676: Start of 'ora.drivers.acfs' on 'vmac1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'vmac1'
CRS-2676: Start of 'ora.asm' on 'vmac1' succeeded
[root@vmac1 ~]#
檢視錶決磁碟：
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl query css votedisk
Located 0 voting disk(s).
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrcheck
PROT-602: Failed to retrieve data from the cluster registry
PROC-26: Error while accessing the physical storage
create diskgroup SYSDG normal redundancy
failgroup SYSDG_001 disk '/dev/asm-diskb'
failgroup SYSDG_002 disk '/dev/asm-diskc'
failgroup SYSDG_003 disk '/dev/asm-diskd'
attribute 'compatible.asm'='11.2.0.0.0';
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
SYSDG2 DISMOUNTED
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG MOUNTED
[root@vmac1 bin]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
Oracle Cluster Registry initialization failed accessing Oracle Cluster Registry device: PROC-26: Error while accessing the physical storage
CRS-4000: Command Replace failed, or completed with errors.
[root@vmac1 bin]#
#### Possible OCR corruption.in $GI_HOME/log/crsd.log
正確的順序應該是先restore ocr，然後再replace votedisk。
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -showbackup manual
vmac1 2014/05/28 11:45:59 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114559.ocr
vmac1 2014/05/28 11:45:46 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114546.ocr
vmac1 2014/05/08 16:27:06 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140508_162706.ocr
vmac1 2014/05/08 16:26:51 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140508_162651.ocr
[root@vmac1 ~]#
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -restore /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114708.ocr
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
CRS-4602: Failed 27 to add voting file 835dae3dc74d4fd8bfd470b5ad675e05.
CRS-4602: Failed 27 to add voting file 79b5b5df0f754fa4bff4157c508d43df.
CRS-4602: Failed 27 to add voting file 03325c90c7a94fd9bf81f3b0eb971117.
Failed to replace voting disk group with +SYSDG.
CRS-4000: Command Replace failed, or completed with errors.
tail -f alertvmac1.log
[cssd(2622)]CRS-1638:Unable to locate voting file with ID 835dae3d-c74d4fd8-bfd470b5-ad675e05 that is being added to the list of configured voting files; details at (:CSSNM00027:) in /g01/app/grid/product/11.2.0/log/vmac1/cssd/ocssd.log
2014-06-05 16:40:20.107:
[cssd(2622)]CRS-1630:A configuration change request failed because not all the new voting files were discovered; Details at (:CSSNM00012:) in /g01/app/grid/product/11.2.0/log/vmac1/cssd/ocssd.log
SQL> show parameter disk;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string
SQL> alter system set asm_diskstring='/dev/asm*' ;
System altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG DISMOUNTED
SQL> alter diskgroup SYSDG mount;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG MOUNTED
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
Successful addition of voting disk ac10ac62ec754f84bfac17b1484fc32f.
Successful addition of voting disk 5c459de6405f4f04bf67afb1d57e41f3.
Successful addition of voting disk 73107787ec7c4f11bf9e205e7df6eb5a.
Successfully replaced voting disk group with +SYSDG.
CRS-4266: Voting file(s) successfully replaced
[root@vmac1 ~]#
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE ac10ac62ec754f84bfac17b1484fc32f (/dev/asm-diskb) [SYSDG]
2. ONLINE 5c459de6405f4f04bf67afb1d57e41f3 (/dev/asm-diskc) [SYSDG]
3. ONLINE 73107787ec7c4f11bf9e205e7df6eb5a (/dev/asm-diskd) [SYSDG]
Located 3 voting disk(s).
/g01/app/grid/product/11.2.0/bin/crsctl stop crs -f
ref:
http://blog.itpub.net/23135684/viewspace-748816
http://blog.csdn.net/bamuta/article/details/9493703
[grid@vmac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 458f802427764f59bfc6f6f356e74f5c (/dev/asm-diskb) [SYSDG]
2. ONLINE 07874cf03c834f01bf4b0c7c4e0da628 (/dev/asm-diskc) [SYSDG]
3. ONLINE 9725750dde764fa2bf88c892b884d457 (/dev/asm-diskd) [SYSDG]
Located 3 voting disk(s).
檢視當前OCR
[grid@vmac1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3180
Available space (kbytes) : 258940
ID : 1340449286
Device/File Name : +SYSDG
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 bypassed due to non-privileged user
手動備份:
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -manualbackup
vmac2 2014/06/04 15:55:37 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140604_155537.ocr
vmac2 2014/06/04 15:55:22 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140604_155522.ocr
vmac1 2014/05/28 11:47:08 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114708.ocr
vmac1 2014/05/28 11:45:59 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114559.ocr
vmac1 2014/05/28 11:45:46 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114546.ocr
清除表決磁碟和OCR的ASM磁碟組所有磁碟的頭資訊，模擬但磁碟組損壞
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskc bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.226621 s, 9.0 MB/s
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskb bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.206666 s, 9.9 MB/s
[root@vmac1 ~]# dd if=/dev/zero of=/dev/asm-diskd bs=1024 count=2000
2000+0 records in
2000+0 records out
2048000 bytes (2.0 MB) copied, 0.188636 s, 10.9 MB/s
以root 使用者，以獨佔模式啟動crs:
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'vmac1'
CRS-2676: Start of 'ora.mdnsd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'vmac1'
CRS-2676: Start of 'ora.gpnpd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vmac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'vmac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'vmac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'vmac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'vmac1'
CRS-2676: Start of 'ora.diskmon' on 'vmac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'vmac1'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'vmac1'
CRS-2672: Attempting to start 'ora.ctssd' on 'vmac1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'vmac1'
CRS-2676: Start of 'ora.ctssd' on 'vmac1' succeeded
CRS-2676: Start of 'ora.drivers.acfs' on 'vmac1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'vmac1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'vmac1'
CRS-2676: Start of 'ora.asm' on 'vmac1' succeeded
[root@vmac1 ~]#
檢視錶決磁碟：
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl query css votedisk
Located 0 voting disk(s).
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrcheck
PROT-602: Failed to retrieve data from the cluster registry
PROC-26: Error while accessing the physical storage
create diskgroup SYSDG normal redundancy
failgroup SYSDG_001 disk '/dev/asm-diskb'
failgroup SYSDG_002 disk '/dev/asm-diskc'
failgroup SYSDG_003 disk '/dev/asm-diskd'
attribute 'compatible.asm'='11.2.0.0.0';
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
SYSDG2 DISMOUNTED
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG MOUNTED
[root@vmac1 bin]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
Oracle Cluster Registry initialization failed accessing Oracle Cluster Registry device: PROC-26: Error while accessing the physical storage
CRS-4000: Command Replace failed, or completed with errors.
[root@vmac1 bin]#
#### Possible OCR corruption.in $GI_HOME/log/
正確的順序應該是先restore ocr，然後再replace votedisk。
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -showbackup manual
vmac1 2014/05/28 11:45:59 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114559.ocr
vmac1 2014/05/28 11:45:46 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114546.ocr
vmac1 2014/05/08 16:27:06 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140508_162706.ocr
vmac1 2014/05/08 16:26:51 /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140508_162651.ocr
[root@vmac1 ~]#
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/ocrconfig -restore /g01/app/grid/product/11.2.0/cdata/vmac-cluster/backup_20140528_114708.ocr
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
CRS-4602: Failed 27 to add voting file 835dae3dc74d4fd8bfd470b5ad675e05.
CRS-4602: Failed 27 to add voting file 79b5b5df0f754fa4bff4157c508d43df.
CRS-4602: Failed 27 to add voting file 03325c90c7a94fd9bf81f3b0eb971117.
Failed to replace voting disk group with +SYSDG.
CRS-4000: Command Replace failed, or completed with errors.
tail -f alertvmac1.log
[cssd(2622)]CRS-1638:Unable to locate voting file with ID 835dae3d-c74d4fd8-bfd470b5-ad675e05 that is being added to the list of configured voting files; details at (:CSSNM00027:) in /g01/app/grid/product/11.2.0/log/vmac1/cssd/ocssd.log
2014-06-05 16:40:20.107:
[cssd(2622)]CRS-1630:A configuration change request failed because not all the new voting files were discovered; Details at (:CSSNM00012:) in /g01/app/grid/product/11.2.0/log/vmac1/cssd/ocssd.log
SQL> show parameter disk;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string
SQL> alter system set asm_diskstring='/dev/asm*' ;
System altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG DISMOUNTED
SQL> alter diskgroup SYSDG mount;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG DISMOUNTED
FLASHDG DISMOUNTED
SYSDG MOUNTED
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl replace votedisk +SYSDG
Successful addition of voting disk ac10ac62ec754f84bfac17b1484fc32f.
Successful addition of voting disk 5c459de6405f4f04bf67afb1d57e41f3.
Successful addition of voting disk 73107787ec7c4f11bf9e205e7df6eb5a.
Successfully replaced voting disk group with +SYSDG.
CRS-4266: Voting file(s) successfully replaced
[root@vmac1 ~]#
[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE ac10ac62ec754f84bfac17b1484fc32f (/dev/asm-diskb) [SYSDG]
2. ONLINE 5c459de6405f4f04bf67afb1d57e41f3 (/dev/asm-diskc) [SYSDG]
3. ONLINE 73107787ec7c4f11bf9e205e7df6eb5a (/dev/asm-diskd) [SYSDG]
Located 3 voting disk(s).
/g01/app/grid/product/11.2.0/bin/crsctl stop crs -f
ref:
http://blog.itpub.net/23135684/viewspace-748816
http://blog.csdn.net/bamuta/article/details/9493703
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27036311/viewspace-1176445/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle database 11g rac損壞ocr和votedisk恢復實驗OracleDatabase
- Oracle OCR的備份與恢復Oracle
- Oracle RAC OCR 和 VotingDisk 的備份與恢復Oracle
- Oracle 無備份情況恢復ocr和olrOracle
- Oracle 11g RAMN恢復-控制檔案的備份和恢復Oracle
- Oracle 10G RAC的ocr備份恢復Oracle 10g
- Oracle 10g RAC OCR 和 VotingDisk 的備份與恢復Oracle 10g
- Oracle OCR和VOTEDISK故障修復Oracle
- Oracle 12c 備份恢復OCR(Oracle Cluster Registry)Oracle
- Oracle 11g RMAN恢復-只讀表空間的恢復Oracle
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- Oracle 11G 恢復目錄Oracle
- Oracle 11g 例項恢復Oracle
- Oracle 11g RMAN 異機恢復Oracle
- Oracle例項恢復和介質恢復Oracle
- rman恢復方案和oracle異機恢復Oracle
- Oracle 10gR2 RAC 沒有備份的情況下恢復ocr和voteOracle 10g
- Oracle 11g 手工不完全恢復Oracle
- Oracle 11g 資料庫恢復（一）Oracle資料庫
- oracle冷備份、恢復和異機恢復Oracle
- oracle database 例項恢復和介質恢復OracleDatabase
- Oracle 11g 備份和恢復 基本概念快速入門Oracle
- Oracle 備份和恢復Oracle
- oracle 11G r2 異機恢復Oracle
- Oracle 11g R2 備份與恢復Oracle
- ASM之OCR所在磁碟組損壞後的恢復ASM
- 【kingsql分享】RAC11G 恢復OCRSQL
- Oracle10g RAC voting disk及OCR 的映象，備份恢復[final]Oracle
- 針對11.2 RAC丟失OCR和Votedisk所在ASM Diskgroup的恢復手段ASM
- 【oracle】統計資訊的恢復和備份Oracle
- ORACLE 11g TSPITR恢復被刪除的表空間Oracle
- Oracle 備份和恢復介紹Oracle
- [zt]Oracle rac 11g線上新增ocr,votediskOracle
- 11g RAC OCR,VOTING DISK儲存全部損壞，利用自動備份，恢復OCR,VOTING DISK到新儲存。
- Oracle 11g 手工不完全恢復 場景1：被動的不完全恢復（日誌缺失）Oracle
- oracle12c新特性（8）--RMAN中的表恢復和分割槽恢復Oracle
- Oracle 11g 資料庫恢復-場景5：部分檔案損壞恢復,開庫狀態,低可用恢復方式Oracle資料庫
- Oracle 11g 資料庫恢復-場景4：部分檔案損壞恢復,開庫狀態, 高可用恢復方式Oracle資料庫