oracle 10g 如何用srvctl添加数据库资源到rac cluster中

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:402

oracle 10g 如何用srvctl 添加数据库资源到rac cluster中

我上次做实验遇到个案例,就是OCR和VOTE盘信息丢失,导致CRS起不来,不得不重装CRS
重装CRS后,我们这个时候需要添加以前的数据库和实例资源,监听我们可以通过netca重建
18) After configuring the listener,you have to add the database in cluster as below

srvctl add database -d -o -p

srvctl add instance -d -i -n

srvctl add instance -d -i -n
19) in case ASM is used, add the rdbms instance / asm dependency, e.g.
srvctl modify instance -d -i -s <+ASM1>

注册前安装好的的集群状态如下: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_lvsrvctl add instance -d orcl -i orcl1 -n p520srvctl 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 [size=1]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 -tName 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 添加成功。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】