Server-Side Planned Maintenance Command Examples

Note:

If you are using these commands in scripts, you may find it helpful to include wait = yes.
The parameters, -force -failover cause the service to start on other available instances configured on each service.
For more details see Managing a Group of Services for Maintenance in Oracle Real Application Clusters Administration and Deployment Guide.

To stop all instances on a node (node1) with all associated services' configured -drain_timeout and -stopoption parameters.

srvctl stop instance -db myDB -node node1 -force -failover
 -role primary

To stop one instance (inst1) with all associated services' configured -drain_timeout and -stopoption parameters

srvctl stop instance -db myDB -instance inst1 -force -failover
 -role primary

Stop all instances with explicit draining parameters that override the parameters configured for associated services.

srvctl stop instance -db db_name -node node_name
 -stopoption IMMEDIATE -drain_timeout <#> -force -failover

Stop a service with explicit draining parameters.

srvctl stop service -db db_name -service service_name
 -instance instance_name -drain_timeout <#> -stopoption IMMEDIATE
 -force -failover

To stop a service named GOLD on an instance named inst1 (a given instance) with a 5 minute drain timeout and an IMMEDIATE stop option.

srvctl stop service -db myDB -service GOLD -instance inst1
 -drain_timeout 300 -stopoption IMMEDIATE -force -failover

Stop a Data Guard instance with explicit draining parameters.

srvctl stop instance -db db_name -node node_name
 -stopoption IMMEDIATE -drain_timeout <#> -force -failover
 -role primary

Relocate all services by database, node, or PDB.

srvctl relocate service -database db_unique_name
  -pdb pluggable_database
 {-oldinst old_inst_name [-newinst new_inst_name] |
                          -currentnode current_node
                         [-targetnode target_node]}
  -drain_timeout timeout -stopoption stop_option -force

srvctl relocate service -database db_unique_name
 -oldinst old_inst_name [-newinst new_inst_name]
 -drain_timeout timeout -stopoption stop_option
 -force

srvctl relocate service -database db_unique_name
 -currentnode current_node [-targetnode target_node]
 -drain_timeout timeout -stopoption stop_option
 -force

To switch over to a Data Guard secondary site with a wait timeout of 60 seconds, using Data Guard Broker.

SWITCHOVER TO dg_south WAIT 60

To switch over to Data Guard secondary site with a wait timeout from the services, using Data Guard Broker.

SWITCHOVER TO dg_south WAIT