Oracle Study之案例--Oracle 11g RAC环境下手工建库
$ srvctl add database -d test -o $ORACLE_HOME$ srvctl add instance -d test -i test1 -n rac1
$ srvctl add instance -d test -i test2 -n rac2
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.prod.db application ONLINE ONLINE rac2
ora....d1.inst application ONLINE ONLINE rac1
ora....d2.inst application ONLINE ONLINE rac2
ora....SM1.asm application OFFLINE OFFLINE
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....SM2.asm application ONLINE ONLINE rac2
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.test.db application OFFLINE OFFLINE
ora....t1.inst application OFFLINE OFFLINE
ora....t2.inst application OFFLINE OFFLINE
$ crs_stat|grep asm
NAME=ora.rac1.ASM1.asm
NAME=ora.rac2.ASM2.asm
$ crs_start -f ora.rac1.ASM1.asm
Attempting to start `ora.rac1.ASM1.asm` on member `rac1`
Start of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.prod.db application ONLINE ONLINE rac2
ora....d1.inst application ONLINE ONLINE rac1
ora....d2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
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....SM2.asm application ONLINE ONLINE rac2
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.test.db application OFFLINE OFFLINE
ora....t1.inst application OFFLINE OFFLINE
ora....t2.inst application OFFLINE OFFLINE
$ crs_stat|grep inst
NAME=ora.prod.prod1.inst
NAME=ora.prod.prod2.inst
NAME=ora.test.test1.inst
NAME=ora.test.test2.inst
$ crs_stat|grep db
NAME=ora.prod.db
NAME=ora.test.db
$ crs_start -f ora.test.test1.inst
Attempting to start `ora.test.test1.inst` on member `rac1`
Start of `ora.test.test1.inst` on member `rac1` succeeded.
$ crs_start -f ora.test.test2.inst
Attempting to start `ora.test.test2.inst` on member `rac2`
Start of `ora.test.test2.inst` on member `rac2` succeeded.
$ crs_start -f ora.test.db
Attempting to start `ora.test.db` on member `rac1`
Start of `ora.test.db` on member `rac1` succeeded.
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.prod.db application ONLINE ONLINE rac2
ora....d1.inst application ONLINE ONLINE rac1
ora....d2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
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....SM2.asm application ONLINE ONLINE rac2
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.test.db application ONLINE ONLINE rac1
ora....t1.inst application ONLINE ONLINE rac1
ora....t2.inst application ONLINE ONLINE rac2
$
页:
[1]