Sunday, September 19, 2010

Oracle Restart


New Feature in Oracle 11g
     
Use Oracle Restart to Automatically Restart Your Database 
 
Oracle Restart is a new feature included in this release to enhance the availability of Oracle databases in a single-instance environment. 

If you install Oracle Restart, and there is a temporary failure of any part of the Oracle Database software stack, including the database, listener, and Oracle ASM instance, Oracle Restart automatically restarts the failed component. In addition, Oracle Restart starts all these components when the database host computer is restarted. The components are started in the proper order, taking into consideration the dependencies among components.

Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted.

Oracle Restart is used in standalone server (non-clustered) environments only. For Oracle Real Application Clusters (Oracle RAC) environments, the functionality to automatically restart components is provided by Oracle Clusterware.

Viewing the Oracle Restart Configuration for a Component
srvctl config database              # list databases on the server
srvctl config database -d orcl   # view restart configuration

Viewing Component Status
srvctl status database -d orcl

Creating and Deleting Database Services with SRVCTL
srvctl add service -d db_unique_name -s service_name [options]
srvctl remove service -d db_unique_name -s service_name [-f] 
srvctl add service -d dbcrm -s crmbatch -l PHYSICAL_STANDBY  # Role-Based Database Service