내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : 오라클 11g crsctl stop crs 시 db의 shutdown 명령
root 유저로 crsctl stop crs 명령 실행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | # crsctl stop crs CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2' 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.LISTENER.lsnr' on 'rac2' CRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.racdb.db' 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-2672: Attempting to start 'ora.rac2.vip' on 'rac1' CRS-2676: Start of 'ora.rac2.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.racdb.db' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ORADATA.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.ORAFRA.dg' on 'rac2' CRS-2677: Stop of 'ora.ORADATA.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.ORAFRA.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac2' CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2' CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'rac2' CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2' CRS-2673: Attempting to stop 'ora.evmd' on 'rac2' CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2' CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2' CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac2' CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2' CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2' CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed CRS-4133: Oracle High Availability Services has been stopped. |
alert log 확인
1 2 3 4 5 6 7 8 9 10 | $ cd $ORACLE_BASE/diag/rdbms/racdb/racdb2/trace/ $ tail -f alert_racdb2.log ### crsctl stop crs 이후 ### Thu Jun 18 10:57:10 2020 Shutting down instance (abort) License high water mark = 6 USER (ospid: 6803): terminating the instance Instance terminated by USER, pid = 6803 Thu Jun 18 10:57:11 2020 Instance shutdown complete |
shutdown 명령을 abort 로 하는 것을 확인 할 수 있음
오라클 11g srvctl stop instance -d racdb -i racdb2 시 db의 shutdown 명령
오라클 유저로 srvctl stop instance 명령 실행
1 | $ srvctl stop instance -d racdb -i racdb2 |
alert log 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | $ cd $ORACLE_BASE/diag/rdbms/racdb/racdb2/trace/ $ tail -f alert_racdb2.log ### srvctl stop instance -d racdb -i racdb2 이후 ### Thu Jun 18 11:03:33 2020 Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process QMNC Stopping background process MMNL Stopping background process MMON License high water mark = 2 ALTER DATABASE CLOSE NORMAL /* db agent *//* {2:56648:133} */ Thu Jun 18 11:03:36 2020 SMON: disabling tx recovery Stopping background process RCBG SMON: disabling cache recovery Thu Jun 18 11:03:41 2020 NOTE: Deferred communication with ASM instance NOTE: deferred map free for map id 12 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 2 closed at log sequence 2 Successful close of redo thread 2 Thu Jun 18 11:03:41 2020 NOTE: Deferred communication with ASM instance NOTE: deferred map free for map id 4 Completed: ALTER DATABASE CLOSE NORMAL /* db agent *//* {2:56648:133} */ ALTER DATABASE DISMOUNT /* db agent *//* {2:56648:133} */ Shutting down archive processes Archiving is disabled Thu Jun 18 11:03:41 2020 NOTE: Deferred communication with ASM instance NOTE: deferred map free for map id 2 Completed: ALTER DATABASE DISMOUNT /* db agent *//* {2:56648:133} */ ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Thu Jun 18 11:03:41 2020 NOTE: force a map free for map id 2 NOTE: force a map free for map id 4 NOTE: force a map free for map id 12 ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Thu Jun 18 11:03:42 2020 Stopping background process VKTM Thu Jun 18 11:03:42 2020 NOTE: Shutting down MARK background process Thu Jun 18 11:03:43 2020 freeing rdom 0 Thu Jun 18 11:03:47 2020 Instance shutdown complete |
shutdown 명령을 immediate 로 하는 것을 확인 할 수 있음
결론
crsctl stop crs 시 db에 shutdown abort 명령 실행
srvctl stop instance 시 db에 shutdown immediate 명령 실행
참조 :
'ORACLE > Admin' 카테고리의 다른 글
오라클 11g R2 싱글 DB 환경에서 grid 기동 및 중지 (0) | 2020.06.24 |
---|---|
오라클 19c Hugepages 설정 방법 (3) | 2020.06.24 |
오라클 11g 원격지 DB sysdba 권한으로 접속 및 중지 방법 (0) | 2020.06.15 |
오라클 19c 서버 기동시 db 자동실행 설정 (2) | 2020.06.08 |
오라클 19c 홈경로(엔진경로) 변경 후 기동시 alert log (0) | 2020.05.31 |