Haha, just said the last one, idle bored and got a test.
Environment:
Os:redhat 5.8
Db:oracle 10.2.0.5 Raw Device
We should develop the habit of often backing up OCR and Votedisk. However, OCR and Votedisk are not backed up and can be rebuilt. Just like the control file. But the process is more troublesome. The following are the detailed steps:
First back up OCR with Votedisk:
[[email protected] ~]#[[email protected] ~]# ocrcheckstatus of Oracle Cluster Registry is as Follows:v Ersion:2 Total Space (Kbytes): 1048296 used Space (Kbytes): 3292 Available Space (Kbytes): 1045004 id:1891074113 device/file Nam E:/dev/raw/raw1 device/file integrity check succeeded Device/file Nam E:/dev/raw/raw2 device/file integrity check succeeded Cluster Registr Y integrity check succeeded[[email protected] ~]# crsctl qeury CSS Votediskunknown parameter:qeury[[email Protected] ~]# crsctl query css Votedisk0. 0/dev/raw/raw31. 0/dev/raw/raw42. 0/dev/raw/raw5[[email protected] ~]# dd if=/dev/raw/raw3 of=/opt/votedisk.bak2097152+0 Records in2097152+0 Recor DS out1073741824 Bytes (1.1 GB) copied, 462.285 seconds, 2.3 mb/s[[email protected] ~]# ocrconfig-export/opt/ocr.bak[[email protected] ~]# cd/opt/[[email Protected] opt]# Lsocr.bak orclfmap Votedisk.bak
To delete a configuration:
[[email protected] install]#./rootdelete.shshutting down Oracle Cluster ready Services (CRS): stopping resources. This could take several minutes. Error while stopping resources. Possible CAUSE:CRSD is down. Shutdown has begun. The daemons should exit soon. Checking to see if Oracle CRS stack are down ... Oracle CRS Stack is not running. Oracle CRS stack is down now. Removing script for Oracle Cluster-servicesupdating OCR file for downgradecleaning-SCR settings in '/etc/oracle/s Cls_scr ' cleaning up Network sockets directories[[email protected] install]#./rootdelete.shshutting down Oracle Cluster ready Services (CRS): stopping resources. This could take several minutes. Error while stopping resources. Possible CAUSE:CRSD is down. Shutdown has begun. The daemons should exit soon. Checking to see if Oracle CRS stack are down ... Oracle CRS Stack is not running. Oracle CRS stack is down now. Removing script for Oracle Cluster ready servicesupdating OCR file for downgradecleaning up SCRSettings in '/etc/oracle/scls_scr ' cleaning up Network socket directories is performed on the installation node: [[email protected] install]#. Rootdeinstall.shremoving contents from OCR Mirror device2560+0 records in2560+0 records out10485760 bytes (ten MB) copied, 0.521651 seconds, 20.1 mb/sremoving contents from OCR device2560+0 records in2560+0 records out10485760 bytes (Ten MB) Copi Ed, 0.496207 seconds, 21.1 MB/s
To re-run the root script:
[[email protected] crs]#./root.shwarning:directory '/u01/app/oracle ' is not owned by Rootwarning:directory '/u01/ App ' isn't owned by Rootwarning:directory '/u01 ' are not owned by Rootno value set for the CRS parameter crs_ocr_location S. Using Values in paramfile.crschecking-if Oracle CRS stack is already configuredsetting the permissions on OCR BA Ckup directorysetting up NS directoriesoracle Cluster Registry configuration upgraded successfullywarning:directory '/u0 1/app/oracle ' is not owned by Rootwarning:directory '/u01/app ' are not owned by Rootwarning:directory '/u01 ' are not owned By rootsuccessfully accumulated necessary OCR keys. Using ports:css=49895 crs=49896 evmc=49898 and Evmr=49897.node <nodenumber>: <nodename> <private Interconnect name>
Configure VIP
[Email protected] crs]# oifcfg getif[[email protected] crs]# oifcfg iflisteth0 192.168.56.0eth1 192.168.11.0[ [Email protected] crs]# oifcfg setif-global eth0/192.168.56.0:public[[email protected] crs]# oifcfg Setif-global EHT1/19 2.168.11.0:cluster_interconnect[[email protected] crs]# oifcfg getifeth0 192.168.56.0 Global PUBLICEHT1 192.168.11.0 global cluster_interconnect run VIPCA configuration VIP
View results:[Email protected] crs]# crs_stat-tname Type Target State Host ------------------------------ ------------------------------ORA.RAC1.GSD application online online rac1 ora.rac1.ons Application Online online rac1 ora.rac1.vip application online online rac1 ORA.RAC2.GSD application online online rac2 ora.rac2.ons application Online online rac2 ora.rac2.vip application online online
Configuring monitoring:
[Email protected] admin]# MV Listener.ora Listener.ora.bak
[Email protected] admin]# MV Listener.ora Listener.ora.bak
Creating a listener using NETCA[Email protected] admin]# crs_stat-tname Type Target State Host ---------------------------- --------------------------------ora .... C1.lsnr application online online rac1 ora.rac1.gsd application online online Rac1 ora.rac1.ons application online online rac1 ora.rac1.vip Application online online rac1 ora .... C2.lsnr application online online rac2 ora.rac2.gsd application online Online rac2 ora.rac2.ons application online online rac2 ora.rac2.vip Application online online rac2
To add a database to CRS:
[Email protected] ~]$ srvctl add database-d zhdb-o $ORACLE _homeStart the database:
Srvctl Start database-d zhdb
[Email protected] dbs]$ crs_stat-tname Type Target State Host ------------------------------ ------------------------------ora .... C1.lsnr application online online rac1 ora.rac1.gsd application online online Rac1 ora.rac1.ons application online online rac1 ora.rac1.vip Application online online rac1 ora .... C2.lsnr application online online rac2 ora.rac2.gsd application online Online rac2 ora.rac2.ons application online online rac2 ora.rac2.vip Application online online rac2 ora.zhdb.db application online online Rac1 ora....b2.inst application online online rac2
Since this OCR and Votedisk reconstruction success
Oracle RAC rebuilds OCR and Votedisk