Starting and Stopping an instance in RAC Environment
Check database is Administrative and policy managed in RAC
Administrative: DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.
Policy: DBA is required only to define the cardinality(number of database required). Oracle Clusterware manages the allocation of nodes to run the instances and Oracle RAC allocates the required redo threads and undo tablespaces as needed.
srvctl config database -d ORCL
--Last line of output will be:
Database is policy managed
Database is administrator managed
Check database running in nodes
srvctl status database -d ORCL
Instance RAC1 is running on node NODE1
Instance RAC2 is running on node NODE2
Instance RAC3 is running on node NODE3
Stopping the Instance
-- Stopping an instance in a policy-managed database:
srvctl stop instance -db ORCL -node NODE1
--Stopping an instance in an administrator-managed database:
srvctl stop instance -db ORCL -instance "RAC1"
Starting the Instance
--Starting an instance in a policy-managed database:
srvctl start instance -db ORCL -node NODE1
--Starting an instance in an administrator-managed database:
srvctl start instance -db crm -instance "RAC1,RAC2"