oracle 10g 如何用srvctl 添加数据库资源到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 <database name> -o <ORACLE_HOME path> -p <spfile location and name>

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.

srvctl modify instance -d <db_unique_name> -i <SID1> -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_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

添加成功。