Oracle Restart

Oracle Restart is designed to improve the availability of your Oracle Database.  It implements as high availability solution for single instance (nonclustered) environments only.  It can monitor the health and automatically restart the below componenets in the proper order in a accordance with component dependencies.  The Oracle Restart runs out of the Oracle Grid Infrastructure home.

  • Database Instance
  • Oracle Net Listener
  • Database Services
  • ASM instance
  • ASM diskgroups
  • ONS/eONS

It’s started by the OS init daemon

h1:35:respawn:/etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null

To control the state of Oracle Restart

iltcdb202.ngs.fnf.com:/apps/product/11.2.0/grid/bin
+ASM > crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.

crsctl enable / disable has
crsctl start / stop has


+ASM > crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'iltcdb202'
CRS-2673: Attempting to stop 'ora.WESBNDV.lsnr' on 'iltcdb202'
CRS-2673: Attempting to stop 'ora.wesbndv.db' on 'iltcdb202'
CRS-2673: Attempting to stop 'ora.wesbstg.db' on 'iltcdb202'
CRS-2673: Attempting to stop 'ora.ORDCDM00.lsnr' on 'iltcdb202'
CRS-2673: Attempting to stop 'ora.WESBSTG.lsnr' on 'iltcdb202'
CRS-2677: Stop of 'ora.WESBSTG.lsnr' on 'iltcdb202' succeeded
CRS-2677: Stop of 'ora.WESBNDV.lsnr' on 'iltcdb202' succeeded
CRS-2677: Stop of 'ora.ORDCDM00.lsnr' on 'iltcdb202' succeeded
CRS-2677: Stop of 'ora.wesbstg.db' on 'iltcdb202' succeeded
CRS-2677: Stop of 'ora.wesbndv.db' on 'iltcdb202' succeeded
CRS-2673: Attempting to stop 'ora.DG_DATA.dg' on 'iltcdb202'
CRS-2677: Stop of 'ora.DG_DATA.dg' on 'iltcdb202' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'iltcdb202'
CRS-2677: Stop of 'ora.asm' on 'iltcdb202' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'iltcdb202'
CRS-2677: Stop of 'ora.cssd' on 'iltcdb202' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'iltcdb202'
CRS-2677: Stop of 'ora.diskmon' on 'iltcdb202' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'iltcdb202' has completed
CRS-4133: Oracle High Availability Services has been stopped.

+ASM > crsctl start has

CRS-4123: Oracle High Availability Services has been started.

iltcdb202.ngs.fnf.com:/apps/product/11.2.0/grid/bin
+ASM > crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DG_DATA.dg ora....up.type ONLINE    ONLINE    iltcdb202  
ora....00.lsnr ora....er.type ONLINE    ONLINE    iltcdb202  
ora....DV.lsnr ora....er.type ONLINE    ONLINE    iltcdb202  
ora....TG.lsnr ora....er.type ONLINE    ONLINE    iltcdb202  
ora.asm        ora.asm.type   ONLINE    ONLINE    iltcdb202  
ora.cssd       ora.cssd.type  ONLINE    ONLINE    iltcdb202  
ora.diskmon    ora....on.type ONLINE    ONLINE    iltcdb202  
ora.wesbndv.db ora....se.type ONLINE    ONLINE    iltcdb202  
ora.wesbstg.db ora....se.type ONLINE    ONLINE    iltcdb202  

No comments:

Post a Comment