Starting and Stopping commands for RAC instances
Starting and Stopping of RAC instance is managed from OS with srvctl command.
It provide different option at database , instance and service level to stop and start the database or instances present in RAC Environment.
Following are the command for Sart or Stop the database/instances:
Start or Stop the Instance of database:
command start/stop the Particular|all instances with services.
srvctl start/stop instance -db ORCL -node NODE1 -instance ORCL_1 -STARTOPTION|STOPOPTION
[OPEN | MOUNT | NOMOUNT | NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT ]
Start or stop all instance of database with database
It start/stop the cluster database with enable all instances and services
srvctl start|stop database -db ORCL -startoption|stopoption
[OPEN | MOUNT | NOMOUNT | NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT ]
Starting or stopping with SQLPLUS:
Note: you cannot start/stop multiple instance in SQLPLUS. Only current instance you can start or shutdown with sqlplus prompt:
sqlplus sys@orcl_1 as sysdba
shutdown immediate;
startup;
sqlplus sys@orcl_2 as sysdba
shutdown immediate;
startup;
Examples of start or stop with srvctl commands:
Check the status of instances in the database:
srvctl status database -db ORCL
Instance ORCL_1 is running on node NODE1
Instance ORCL_2 is running on node NODE2
Instance ORCL_3 is running on node NODE3
Stop the instance ORCL_1 with srvctl command
srvctl stop instance -db ORCL -node NODE1 -stopoption abort
OR
srvctl stop instance -db ORCL -instance ORCL_1 -stopption abort
Check the status of one instance is stopped in ORCL RAC:
srvctl status database -db ORCL
Instance ORCL_1 is not running on node NODE1
Instance ORCL_2 is running on node NODE2
Instance ORCL_3 is running on node NODE3
Stop all the instance then we used database option to stop:
srvctl stop database -db ORCL -stopoption transactional
Check the database status all instances must be stopped.
srvctl status database -db ORCL
Instance ORCL_1 is not running on node NODE1
Instance ORCL_2 is not running on node NODE2
Instance ORCL_3 is not running on node NODE3
Start the one instance of ORCL database:
srvctl start database -db ORCL -node NODE1
or
srvctl start database -instance ORCL_1
Check status node1 is started:
srvctl status database -db ORCL
Instance ORCL_1 is running on node NODE1
Instance ORCL_2 is not running on node NODE2
Instance ORCL_3 is not running on node NODE3
Start all the instances with database command:
srvctl start database -ORCL
Check status of all instances:
srvctl status database -db ORCL
Instance ORCL_1 is running on node NODE1
Instance ORCL_2 is running on node NODE2
Instance ORCL_3 is running on node NODE3
Manage the RAC pluggable database start/stop by services
Note: Need to assign the service to pluggable database for manage start or stop of PDB database.
1. Assign a service to pdb1 pluggable database :
srvctl add service -db raccdb -pdb pdb1 -service pdb1srv -serverpool sp1
2. For start or stop the pluggable database:
srvctl start service -db raccdb -service pdb1srv
srvctl stop service -db raccdb -service pdb1srv
3. Check the status for pluggable database:
srvctl status service -db raccdb -service pdb1arv
nice article
LikeLiked by 1 person
Thanks
LikeLike