【kingsql分享】RAC11G 恢復OCR
1.檢查ocr
2.檢查votedisk
3.匯出ocr
4.檢視備份
5.
|
[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.匯出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位元組(1.0 MB)已複製，0.0754203 秒，13.6 MB/秒 [root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskc bs=1024 count=1000 記錄了1000+0 的讀入 記錄了1000+0 的寫出 1024000位元組(1.0 MB)已複製，0.0656402 秒，15.6 MB/秒 [root@rac1 ~]# dd if=/dev/zero of=/dev/asm-diskd bs=1024 count=1000 記錄了1000+0 的讀入 記錄了1000+0 的寫出 1024000位元組(1.0 MB)已複製，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 目標 狀態 主機 ---------------------------------------------------------------------- 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 |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28389881/viewspace-1985542/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【kingsql分享】Oracle18c RAC ADVM卷OFFLINE修復一例SQLOracle
- 【kingsql分享】Linux平臺判斷大小端SQLLinux
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- MongoDB案例分享：如何使用oplog恢復資料MongoDB
- 【北亞資料恢復】sqlserver資料庫被加密的資料恢復案例分享資料恢復SQLServer資料庫加密
- 公眾號被遮蔽到恢復過程分享
- 【kingsql分享】OEL7.6安裝Oracle18c RPM新玩法SQLOracle
- 【kingsql分享】使用BBED修改Oracle資料檔案頭推進SCNSQLOracle
- 【kingsql分享】Oracle Database 19c的各種新特性介紹SQLOracleDatabase
- 【kingsql分享】 多租戶細粒度資源模型 - New Resource Modeling SchemeSQL模型Scheme
- 【kingsql分享】Oracle 18c RAC補丁升級實戰【DBRU】SQLOracle
- 資料恢復：AMDU資料抽取恢復資料恢復
- postgreSQL 恢復至故障點 精準恢復SQL
- 分享個高通平臺NV引數恢復工具-QSerWriteNumber
- 【kingsql分享】Oracle 18c可插拔資料庫艦隊新玩法SQLOracle資料庫
- 【kingsql分享】Oracle Database 20c 十大新特性介紹SQLOracleDatabase
- Vsan資料恢復—Vsan資料恢復案例資料恢復
- MySQL 非常規恢復與物理備份恢復MySql
- 【Vsan資料恢復】Vsan資料恢復案例資料恢復
- 成功案例分享-伺服器3塊硬碟離線恢復成功伺服器硬碟
- [案例分享]華為S5300儲存硬碟掉恢復案例硬碟
- SeSparse資料恢復方案研究及恢復方法演示資料恢復
- RAC備份恢復之Voting備份與恢復
- Sybase ASE資料庫恢復，Sybase資料恢復，資料誤刪除恢復工具READSYBDEVICE資料庫資料恢復dev
- NBU恢復oracleOracle
- RMAN增量恢復
- 怎樣用恢復驅動器來恢復win10 使用恢復驅動器恢復win10系統的步驟Win10
- 順豐刪庫事件有感 - 資料庫資料恢復方法分享事件資料庫資料恢復
- 【VSAN資料恢復】VSAN儲存資料恢復案例資料恢復
- NAS陣列恢復資料資料恢復開盤陣列資料恢復
- 如何恢復SSD NVME固態硬碟的資料恢復硬碟資料恢復
- bitlocker如何恢復金鑰 bitlocker恢復金鑰的方法
- RMAN備份恢復典型案例——異機恢復未知DBID
- 【伺服器資料恢復】Vsan資料恢復案例伺服器資料恢復
- 【資料庫資料恢復】透過恢復NDF檔案修復資料庫的資料恢復過程資料庫資料恢復
- 寶塔資料庫恢復 mysql資料庫丟失恢復 mysql資料庫刪除庫恢復 寶塔mysql資料庫恢復資料庫MySql
- Sybase SQL Anywhere（ASA）資料庫恢復，ASA資料恢復，資料誤刪除恢復工具ReadASADBSQL資料庫資料恢復
- 勒索病毒資料修復恢復
- 伺服器資料恢復成功案例（磁碟陣列恢復）伺服器資料恢復陣列