铁建财务公司重启数据库步骤
1)su - grid --进入用户
2)lsnrctl stop --停用监听
srvctl stop listener -n rac02
srvctl stop listener -n rac01
srvctl start listener -n rac01
srvctl start listener -n rac02
3)停用数据库
srvctl stop db -d vbsrun -o immediate
3)crs_stat -t --查看RAC当前状态(目前正常)
[grid@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ARCH.dg ora....up.type ONLINE ONLINE rac01
ora.DATA.dg ora....up.type ONLINE ONLINE rac01
ora....ER.lsnr ora....er.type ONLINE ONLINE rac01
ora....N1.lsnr ora....er.type ONLINE ONLINE rac02
ora....N2.lsnr ora....er.type ONLINE ONLINE rac01
ora....N3.lsnr ora....er.type ONLINE ONLINE rac01
ora.OCR.dg ora....up.type ONLINE ONLINE rac01
ora.asm ora.asm.type ONLINE ONLINE rac01
ora.cvu ora.cvu.type ONLINE ONLINE rac01
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac01
ora.oc4j ora.oc4j.type ONLINE ONLINE rac01
ora.ons ora.ons.type ONLINE ONLINE rac01
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application OFFLINE OFFLINE
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip ora....t1.type ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application OFFLINE OFFLINE
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip ora....t1.type ONLINE ONLINE rac02
ora....ry.acfs ora....fs.type ONLINE ONLINE rac01
ora.scan1.vip ora....ip.type ONLINE ONLINE rac02
ora.scan2.vip ora....ip.type ONLINE ONLINE rac01
ora.scan3.vip ora....ip.type ONLINE ONLINE rac01
ora.vbsrun.db ora....se.type ONLINE ONLINE rac01
4)停用RAC(请在rac01和rac02分别执行)root用户
/u01/app/11.2.0/grid/bin/crsctl stop cluster -all
5)等待rac状态都是offline之后重启主机
reboot
6)重启主机正常之后 请在rac01上执行开启集群节点
/u01/app/11.2.0/grid/bin/crsctl start cluster -all
7)状态检测
检查状态
[root@rac02 ~]# /u01/app/11.2.0/grid/bin/crs_stat -t -v
8)分别重启数据
startup
1)su - grid --进入用户
2)lsnrctl stop --停用监听
srvctl stop listener -n rac02
srvctl stop listener -n rac01
srvctl start listener -n rac01
srvctl start listener -n rac02
3)停用数据库
srvctl stop db -d vbsrun -o immediate
3)crs_stat -t --查看RAC当前状态(目前正常)
[grid@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ARCH.dg ora....up.type ONLINE ONLINE rac01
ora.DATA.dg ora....up.type ONLINE ONLINE rac01
ora....ER.lsnr ora....er.type ONLINE ONLINE rac01
ora....N1.lsnr ora....er.type ONLINE ONLINE rac02
ora....N2.lsnr ora....er.type ONLINE ONLINE rac01
ora....N3.lsnr ora....er.type ONLINE ONLINE rac01
ora.OCR.dg ora....up.type ONLINE ONLINE rac01
ora.asm ora.asm.type ONLINE ONLINE rac01
ora.cvu ora.cvu.type ONLINE ONLINE rac01
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac01
ora.oc4j ora.oc4j.type ONLINE ONLINE rac01
ora.ons ora.ons.type ONLINE ONLINE rac01
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application OFFLINE OFFLINE
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip ora....t1.type ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application OFFLINE OFFLINE
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip ora....t1.type ONLINE ONLINE rac02
ora....ry.acfs ora....fs.type ONLINE ONLINE rac01
ora.scan1.vip ora....ip.type ONLINE ONLINE rac02
ora.scan2.vip ora....ip.type ONLINE ONLINE rac01
ora.scan3.vip ora....ip.type ONLINE ONLINE rac01
ora.vbsrun.db ora....se.type ONLINE ONLINE rac01
4)停用RAC(请在rac01和rac02分别执行)root用户
/u01/app/11.2.0/grid/bin/crsctl stop cluster -all
5)等待rac状态都是offline之后重启主机
reboot
6)重启主机正常之后 请在rac01上执行开启集群节点
/u01/app/11.2.0/grid/bin/crsctl start cluster -all
7)状态检测
检查状态
[root@rac02 ~]# /u01/app/11.2.0/grid/bin/crs_stat -t -v
8)分别重启数据
startup
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20985606/viewspace-2148369/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20985606/viewspace-2148369/