How to Restore CRS after accidentally run localconfig on RAC system_747415.1
How to Restore CRS after accidentally run localconfig on RAC system (Doc ID 747415.1)
In this Document
Goal |
Solution |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
This could affect any system on 10g
Goal
Localconfig command is used for single instance RDBMS to config cssd which support ASM.
On RAC system, cssd is part of CRS, ASM will be supported once CRS is installed and running.
There is absolutely no requirement to run localconfig on RAC system and it should never be used on RAC system as it will destroy CRS configuration.
In this note, we will discuss a few scenarios related with localconfig command being run on RAC system, include "localconfig delete" and "localconfig reset" and how to restore CRS configuration if localconfig script accidentally run on RAC system for any reason.
Solution
Case I. "$ORACLE_HOME/bin/localconfig delete" has been done on some node(s) but not all of RAC system
Symptoms:
no /etc/oracle/ocr.loc (or /var/opt/oracle/ocr.loc) exist on affected node(s)
The OCR has been removed in case it stands on a clustered file system. The OCRMIRROR still exist in case it has been defined.
Scenario A. If both OCR and OCRMIRROR are on cluster file system
In this scenario, the OCRMIRROR can be used to recreate the OCR. As root user:
1. find the OCR location
2. touch
chown root:oinstall /cfs/ocrdisk1
chmod 640 /cfs/ocrdisk1
3. on one unaffected node, replace the ocr device:
ocrconfig -replace ocr
4. on affected node(s) where "localconfig delete" has been run, as root user, rerun root.sh:
CRS will startup automatically after this.
Scenario B. If only OCR is used, no OCRMIRROR has been defined and it is on cluster file system
As the result of localconfig delete, crsd.bin will go down on the good node(s) as well, crsd.log reports:
[ OCRAPI][1225398592]procr_ctx_set_invalid: aborting...
The OCR need to be recreated from backup.
1. find OCR location
2. touch
chown root:oinstall /cfs/ocrdisk1
chmod 640 /cfs/ocrdisk1
3. look for latest OCR backup generated automatically
4. restore an OCR backup, eg:
Once OCR restored, crsd.bin should start automatically on the good node(s).
5. on bad node(s), rerun
CRS will startup automatically after this.
Scenario C. If OCR or OCRMIRROR is on raw device
localconfig delete will only remove the OCR device name (eg: /dev/raw/raw1), it will not remove the content of raw device.
1. restore the device name
on Linux: as root, run:
Please check with other OS vendor for restore the device name, or a reboot will restore the name too.
2. on bad node(s), rerun
CRS will startup automatically after this.
Case II. "$ORACLE_HOME/bin/localconfig reset" has been done on 1 or all nodes of RAC system
Symptom:
On the node(s) where "localconfig reset" has been run:
1. /etc/oracle/ocr.loc is like:
ocrconfig_loc=/cdata/localhost/local.ocr
local_only=TRUE
2. in /etc/inittab, following lines exist:
h1:35:respawn:/etc/init.d/init.evmd run >/dev/null 2>&1
h3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&1
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1
CRS can not start on the affected node. Reboot will not help.
Solution: on all node(s) where "localconfig reset" has been done:
ocrconfig_loc=/cdata/localhost/local.ocr
local_only=TRUE
If you have modified ocr.loc to point to real OCR device, please restore the content back to above before continue with the followings. Otherwise the following commands will zero out the real OCR device.
as root user:
1. run
2. run
3. run
For all other cases, either restore the OCR from backup or follow Note 399482.1 How to recreate OCR/Voting disk accidentally deleted to reinitialize OCR and voting disks.
References
NOTE:399482.1 - How to Recreate OCR/Voting Disk Accidentally Deleted
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1157111/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to restore ASM based OCR after complete loss of the CRS diskgroupRESTASM
- 10g RAC: How to Clean Up After a Failed CRS InstallAI
- Metlink:10g RAC How to Clean Up After a Failed CRS InstallAI
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- How to restore raid after reinstall LinuxRESTAILinux
- How to Clean Up After a Failed Oracle Clusterware (CRS) InstallationAIOracle
- guarantee restore points-Flashback after RMAN restoreREST
- How restore CBO statisticsREST
- Unable to start HTTP server after restoreHTTPServerREST
- how to clean failed crsAI
- How to restore ASM based OCRRESTASM
- rac02 : CRS-1019: Resource ora.rac01.ons(application) cannot run on rac02APP
- Cannot restore segment prot after reloc:Permission deniedREST
- clean all Oracle 10gR2 CRS after a failed CRS installationOracle 10gAI
- How to delete SLP after backup with storage fundationdelete
- Metlink:How to clean up a failed CRS/ClusterwareAI
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- How To Search and Restore files from Site Collection Recycle BinREST
- Open Resetlogs After Restore Hangs (Doc ID 1455666.1)REST
- CRS can not Start After Node Reboot (文件 ID 733260.1)boot
- How to Run and View a Listener Trace. [ID 147446.1]View
- 【RAC】Oracle11g RAC 你不懂crs_*Oracle
- Oracle Rac crs無法啟動Oracle
- Oracle10g RAC管理 - CRSOracle
- Oracle RAC 日常管理之CRS篇Oracle
- RAC中的srvctl和crs命令
- How to Restore a Lost Voting Disk in 10g [ID 279793.1]REST
- how to run demo city bars using sencha architect
- You may fail to backup log or restore log after TDE certification/key rotation.AIREST
- HowTo Restore RMAN Disk backups of RACREST
- How to drop Oracle RAC database manually?OracleDatabase
- How To Restore Archivelogs That Belongs To Another Incarnation_1326236.1RESTHive
- How to Create or Remove Restore Point on Standby database (文件 ID 1672977.1)REMRESTDatabase
- Oracle RAC 日常管理之CRS篇-3Oracle
- Oracle RAC 日常管理之CRS篇-2Oracle
- 【RAC】如何讓Oracle RAC crs_stat 命令顯示完整Oracle
- Metlink:How to Modify Public Network Information including VIP in CrsORM
- 【RAC】Oracle11g RAC CRS磁碟丟失後恢復Oracle