SRVCTL for Instance
To add the instance
Command: srvctl add instance -d db_name -i inst_name -n node_name Example: srvctl add instance -d racdb -i rac01 -n lnxrac1
To Remove the instance
Command: srvctl remove instance -d db_name -i inst_name Example: srvctl remove instance -d racdb -i rac01
To Start the instance
Command: srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q] Command: srvctl start instance -d db_name -i inst_names [-o open] Command: srvctl start instance -d db_name -i inst_names -o nomount Command: srvctl start instance -d db_name -i inst_names -o mount Example: srvctl start instance -d racdb -i rac02
To start the instance in Oracle 11g:
Command: srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options] Example: srvctl start instance -d racdb -n lnxrac2 Example: srvctl start instance -d racdb -i "rac02,rac03"
To stop the instance
Command: srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q] Command: srvctl stop instance -d db_name -i inst_names [-o normal] Command: srvctl stop instance -d db_name -i inst_names -o transactional Command: srvctl stop instance -d db_name -i inst_names -o immediate Command: srvctl stop instance -d db_name -i inst_names -o abort Example: srvctl stop instance -d racdb -i rac03
To stop the instance in Oracle 11g:
Command: srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f] Example: srvctl stop instance -d racdb -n lnxrac1 Example: srvctl stop instance -d racdb -i rac01
To check the status of the instance
Command: srvctl status instance -d db_name -i inst_names [-f] [-v] [-S level] Example: srvctl status instance -d racdb -i rac02
To check the status of the instance in Oracle 11g:
Command: srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v] Example: srvctl status instance -d racdb -i "rac01,rac02" -v
To enable/disable the instance
Command: srvctl enable instance -d db_name -i inst_names Example: srvctl enable instance -d racdb -i "rac01,rac02" Command: srvctl disable instance -d db_name -i inst_names Example: srvctl disable inst -d racdb -i "rac01,rac03"
To set dependency of instance to ASM
Command: srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} Command: srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z} Example: srvctl modify instance -d racdb -i rac01 -n lnxrac1 Example: srvctl modify instance -d racdb -i rac01 -z
To move the database instance
Command: srvctl modify instance -d db_name -i inst_name -n node_name Example: srvctl modify instance -d racdb -i rac02 -n lnxrac1
To remove the database instance
Command: srvctl modify instance -d db_name -i inst_name -r Example: srvctl modify instance -d racdb -i rac01 -r
To get/set/unset the environment configuration of the instance
Command: srvctl getenv instance -d db_name -i inst_name [-t name_list] Example: srvctl getenv instance -d racdb -i rac01 Command: srvctl setenv instance -d db_name [-i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"} Example: srvctl setenv instance -d racdb -i rac01 [options] Command: srvctl unsetenv instance -d db_name [-i inst_name] [-t name_list] Example: srvctl unsetenv instance -d racdb -i rac01 [-t options]
Follow Me!!!