DB开关机
Single
开db时:先开db,再开listener
关db时:先关listener,再关db
RAC
开机
l 电源:先开1、再开2
l 状态确认
crs_stat –t
srvctl status database –d phamw
srvctl status nodeapps –n phamw1
srvctl status nodeapps –n phamw2
l 开db-à 开node资源
srvctl start database –d phamw(若还未running,则重开db)
srvctl start nodeapps –n phamw1
srvctl start nodeapps –n phamw2
关机:
关db—>关node—>关instance
l
srvctl stop database –d phamw (关闭数据库)
l
srvctl stop nodeapps –n phamw1 (关闭nodeapps1)
srvctl stop nodeapps –n phamw2 (关闭nodeapps2)
l
srvctl stop instance –d phamw –i phamw1 (关闭instance)
srvctl stop instance –d phamw –I phamw2 (关闭instance)
crs_stat –t (若所有进程Offline,则将os关闭)
sync;sync;sync;init 0
RHCS:
1、关(root)
1、sql>shutdown immediate
或 clusvcadm -d ora-phaindb
clusvcadm -d ora-phaecdb
2、clustat –i 3(确认数据库已关闭状态,数据库Stat均为disable)
2、sync;sync;sync;init 0
2、开(root)
./ rgmanager start
clusvcadm -e ora-phaindb1 -m phaindb(启动数据库各节点)
clusvcadm -e ora-phaecdb1 -m phaecdb(启动数据库各节点)
clustat –i 3 (确认数据库启动状态,数据库Stat均为started)
3、切换
clusvcadm -r ora-phaindb1 -m phaindb(切换数据库服务到另一节点上)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23490498/viewspace-676746/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23490498/viewspace-676746/