Useful SRVCTL Commands


---------------------Stop and start db using srvctl-------------------

-- SYNTAX FOR STOP DB
--- srvctl stop database -d db_name [-o stop_options] where stop_options is normal/immediate(default)/transactional/abort
e.g
srvctl stop database -d TESTDB -o normal
srvctl stop database -d TESTDB -o immediate
srvctl stop database -d TESTDB -o transactional
srvctl stop database -d TESTDB -o abort

-- SYNTAX FOR START DB
-- srvctl start database -d db_name [-o start_options] where start_option is nomount/mount/open(default)

e.g 
srvctl start database -d TESTDB -o nomount
srvctl start database -d TESTDB -o mount
srvctl start database -d TESTDB -o open


---------------------add/remove db using srvctl---------------

--- SYNTAX FOR REMOVING DB SERVICE: 
---srvctl remove database -d db_unique_name [-f] [-y] [-v]
e.g:
srvctl remove database -d TESTDB -f -y
--- SYNTAX FOR ADDING DB SERVICE :
-- srvctl add database -d db_unique_name -o ORACLE_HOME  [-p spfile]
e.g:
srvctl add database -d TESTDB -o /u01/app/oracle/product/12.1.0.2/dbhome_1 -p +DATA/PRODDB/parameterfile/spfileTESTDB.ora



------------------------Add/remove instance using srvctl-------------------

-- SYNTAX FOR REMOVING INSTANCE
---srvctl remove instance -d DB_UNIQUE_NAME -i INSTANCE_NAME
e.g
srvctl remove instance -d TESTDB - I TESTDB1

-- SYNTAX FOR ADDING INSTANCE 
--- srvctl add instance –d db_unique_name –i inst_name -n node_name
e.g
srvctl add instance -d TESTDB - i TESTDB1 -n rachost1



------------------------Stop and start instance using srvctl----------------------

--SYNTAX FOR STOPPING INSTANCE
-- srvctl stop instance -d db_unique_name [-i "instance_name_list"]} [-o stop_options] [-f]
e.g
srvctl stop instance -d TESTDB  -i TESTDB1 

--SYNTAX FOR STARTING INSTANCE
-- srvctl start instance -d db_unique_name  [-i "instance_name_list"} [-o start_options]
e.g
srvctl start instance -d TESTDB -i TESTDB1

-------------------------Enable/disable db/instance using srvctl--------------------

-- ENABLE - Reenables management by Oracle Restart for a component.
-- DISABLE - Disables management by Oracle Restart for a component.

srvctl enable instance -d DB_UNIQUE_NAME-i INSTANCE_NAME
srvctl disable instance -d DB_UNIQUE_NAME-i INSTANCE_NAME
srvctl enable database -d DB_UNIQUE_NAME
srvctl disable database -d DB_UNIQUE_NAME
Previous
Next Post »