RAC意外删除OCR VOTE DISK的恢复(无备份)

简介: 转自METALINK How to Recreate OCR/Voting Disk Accidentally Deleted [ID 399482.1] If none of the steps documented above can be used t...

转自METALINK

How to Recreate OCR/Voting Disk Accidentally Deleted [ID 399482.1]

If none of the steps documented above can be used to restore the file that was accidentally deleted or is corrupted, then the following steps can be used to re-create/reinstantiate these files. The following steps require complete downtime on all the nodes.

  1. Shutdown the Oracle Clusterware stack on all the nodes using command crsctl stop crs as root user.
  2. Backup the entire Oracle Clusterware home.
  3. Execute /install/rootdelete.sh on all nodes
  4. Execute /install/rootdeinstall.sh on the node which is supposed to be the first node
  5. The following commands should return nothing
    • ps -e | grep -i 'ocs[s]d'
    • ps -e | grep -i 'cr[s]d.bin'
    • ps -e | grep -i 'ev[m]d.bin'
  6. Execute /root.sh on first node
  7. After successful root.sh execution on first node Execute root.sh on the rest of the nodes of the cluster   这里可能要执行Vicpa 来配置虚拟IP
  8. For 10gR2, use racgons. For 11g use onsconfig command. Examples for each are provided below.

    For 10g
    Execute as owner (generally oracle) of CRS_HOME command
    /install/racgons add_config hostname1:port hostname2:port
    $/u01/crs/install/racgons add_config halinux1:6251 halinux2:6251

    For 11g
    Execute as owner (generally oracle) of CRS_HOME command
    /install/onsconfig add_config hostname1:port hostname2:port
    $/u01/crs/install/onsconfig add_config halinux1:6251 halinux2:6251

  9. Execute as owner of CRS_HOME (generally oracle)  /bin/oifcfg setif -global. Please review Note 283684.1 for details.

    $/u01/crs/bin/oifcfg setif -global  eth0/192.168.0.0:cluster_interconnect eth1/10.35.140.0:public

  10. Add listener using netca. This may give errors if the listener.ora contains the entries already. If this is the case, move the listener.ora to /tmp from the $ORACLE_HOME/network/admin or from the $TNS_ADMIN directory if the TNS_ADMIN environmental is defined and then run netca. Add all the listeners that were added earlier.
  11. Add ASM & database resource to the OCR using the appropriate srvctl add database command as the user who owns the ASM & database resource. Please ensure that this is not run as root user
  12. Add  Instance, services using approproate srvctl add commands. Please refer to the documentation for the exact commands.
  13. execute cluvfy stage -post crsinst -n node1,node2    ### Please ensure to replace node1,node2 with the node names of the cluster
 
加入资源的语句
srvctl add database -d crm -o /ora/ora10
srvctl add instance -d crm -i  crm01 -n gm01
srvctl add instance -d crm -i  crm02 -n gm02
srvctl add instance -d crm -i  crm03 -n gm03
srvctl add asm -n crmnode1 -i asm1 -o /ora/ora10
srvctl add  service -d crm -s sales -r crm01,crm02 -a crm03
加入的SERVICE我报错了。
 
修复完成后任然有个节点ONS没启动起来
2011-04-22 11:45:58.958: [  CRSRES][2728385424]0Start of `ora.rac2.ons` on member `rac2` failed.
2011-04-22 11:45:58.967: [  CRSRES][2728385424]0rac1 : CRS-1019: Resource ora.rac2.ons (application) cannot run on rac1
 
但是其他的都正常了。待解决
相关文章
|
11月前
|
数据库 数据安全/隐私保护
使用rman把单机的备份集恢复到RAC的方法
环境准备 在ASM磁盘组里面创建相应的目录
160 0
|
1月前
|
存储 运维 Oracle
Oracle系列十八:Oracle RAC
Oracle系列十八:Oracle RAC
|
2月前
|
Oracle 关系型数据库
oracle Hanganalyze no RAC
oracle Hanganalyze no RAC
15 0
|
2月前
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
25 3
|
6月前
|
Oracle 关系型数据库 Java
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例