RAC 11.2.0.3 管理OLR檔案
1, 分別在節點node1,node2 檢查OLR的狀態
[root@node1 ~]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2652
Available space (kbytes) : 259468
ID : 231588647
Device/File Name : /g01/grid/app/11.2.0/grid/cdata/node1.olr
Device/File integrity check succeeded
Local registry integrity check succeeded
Logical corruption check succeeded
[root@node2 ~]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2652
Available space (kbytes) : 259468
ID : 1577698888
Device/File Name : /g01/grid/app/11.2.0/grid/cdata/node2.olr
Device/File integrity check succeeded
Local registry integrity check succeeded
Logical corruption check succeeded
2,備份和恢復OLR
檢視當前備份記錄
[root@node1 ~]# ocrconfig -local -showbackup
node1 2014/06/11 10:42:30 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140611_104230.olr
[root@node1 ~]#
執行手工備份
[root@node1 ~]# date
Wed Jul 2 07:16:04 CST 2014
[root@node1 ~]# ocrconfig -local -manualbackup
node1 2014/07/02 07:13:06 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140702_071306.olr
node1 2014/06/11 10:42:30 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140611_104230.olr
3,在節點node1關閉clusterware
[root@node1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.cvu' on 'node1'
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.ORCVOTE.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.prod.db' on 'node1'
CRS-2677: Stop of 'ora.node2.vip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.cvu' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'node2'
CRS-2676: Start of 'ora.cvu' on 'node2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'node1' succeeded
CRS-2676: Start of 'ora.node2.vip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'node2'
CRS-2677: Stop of 'ora.prod.db' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2677: Stop of 'ora.ARCH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node1'
CRS-2677: Stop of 'ora.node1.vip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.node1.vip' on 'node2'
CRS-2676: Start of 'ora.node1.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.ORCVOTE.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'node1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node1'
CRS-2677: Stop of 'ora.crf' on 'node1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node1'
CRS-2677: Stop of 'ora.gipcd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node1'
CRS-2677: Stop of 'ora.gpnpd' on 'node1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
4,恢復OCR,選擇之前手工備份的20140702_071306版本
[root@node1 ~]# ocrconfig -local -restore \
> /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140702_071306.olr
5,在節點node1重啟啟動clusterware
[root@node1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
6,檢測OLR
[grid@node1 ~]$ cluvfy comp olr
Verifying OLR integrity
Checking OLR integrity...
Checking OLR config file...
OLR config file check successful
Checking OLR file attributes...
OLR file check successful
WARNING:
This check does not verify the integrity of the OLR contents. Execute 'ocrcheck -local' as a privileged user to verify the contents of OLR.
OLR integrity check passed
Verification of OLR integrity was successful.
7,匯出OLR
[root@node1 ~]# ocrconfig -local -export /home/grid/olr_export
[root@node1 ~]# ls -al /home/grid/olr_export
-rw------- 1 root root 94653 Jul 2 07:39 /home/grid/olr_export
匯入OLR
[root@node1 ~]# ocrconfig -local -import /home/grid/olr_export
[root@node1 ~]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2652
Available space (kbytes) : 259468
ID : 231588647
Device/File Name : /g01/grid/app/11.2.0/grid/cdata/node1.olr
Device/File integrity check succeeded
Local registry integrity check succeeded
Logical corruption check succeeded
[root@node2 ~]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2652
Available space (kbytes) : 259468
ID : 1577698888
Device/File Name : /g01/grid/app/11.2.0/grid/cdata/node2.olr
Device/File integrity check succeeded
Local registry integrity check succeeded
Logical corruption check succeeded
2,備份和恢復OLR
檢視當前備份記錄
[root@node1 ~]# ocrconfig -local -showbackup
node1 2014/06/11 10:42:30 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140611_104230.olr
[root@node1 ~]#
執行手工備份
[root@node1 ~]# date
Wed Jul 2 07:16:04 CST 2014
[root@node1 ~]# ocrconfig -local -manualbackup
node1 2014/07/02 07:13:06 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140702_071306.olr
node1 2014/06/11 10:42:30 /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140611_104230.olr
3,在節點node1關閉clusterware
[root@node1 ~]# crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.cvu' on 'node1'
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.ORCVOTE.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.prod.db' on 'node1'
CRS-2677: Stop of 'ora.node2.vip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.cvu' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'node2'
CRS-2676: Start of 'ora.cvu' on 'node2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'node1' succeeded
CRS-2676: Start of 'ora.node2.vip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'node2'
CRS-2677: Stop of 'ora.prod.db' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2677: Stop of 'ora.ARCH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node1'
CRS-2677: Stop of 'ora.node1.vip' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.node1.vip' on 'node2'
CRS-2676: Start of 'ora.node1.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.ORCVOTE.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'node1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node1'
CRS-2677: Stop of 'ora.crf' on 'node1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node1'
CRS-2677: Stop of 'ora.gipcd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node1'
CRS-2677: Stop of 'ora.gpnpd' on 'node1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
4,恢復OCR,選擇之前手工備份的20140702_071306版本
[root@node1 ~]# ocrconfig -local -restore \
> /g01/grid/app/11.2.0/grid/cdata/node1/backup_20140702_071306.olr
5,在節點node1重啟啟動clusterware
[root@node1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
6,檢測OLR
[grid@node1 ~]$ cluvfy comp olr
Verifying OLR integrity
Checking OLR integrity...
Checking OLR config file...
OLR config file check successful
Checking OLR file attributes...
OLR file check successful
WARNING:
This check does not verify the integrity of the OLR contents. Execute 'ocrcheck -local' as a privileged user to verify the contents of OLR.
OLR integrity check passed
Verification of OLR integrity was successful.
7,匯出OLR
[root@node1 ~]# ocrconfig -local -export /home/grid/olr_export
[root@node1 ~]# ls -al /home/grid/olr_export
-rw------- 1 root root 94653 Jul 2 07:39 /home/grid/olr_export
匯入OLR
[root@node1 ~]# ocrconfig -local -import /home/grid/olr_export
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29047826/viewspace-1210650/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC 11.2.0.3 管理OCR檔案
- RAC 11.2.0.3 ASM管理 (一) 引數ASM
- RAC 11.2.0.3 維護命令(三) SRVCTL管理services
- Oracle RAC引數檔案管理Oracle
- 11G RAC OLR維護命令
- 變更oracle 11.2.0.3 rac sga自動管理為sga手工管理Oracle
- 11.2.0.3 AIX RAC下$ORACLE_HOME/dbs生成大量core_* dump檔案AIOracle
- RAC 11.2.0.3 修改 Public IP
- RAC 11.2.0.3 修改VIP地址
- Oracle叢集技術 | OLR與套接字檔案(二)Oracle
- OEL 11.2.0.2 RAC 資料庫停電導致has程式無法啟動OLR檔案損壞資料庫
- Oracle 叢集的自啟動,OLR與套接字檔案Oracle
- 變更oracle 11.2.0.3 rac sga手工管理為sga及pga全自動管理Oracle
- 搭建Physical ADG 11.2.0.3 for RAC
- RAC 11.2.0.3 SACN與DNS配置DNS
- RAC 11.2.0.3 維護命令 (二)
- RAC 11.2.0.3 維護命令 (一)
- Oracle 21C OCR和OLR管理Oracle
- 管理OCR,OLR,Voting Disk(筆記)筆記
- 11gR2 OCRDUMP檢視OCR/OLR檔案的內容
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- grid 的解除安裝(RAC 11.2.0.3)
- 11.2.0.3 RAC 全過程--8.Oracle RAC ssh ConfigureOracle
- RAC下新增控制檔案
- redhat6.2安裝oracle11.2.0.3RACRedhatOracle
- 11.2.0.3 RAC 靜默安裝第二彈
- 11.2.0.3 RAC 靜默安裝第一彈
- 11.2.0.3 RAC 全過程--7.NTP ServerServer
- 【RAC】Oracle 10g RAC 重建控制檔案Oracle 10g
- Oracle 11.2.0.3 patchSet 及7個解壓檔案內容Oracle
- 檔案管理
- Oracle 11.2.0.3 管理ASM例項OracleASM
- Oracle 11.2.0.3管理ASM例項OracleASM
- 如何重建RAC的控制檔案
- RAC環境重建控制檔案
- RAC的告警日誌檔案
- rac中的密碼檔案密碼
- rhel6.4-11.2.0.3-RAC搭建單節點DG