您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

Oracle RAC 11.2(12C)正确关闭顺序

2025/10/23 8:53:01发布25次查看
在11.2后的版本中crs被称为gi,通过crsctl stop cluster来关闭整个实例的资源非常方便,但是对于数据库实例需要单独关闭,stop cl
在11.2后的版本中crs被称为gi,通过crsctl stop cluster来关闭整个实例的资源非常方便,,但是对于数据库实例需要单独关闭,stop cluster对于实例直接以非正常的方式结束,环境是基于12c的。
正确的顺序:
先关闭数据库
[oracle@rac1 ~]$ srvctl stop database -db tt
alert.log显示是通过immediate方式关闭.
sat apr 19 05:12:19 2014
 shutting down instance (immediate)
 stopping background process smco
 shutting down instance: further logons disabled
 stopping background process cjq0
 sat apr 19 05:12:28 2014
 killed process oracle@rac1 (qm05) with pid is 58, os pid 26310
 stopping background process mmnl
 stopping background process mmon
 license high water mark = 8
 all dispatchers and shared servers shutdown
 alter database close normal /* db agent *//* {1:28512:1593} */
 sat apr 19 05:12:33 2014
 smon: disabling tx recovery
 sat apr 19 05:12:33 2014
确认一下配置oracle实例是不是immediate方式来关闭的。
[oracle@rac1 ~]$ srvctl config database -db tt
 database unique name: tt
 database name: tt
 oracle home: /u01/app/oracle/product/12.1.0.0/db_1
 oracle user: oracle
 spfile: +data/tt/spfilett.ora
 password file: +data/tt/orapwtt
 domain:
start options: open
 stop options: immediate
 database role: primary
 management policy: automatic
 server pools: tt
 database instances: tt1,tt2
 disk groups: data
 mount point paths:
services:
type: rac
 start concurrency:
stop concurrency:
database is administrator managed
 [oracle@rac1 ~]$
错误的方法:
为图省事,直接关闭整个cluster
[root@rac1 ~]# crsctl stop cluster -all
crs-2673: attempting to stop 'ora.crsd' on 'rac1'
 crs-2790: starting shutdown of cluster ready services-managed resources on 'rac1'
 crs-2673: attempting to stop 'ora.listener.lsnr' on 'rac1'
 crs-2673: attempting to stop 'ora.ocr1.dg' on 'rac1'
 crs-2673: attempting to stop 'ora.tt.db' on 'rac1'
 crs-2673: attempting to stop 'ora.listener_scan1.lsnr' on 'rac1'
 crs-2673: attempting to stop 'ora.cvu' on 'rac1'
 crs-2677: stop of 'ora.listener.lsnr' on 'rac1' succeeded
 crs-2673: attempting to stop 'ora.rac1.vip' on 'rac1'
 crs-2677: stop of 'ora.listener_scan1.lsnr' on 'rac1' succeeded
 crs-2673: attempting to stop 'ora.scan1.vip' on 'rac1'
 crs-2677: stop of 'ora.cvu' on 'rac1' succeeded
 crs-2677: stop of 'ora.tt.db' on 'rac1' succeeded
 crs-2673: attempting to stop 'ora.data.dg' on 'rac1'
 crs-2677: stop of 'ora.rac1.vip' on 'rac1' succeeded
 crs-2677: stop of 'ora.scan1.vip' on 'rac1' succeeded
 crs-2673: attempting to stop 'ora.crsd' on 'rac2'
 crs-2790: starting shutdown of cluster ready services-managed resources on 'rac2'
 crs-2673: attempting to stop 'ora.tt.db' on 'rac2'
 crs-2673: attempting to stop 'ora.ocr1.dg' on 'rac2'
 crs-2673: attempting to stop 'ora.listener.lsnr' on 'rac2'
 crs-2677: stop of 'ora.listener.lsnr' on 'rac2' succeeded
 crs-2673: attempting to stop 'ora.rac2.vip' on 'rac2'
 crs-2677: stop of 'ora.rac2.vip' on 'rac2' succeeded
 crs-2677: stop of 'ora.data.dg' on 'rac1' succeeded
 crs-2677: stop of 'ora.tt.db' on 'rac2' succeeded
 crs-2673: attempting to stop 'ora.data.dg' on 'rac2'
 crs-2677: stop of 'ora.data.dg' on 'rac2' succeeded
..............................
alert.log显示实例是非常结束
license high water mark = 6
 sat apr 19 05:15:14 2014
 user (ospid: 5792): terminating the instance
 sat apr 19 05:15:14 2014
 opiodr aborting process unknown ospid (3667) as a result of ora-1092
 sat apr 19 05:15:15 2014
 instance terminated by user, pid = 5792
由此可以看出通过stop cluster来关闭实例会非常危险,直接是以非正常的方式来关闭实例的.
重启实例可以看到恢复操作
sat apr 19 05:31:20 2014
 beginning crash recovery of 1 threads
  parallel recovery started with 2 processes
 sat apr 19 05:31:21 2014
 started redo scan
 sat apr 19 05:31:21 2014
 completed redo scan
  read 255 kb redo, 69 data blocks need recovery
 sat apr 19 05:31:21 2014
 started redo application at
  thread 2: logseq 2, block 3004
 sat apr 19 05:31:22 2014
 recovery of online redo log: thread 2 group 4 seq 2 reading mem 0
  mem# 0: +data/tt/redo04.log
 sat apr 19 05:31:22 2014
 completed redo application of 0.14mb
 sat apr 19 05:31:22 2014
 completed crash recovery at
  thread 2: logseq 2, block 3514, scn 1969283
  69 data blocks read, 69 data blocks written, 255 redo k-bytes read
推荐阅读:
centos 6.3(x32)下安装oracle 10g r2
linux-6-64下安装oracle 12c笔记
本文永久更新链接地址:
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product