Starting and Stopping commands for RAC instances about:reader?url=[Link]
[Link]
Starting and Stopping commands for
RAC instances
by SandeepSingh DBA
3-4 minutes
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
1 of 6 7/22/2020, 10:49 AM
Starting and Stopping commands for RAC instances about:reader?url=[Link]
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
2 of 6 7/22/2020, 10:49 AM
Starting and Stopping commands for RAC instances about:reader?url=[Link]
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
3 of 6 7/22/2020, 10:49 AM
Starting and Stopping commands for RAC instances about:reader?url=[Link]
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
4 of 6 7/22/2020, 10:49 AM
Starting and Stopping commands for RAC instances about:reader?url=[Link]
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
5 of 6 7/22/2020, 10:49 AM
Starting and Stopping commands for RAC instances about:reader?url=[Link]
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
6 of 6 7/22/2020, 10:49 AM