Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

Starting and Stopping an instance in RAC Environment

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
OR
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"