oracle 11gR2 RAC的一致性停庫和啟庫
一. 停監聽(任一節點)
[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
ora.ractest.srvtest.svc
1 ONLINE ONLINE node1
2 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
[grid@node1 ~]$ srvctl stop scan_listener
[grid@node1 ~]$ srvctl stop listener
grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
ora.ractest.srvtest.svc
1 ONLINE ONLINE node1
2 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
二. 殺會話(兩個節點)
select 'alter system disconnect session ''' ||sid||','||serial#||''' immediate;' from v$session where type='USER';
三. 做檢查點操作(兩個節點)
alter system switch logfile;
alter system checkpoint;
四. 關閉資料庫和CRS
(1)關庫(任一節點)
[grid@node1 ~]$ srvctl stop database -d ractest -o immediate
[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.ractest.srvtest.svc
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE node2
(2)關CRS(兩個節點)
root使用者:
[root@node1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
[root@node2 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
五. 停ASM(兩個節點)
如果要停ASM,root使用者下:
[root@node1 ~]# /etc/init.d/oracleasm stop
[root@node2 ~]# /etc/init.d/oracleasm stop
六. 啟庫
與停庫順序相反
注意:11gR2的RAC,如果是用shutdown immediate而不是用srvctl stop database -d xxx -o immediate停庫,那麼在啟CRS後也需要手動把庫啟起來
如果手動把例項啟起來後,在crsctl status res -t顯示某個例項還是Instance Shutdown的話,但實際上例項是已經啟起來了,可用命令 srvctl start instance -d xxx -n xxx解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25465866/viewspace-1210363/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE 12C RAC資料庫的啟停Oracle資料庫
- Oracle 11gR2 RAC的關閉和啟動Oracle
- 【RAC】使用crsctl工具控制Oracle RAC叢集的啟停Oracle
- 4.1.3 使用 Oracle Restart 元件啟停資料庫OracleREST元件資料庫
- 處理Oracle 11gR2 RAC資料庫資源不能自動啟動的問題Oracle資料庫
- Oracle RAC 11gR2開啟歸檔Oracle
- 處理Oracle 11gR2 RAC資料庫資源不能自動啟動的問題 (轉)Oracle資料庫
- ORACLE 11gR2 單例項資料庫自啟Oracle單例資料庫
- Sybase 資料庫啟停指令碼資料庫指令碼
- oracle 11gR2 rac+asm 資料庫安裝配置步驟OracleASM資料庫
- 配置solaris 10_oracle10g_dbstart_dbshut自動啟停庫Oracle
- 突然停電,資料庫不能啟動資料庫
- oracle 11gR2 rac grid和oracle所屬的組資訊Oracle
- ORACLE RAC 手動建庫Oracle
- 11gR2 靜默安裝RAC 叢集和資料庫軟體資料庫
- Oracle資料庫的啟動和關閉Oracle資料庫
- oracle rac資料庫的安裝Oracle資料庫
- RAC資料庫重啟案例資料庫
- 11gR2 RAC ASM 啟動ASM
- 11gr2 RAC靜默刪除、建立資料庫資料庫
- RAC資料庫啟用歸檔和閃回的步驟資料庫
- oracle 10g rac資料庫不能自動啟動Oracle 10g資料庫
- ORACLE資料庫的啟動和關閉(轉)Oracle資料庫
- Oracle搭建rac到單庫的adgOracle
- RAC 資料庫的啟動與關閉資料庫
- oracle 11gr2 rac 安裝Oracle
- RAC開啟資料庫歸檔資料庫
- 關於oracle 12c多租戶可插拔資料庫的啟停分析(一)Oracle資料庫
- Linux下快速安裝Oracle 11gR2和建立資料庫LinuxOracle資料庫
- Oracle 11gR2 RAC的JDBC連線串OracleJDBC
- oracle 11gR2 RAC crsctl 命令的增強Oracle
- Oracle 11g 測試停庫對job的影響Oracle
- 11gR2 RAC手動新增節點資料庫例項資料庫
- Oracle 資料庫 升級為 RACOracle資料庫
- vgant 安裝oracle資料庫racOracle資料庫
- Oracle 11gR2 RAC修改SCAN IPOracle
- rac 管理 啟動關閉資料庫資料庫
- 11gR2 RAC ASM啟動過程ASM