我上次做实验遇到个案例,就是OCR和VOTE盘信息丢失,导致CRS起不来,不得不重装CRS
重装CRS后,我们这个时候需要添加以前的数据库和实例资源,监听我们可以通过netca重建
18) After configuring the listener,you have to add the database in cluster as below
srvctl add instance -d <database name> -i <instance 1 name> -n <node 1 name >
srvctl add instance -d <database name> -i <instance 2 name> -n <node 2 name >
19) in case ASM is used, add the rdbms instance / asm dependency, e.g.
注册前安装好的的集群状态如下:
ora....20.lsnr application ONLINE ONLINE p520
ora.p520.gsd application ONLINE ONLINE p520
ora.p520.ons application ONLINE ONLINE p520
ora.p520.vip application ONLINE ONLINE p520
ora....50.lsnr application ONLINE ONLINE p650
ora.p650.gsd application ONLINE ONLINE p650
ora.p650.ons application ONLINE ONLINE p650
ora.p650.vip application ONLINE ONLINE p650
srvctl add database -d orcl -o /oracle/app/oracle/product/10.2.0/clusterdb -p /dev/rspfile_lv
srvctl add instance -d orcl -i orcl1 -n p520
srvctl add instance -d orcl -i orcl2 -n p650
注册后的集群状态如下:
ora.orcl.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....20.lsnr application ONLINE ONLINE p520
ora.p520.gsd application ONLINE ONLINE p520
ora.p520.ons application ONLINE ONLINE p520
ora.p520.vip application ONLINE ONLINE p520
ora....50.lsnr application ONLINE ONLINE p650
ora.p650.gsd application ONLINE ONLINE p650
ora.p650.ons application ONLINE ONLINE p650
ora.p650.vip application ONLINE ONLINE p650
启动集群数据库
[oracle@p650:/oracle/app/oracle/product/10.2.0/clusterdb]$srvctl start database -d orcl
[oracle@p650:/oracle/app/oracle/product/10.2.0/clusterdb]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE p520
ora....l1.inst application ONLINE ONLINE p520
ora....l2.inst application ONLINE ONLINE p650
ora....20.lsnr application ONLINE ONLINE p520
ora.p520.gsd application ONLINE ONLINE p520
ora.p520.ons application ONLINE ONLINE p520
ora.p520.vip application ONLINE ONLINE p520
ora....50.lsnr application ONLINE ONLINE p650
ora.p650.gsd application ONLINE ONLINE p650
ora.p650.ons application ONLINE ONLINE p650
ora.p650.vip application ONLINE ONLINE p650
添加成功。
