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