【MOS】How to backup or restore OLR in 11.2/12c Grid Infrastructure
In this Document
Goal |
Solution |
OLR location |
To backup |
To list backups |
To restore |
References |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and laterInformation in this document applies to any platform.
GOAL
Oracle Local Registry (OLR) is introduced in 11gR2/12c Grid Infrastructure. It contains local node specific configuration required by OHASD and is not shared between nodes; in other word, every node has its own OLR.
This note provides steps to backup or restore OLR.
SOLUTION
OLR location
The OLR location pointer file is '/etc/oracle/olr.loc' or '/var/opt/oracle/olr.loc' depending on platform. The default location after installing Oracle Clusterware is:
GI Cluster: <GI_HOME>/cdata/<hostname.olr>
GI Standalone (Oracle Restart): <GI_HOME>/cdata/localhost/<hostname.olr>
To backup
OLR will be backed up during GI configuration(installation or upgrade). In contrast to OCR, OLR will NOT be automatically backed up again after GI is configured, only manual backups can be taken. If further backup is required, OLR needs to be backed up manually. To take a backup of the OLR use the following command.
To list backups
To List the backups currently available:
# <GI_HOME>/bin/ocrconfig -local -showbackup
node1 2010/12/14 14:33:20 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20101214_143320.olr
node1 2010/12/14 14:33:17 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20101214_143317.olr
Clusterware maintains the history of the five most recent manual backups and will not update/delete a manual backups after it has been created.
$ocrconfig -local -showbackup shows manual backups in the registry though they are removed or archived manually in OS file system by OS commands
#ocrconfig -local -showbackup
node1 2014/02/21 08:02:57 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20140221_080257.olr
node1 2014/02/21 08:02:56 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20140221_080256.olr
node1 2014/02/21 08:02:54 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20140221_080254.olr
node1 2014/02/21 08:02:51 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20140221_080251.olr
node1 2014/02/21 08:02:39 /opt/app/oracle/grid/11.2.0.1/cdata/node1/backup_20140221_080239.olr
#ls -ltr /opt/app/oracle/grid/11.2.0.1/cdata/node1
total 38896
-rw------- 1 root root 6635520 Feb 21 08:02 backup_20140221_080256.olr
-rw------- 1 root root 6635520 Feb 21 08:02 backup_20140221_080257.olr
To restore
Be sure GI stack is completely down and ohasd.bin is not up and running, use the following command to confirm:
This should return no process, if ohasd.bin is still up and running, stop it on local node:
OR
# <GI_HOME>/bin/crsctl stop has <========= for GI Standalone
Once it's down, restore with the following command:
If the command fails, create a dummy OLR, set correct ownership and permission and retry the restoration command:
# cd <OLR location>
# touch <hostname>.olr
# chmod 600 <hostname>.olr
# chown <grid>:<oinstall> <hostname>.olr
Once it's restored, GI can be brought up:
OR
$ <GI_HOME>/bin/crsctl start has <========= for GI Standalone, this must be done as grid user.
About Me
...............................................................................................................................
● 本文來自於MOS轉載文章(文件 ID 1193643.1)
● 小麥苗雲盤地址:http://blog.itpub.net/26736162/viewspace-1624453/
● QQ群:230161599 微信群:私聊
● 聯絡我請加QQ好友(642808185),註明新增緣由
● 版權所有,歡迎分享本文,轉載請保留出處
...............................................................................................................................
手機長按下圖識別二維碼或微信客戶端掃描下邊的二維碼來關注小麥苗的微信公眾號:xiaomaimiaolhr,免費學習最實用的資料庫技術。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2130323/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Grid Infrastructure for a Standalone ServerOracleASTStructServer
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- 將Oracle 12c資料庫註冊到Oracle 19c Grid InfrastructureOracle資料庫ASTStruct
- [20190228]Backup Restore Throttle sleep.txtREST
- db2備份恢復(backup restore)DB2REST
- 【GRID】Grid Infrastructure 啟動的五大問題 (Doc ID 1526147.1)ASTStruct
- cdc目標端資料庫初始化(backup restore)資料庫REST
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- You may fail to backup log or restore log after TDE certification/key rotation.AIREST
- 為11gR2 Grid Infrastructure增加新的public網路ASTStruct
- Oracle rac使用nid和dbms_backup_restore包修改dbid和dbnameOracleREST
- DBMS_BACKUP_RESTORE用於特殊情況下的恢復(轉)REST
- 引數ENABLE_DDL_LOGGING從11.2到12c變化
- 12C grid CDB異機恢復+歸檔(DDL操作)
- 【12c】12c RMAN新特性之通過網路遠端恢復資料庫(RESTORE/Recover from Service)資料庫REST
- guarantee restore points-Flashback after RMAN restoreREST
- canvas restore()CanvasREST
- 11.2
- Oracle 21C OCR和OLR管理Oracle
- native mos
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- canvas save()和restore()CanvasREST
- DOCKER特性 - LIVE RESTOREDockerREST
- 11.2 模型finetune模型
- mos初階
- md_backup
- Terraform基礎入門 (Infrastructure as Code)ORMASTStruct
- 初探 Infrastructure as Code 工具 Terraform vs PulumiASTStructORM
- grid
- MOS管隨筆
- 【MOS】手動升級到資料庫 12c 版本1(12.1)的完整核對清單 (文件 ID 2047701.1)資料庫
- 【SEED Labs】Public-Key Infrastructure (PKI) LabASTStruct
- [LeetCode] 93. Restore IP AddressesLeetCodeREST
- git操作之二:git restoreGitREST
- provider for back&restore app datyaIDERESTAPP
- How to ssh
- RAC and Grid
- Grid Points
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM