RAC11G恢復(fù)OCR的方法是什么

本篇內(nèi)容主要講解“RAC11G恢復(fù)OCR的方法是什么”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學(xué)習(xí)“RAC11G恢復(fù)OCR的方法是什么”吧!

創(chuàng)新互聯(lián)建站-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設(shè)、高性價比愛輝網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫,直接使用。一站式愛輝網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設(shè)找我們，業(yè)務(wù)覆蓋愛輝地區(qū)。費用合理售后完善，十多年實體公司更值得信賴。

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: 無法訪問tmp: 沒有那個文件或目錄
[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 的寫出
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 的寫出
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 的寫出
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 實例已啟動

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 集群注冊表備份位置

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 集群注冊表的手動備份不可用

[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
名稱         類型         R/RA   F/FT   目標(biāo)    狀態(tài)    主機      
----------------------------------------------------------------------
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    

到此，相信大家對“RAC11G恢復(fù)OCR的方法是什么”有了更深的了解，不妨來實際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！

當(dāng)前文章：RAC11G恢復(fù)OCR的方法是什么
URL網(wǎng)址：http://muchs.cn/article48/jejsep.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計公司、定制網(wǎng)站、品牌網(wǎng)站設(shè)計、品牌網(wǎng)站建設(shè)、用戶體驗、電子商務(wù)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)

網(wǎng)站托管運營