Friday, January 15, 2016

SRVCTL COMMANDS

http://oracledbabay.blogspot.com/2012/11/srvctl-commands-10g-rac-11g-r2-rac.html



Database Management with srvctl

Starts an instance
srvctl start instance -d <db_name> -i <inst_name>
Starts all instances
srvctl start database -d <db_name>
Stops all instances, closes database
srvctl stop database -d <db_name>
Stops an instance
srvctl stop instance -d <db_name> -i <inst_name>
Starts a service
srvctl start service -d <db_name> -s <service_name>
Stops a service
srvctl stop service -d <db_name> -s <service_name>
Checks status of a service
srvctl status service -d <db_name>
Checks an individual instance
srvctl status instance -d <db_name> -i <inst_name>
Checks status of all instances
srvctl status database -d <db_name>
  1. Starts nodeapps
  2. What are nodeapps?
    1. gsd,
    2. vip,
    3. listener,
    4. ons
srvctl start nodeapps -n <node_name>
Stops gsd, vip and listener
srvctl stop nodeapps -n <node_name>
To start ASM on node
srvctl start asm -n <node_name>
To stop ASM on node
srvctl stop asm -n <node_name>

[oracle@rac1 ~]$ srvctl status instance -d racdb -n rac1
Instance racdb1 is running on node rac1



[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2

[oracle@rac1 ~]$ srvctl status inst -d racdb -i "racdb1,racdb2"
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2
[oracle@rac1 ~]$


[oracle@rac1 ~]$  srvctl stop instance -d racdb -n rac1

[oracle@rac1 ~]$ srvctl status inst -d racdb -i "racdb1,racdb2"
Instance racdb1 is not running on node rac1
Instance racdb2 is running on node rac2



[oracle@rac1 ~]$  srvctl start instance -d racdb -n rac1
[oracle@rac1 ~]$ srvctl status nodeapps
Instance racdb1 is running on node rac1
[oracle@rac1 ~]$

[oracle@rac1 ~]$ srvctl status inst -d racdb -i "racdb1,racdb2"
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2
[oracle@rac1 ~]



[oracle@rac1 ~]$ srvctl status nodeapps -n rac1
-n <node_name> option has been deprecated.
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
Network is enabled
Network is running on node: rac1
GSD is disabled
GSD is not running on node: rac1
ONS is enabled
ONS daemon is running on node: rac1
eONS is enabled
eONS daemon is running on node: rac1
[oracle@rac1 ~]$



[oracle@rac1 ~]$  srvctl status asm -n rac1
ASM is running on rac1
[oracle@rac1 ~]$
[oracle@rac1 ~]$  srvctl status asm -n rac2
ASM is running on rac2


[oracle@rac1 ~]$  srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
[oracle@rac1 ~]$




[oracle@rac1 bin]$  srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
[oracle@rac1 bi

[oracle@rac1 bin]$  srvctl config database -d racdb -a
Database unique name: racdb
Database name: racdb
Oracle home: /syed/db_home1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DATA,CRS
Services:
Database is enabled
Database is administrator managed
[oracle@rac1 bin]$


[oracle@rac1 bin]$ srvctl status  diskgroup -g DATA  -n rac1,rac2
Disk Group DATA is running on rac1,rac2






Syntax for 11g R2 RAC (New SRVCTL command in 11g R2)

srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f]
$ srvctl remove diskgroup -g DATA -f

srvctl start diskgroup -g diskgroup_name [-n node_list]ode
$ srvctl start diskgroup -g DATA -n rac1,rac2

srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f]
$ srvctl stop diskgroup -g DATA
$ srvctl stop diskgroup -g diskg2 -n rac2,rac3 -f

srvctl status diskgroup -g diskgroup_name [-n node_list] [-a]
$ srvctl status diskgroup -g DATA -n rac1,rac2 -a

srvctl enable diskgroup -g diskgroup_name [-n node_list]
$ srvctl enable diskgroup -g diskgroup1 -n rac1,rac2

srvctl disable diskgroup -g diskgroup_name [-n node_list]
$ srvctl disable diskgroup -g dg_fra -n rac1, rac2




[oracle@rac1 bin]$ srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
eONS is enabled
eONS daemon is running on node: rac1
eONS daemon is running on node: rac2




vimal
{root@rac1 bin}./ocrconfig -showbackup

logical backup
physical backup ie automatic backup

{root@rac1 bin}./ocrconfig -manualbackup

patching ,upgrade, any maintainence activity

{root@rac1 bin}./ocrconfig -showbackup


logical backup

{root@rac1 bin}./ocrconfig -export /tmp/ocr.bak

if ocr is corrupted


{root@rac1 bin}./ocrconfig -import /tmp/ocr.bak
{root@rac1 bin}./ocrconfig -restore


olr is node specific


{root@rac1 bin}cat /etc/oracle/olr.loc


{root@rac1 bin}./ocrconfig -local -export /tmp/olr.bak
add ocr
deleting ocr
importing restoration command

SRVCTL CAN BE INVKOKED FROM TWO PLACE
GRIDHOME BIN. ORCLEHOME-BIN
when ever you are managing resources under oracle home use oraclehome srvctl
example startup/shutdown/enable/disable  database, instance.listener or manage services

if you want to manage asm instance,disk use srvctl from grid home
{root@rac1 bin}

{root@rac1 bin}./ocrconfig -

su - oracle
. oraenv
orcalehome/bin
srvctl status database -h
srvctl status database -d racdb
srvctl status instance -h
srvctl status instance -d racdb -i racdb1
srvctl start instance -d racdb -i racdb1
srvctl stop instance -d racdb -i racdb1
srvctl stop instance -h
srvctl status asm -h
 srvctl status asm -n rac1


if you want to start instance or database log in to that node and do it

log in grid_home
crs_stat
su - oracle
. oraenv
racdb1
srvctl status service -d racdb
srvctl add service -h
srvctl status database -d racdb
srvctl start instance -d racdb -i racdb1
srvctl add service -d racdb -s syedservice  -r racdb2 -a racdb1
srvctl status service -d racdb
srvctl start service -d racdb -s syedservice
srvctl status service -d racdb



No comments:

Post a Comment