共計(jì) 14299 個(gè)字符，預(yù)計(jì)需要花費(fèi) 36 分鐘才能閱讀完成。
本篇內(nèi)容主要講解“RAC11G 恢復(fù) OCR 的方法是什么”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強(qiáng)。下面就讓丸趣 TV 小編來(lái)帶大家學(xué)習(xí)“RAC11G 恢復(fù) OCR 的方法是什么”吧!
1. 檢查 ocr
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3232
Available space (kbytes) : 258888
ID : 811139123
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
2. 檢查 votedisk
[root@rac2 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 4b031d63f88f4f0cbf5cc8688884d5f2 (/dev/asm-diskb) [OCR]
2. ONLINE 1acaf51067b94fcdbf62f9a4400050d2 (/dev/asm-diskc) [OCR]
3. ONLINE 8b7b21ad7d114f21bf5e703ec4ccc44e (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
3. 導(dǎo)出 ocr
[root@rac2 ~]# ocrconfig -export /tmp/ocr_20160202.dmp
[root@rac2 ~]# ll tmp | grep 2016
ls: 無(wú)法訪問(wèn) tmp: 沒(méi)有那個(gè)文件或目錄
[root@rac2 ~]# ll /tmp | grep 2016
-rw——- 1 root root 114426 2 月 2 11:06 ocr_20160202.dmp
4. 查看備份
[root@rac2 ~]# ocrconfig -showbackup
rac2 2016/02/01 17:30:53 /g01/11ggrid/app/11.2.3/grid/backup00.ocr
rac2 2016/02/01 13:30:53 /g01/11ggrid/app/11.2.3/grid/backup01.ocr
rac2 2016/02/01 09:30:52 /g01/11ggrid/app/11.2.3/grid/backup02.ocr
rac2 2016/01/31 01:30:49 /g01/11ggrid/app/11.2.3/grid/day.ocr
rac1 2016/01/26 20:52:17 /g01/11ggrid/app/11.2.3/grid/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
5.
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:07:09 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL create pfile= /home/grid/asm_pfile20160202.txt from spfile;
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[root@rac1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2673: Attempting to stop ora.cssdmonitor on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.cssdmonitor on rac1 succeeded
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ora.mdnsd on rac1
CRS-2676: Start of ora.mdnsd on rac1 succeeded
CRS-2672: Attempting to start ora.gpnpd on rac1
CRS-2676: Start of ora.gpnpd on rac1 succeeded
CRS-2672: Attempting to start ora.cssdmonitor on rac1
CRS-2672: Attempting to start ora.gipcd on rac1
CRS-2676: Start of ora.cssdmonitor on rac1 succeeded
CRS-2676: Start of ora.gipcd on rac1 succeeded
CRS-2672: Attempting to start ora.cssd on rac1
CRS-2672: Attempting to start ora.diskmon on rac1
CRS-2676: Start of ora.diskmon on rac1 succeeded
CRS-2676: Start of ora.cssd on rac1 succeeded
CRS-2679: Attempting to clean ora.cluster_interconnect.haip on rac1
CRS-2672: Attempting to start ora.ctssd on rac1
CRS-2681: Clean of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.cluster_interconnect.haip on rac1
CRS-2676: Start of ora.ctssd on rac1 succeeded
CRS-2676: Start of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.asm on rac1
CRS-2676: Start of ora.asm on rac1 succeeded
[root@rac1 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 4b031d63f88f4f0cbf5cc8688884d5f2 (/dev/asm-diskb) [OCR]
2. ONLINE 1acaf51067b94fcdbf62f9a4400050d2 (/dev/asm-diskc) [OCR]
3. ONLINE 8b7b21ad7d114f21bf5e703ec4ccc44e (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskb bs=1024 count=1000
記錄了 1000+0 的讀入
記錄了 1000+0 的寫(xiě)出
1024000 字節(jié)(1.0 MB) 已復(fù)制，0.0754203 秒，13.6 MB/ 秒
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskc bs=1024 count=1000
記錄了 1000+0 的讀入
記錄了 1000+0 的寫(xiě)出
1024000 字節(jié)(1.0 MB) 已復(fù)制，0.0656402 秒，15.6 MB/ 秒
[root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskd bs=1024 count=1000
記錄了 1000+0 的讀入
記錄了 1000+0 的寫(xiě)出
1024000 字節(jié)(1.0 MB) 已復(fù)制，0.056022 秒，18.3 MB/ 秒
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:23:17 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL startup pfile= /home/grid/asm_pfile20160202.txt
ASM 實(shí)例已啟動(dòng)
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15017: diskgroup OCR cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup OCR
SQL select group_number, disk_number, mount_status, header_status, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
———— ———– ——————— ————————————
PATH
—————————————————————————————————-
0 3 CLOSED CANDIDATE
/dev/asm-diskd
0 4 CLOSED CANDIDATE
/dev/asm-diskb
0 5 CLOSED CANDIDATE
/dev/asm-diskc
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
———— ———– ——————— ————————————
PATH
—————————————————————————————————-
1 2 CACHED MEMBER
/dev/asm-diskg
1 1 CACHED MEMBER
/dev/asm-diskf
1 0 CACHED MEMBER
/dev/asm-diske
6 rows selected.
SQL create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
Diskgroup created.
SQL create spfile= +OCR from pfile= /home/grid/asm_pfile20160202.txt
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ ocrconfig -showbackup
PROT-26: 從本地副本中檢索到了 Oracle 集群注冊(cè)表備份位置
rac2 2016/02/01 13:30:53 /g01/11ggrid/app/11.2.3/grid/backup00.ocr
rac2 2016/02/01 09:30:52 /g01/11ggrid/app/11.2.3/grid/backup01.ocr
rac2 2016/02/01 05:30:52 /g01/11ggrid/app/11.2.3/grid/backup02.ocr
rac2 2016/01/31 01:30:49 /g01/11ggrid/app/11.2.3/grid/day.ocr
rac1 2016/01/26 20:52:17 /g01/11ggrid/app/11.2.3/grid/week.ocr
PROT-25: Oracle 集群注冊(cè)表的手動(dòng)備份不可用
[root@rac1 ~]# ocrconfig -restore /g01/11ggrid/app/11.2.3/grid/week.ocr
[root@rac1 ~]# crsctl replace votedisk +OCR
Diskgroup +OCR is already configured with voting files
CRS-4000: Command Replace failed, or completed with errors.
[root@rac1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.ctssd on rac1
CRS-2673: Attempting to stop ora.asm on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.asm on rac1 succeeded
CRS-2673: Attempting to stop ora.cluster_interconnect.haip on rac1
CRS-2677: Stop of ora.ctssd on rac1 succeeded
CRS-2677: Stop of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2673: Attempting to stop ora.cssd on rac1
CRS-2677: Stop of ora.cssd on rac1 succeeded
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ora.mdnsd on rac1
CRS-2676: Start of ora.mdnsd on rac1 succeeded
CRS-2672: Attempting to start ora.gpnpd on rac1
CRS-2676: Start of ora.gpnpd on rac1 succeeded
CRS-2672: Attempting to start ora.cssdmonitor on rac1
CRS-2672: Attempting to start ora.gipcd on rac1
CRS-2676: Start of ora.cssdmonitor on rac1 succeeded
CRS-2676: Start of ora.gipcd on rac1 succeeded
CRS-2672: Attempting to start ora.cssd on rac1
CRS-2672: Attempting to start ora.diskmon on rac1
CRS-2676: Start of ora.diskmon on rac1 succeeded
CRS-2676: Start of ora.cssd on rac1 succeeded
CRS-2679: Attempting to clean ora.cluster_interconnect.haip on rac1
CRS-2672: Attempting to start ora.ctssd on rac1
CRS-2681: Clean of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.cluster_interconnect.haip on rac1
CRS-2676: Start of ora.ctssd on rac1 succeeded
CRS-2676: Start of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2672: Attempting to start ora.asm on rac1
CRS-2676: Start of ora.asm on rac1 succeeded
[root@rac1 ~]# crsctl query css votedisk
Located 0 voting disk(s).
[root@rac1 ~]# su – grid
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 2 月 2 11:38:47 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL startup pfile= /home/grid/asm_pfile20160202.txt
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL set lines 1000
SQL select group_number, disk_number, mount_status, header_status, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS PATH
———— ———– ——————— ———————————— ————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
1 2 CACHED MEMBER /dev/asm-diskg
1 1 CACHED MEMBER /dev/asm-diskf
1 0 CACHED MEMBER /dev/asm-diske
2 2 CACHED MEMBER /dev/asm-diskd
2 0 CACHED MEMBER /dev/asm-diskb
2 1 CACHED MEMBER /dev/asm-diskc
6 rows selected.
SQL create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
create diskgroup OCR normal redundancy disk /dev/asm-diskb , /dev/asm-diskc , /dev/asm-diskd attribute compatible.asm = 11.2.0.0.0 , compatible.rdbms = 11.2.0.0.0
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15030: diskgroup name OCR is in use by another diskgroup
SQL create spfile= +OCR from pfile= /home/grid/asm_pfile20160202.txt
File created.
SQL quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 ~]$ su –
Password:
[root@rac1 ~]# ocrconfig -restore /g01/11ggrid/app/11.2.3/grid/week.ocr
[root@rac1 ~]# crsctl replace votedisk +OCR
Successful addition of voting disk 263eb678cbb34fdfbf3a7e565be61d35.
Successful addition of voting disk 1c39e6bd1fa34f60bfbf691dd9f4f98b.
Successful addition of voting disk 3ccd631501724f95bfc2f3150a2e4201.
Successfully replaced voting disk group with +OCR.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2860
Available space (kbytes) : 259260
ID : 811139123
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@rac1 ~]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
— —– —————– ——— ———
1. ONLINE 263eb678cbb34fdfbf3a7e565be61d35 (/dev/asm-diskb) [OCR]
2. ONLINE 1c39e6bd1fa34f60bfbf691dd9f4f98b (/dev/asm-diskc) [OCR]
3. ONLINE 3ccd631501724f95bfc2f3150a2e4201 (/dev/asm-diskd) [OCR]
Located 3 voting disk(s).
[root@rac1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on rac1
CRS-2673: Attempting to stop ora.ctssd on rac1
CRS-2673: Attempting to stop ora.asm on rac1
CRS-2673: Attempting to stop ora.mdnsd on rac1
CRS-2677: Stop of ora.mdnsd on rac1 succeeded
CRS-2677: Stop of ora.ctssd on rac1 succeeded
CRS-2677: Stop of ora.asm on rac1 succeeded
CRS-2673: Attempting to stop ora.cluster_interconnect.haip on rac1
CRS-2677: Stop of ora.cluster_interconnect.haip on rac1 succeeded
CRS-2673: Attempting to stop ora.cssd on rac1
CRS-2677: Stop of ora.cssd on rac1 succeeded
CRS-2673: Attempting to stop ora.gipcd on rac1
CRS-2677: Stop of ora.gipcd on rac1 succeeded
CRS-2673: Attempting to stop ora.gpnpd on rac1
CRS-2677: Stop of ora.gpnpd on rac1 succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on rac1 has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 ~]# reboot
[grid@rac1 ~]$ crs_stat -v -t
名稱(chēng) 類(lèi)型 R/RA F/FT 目標(biāo) 狀態(tài) 主機(jī)
———————————————————————-
ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE rac1
ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE rac1
ora….N1.lsnr ora….er.type 0/5 0/0 ONLINE ONLINE rac1
ora.OCR.dg ora….up.type 0/5 0/ ONLINE ONLINE rac1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE rac1
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora.kingsql.db ora….se.type 0/2 0/1 ONLINE ONLINE rac1
ora….network ora….rk.type 0/5 0/ ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE rac1
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1
ora….SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora….C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip ora….t1.type 0/0 0/0 ONLINE ONLINE rac1
ora….SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora….C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip ora….t1.type 0/0 0/0 ONLINE ONLINE rac2
ora.scan1.vip ora….ip.type 0/0 0/0 ONLINE ONLINE rac1
到此，相信大家對(duì)“RAC11G 恢復(fù) OCR 的方法是什么”有了更深的了解，不妨來(lái)實(shí)際操作一番吧！這里是丸趣 TV 網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！
