RAC Maintenance

RAC Maintenance
1. crsctl
1.1 check crs status
$ ./crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
-- check single status
$ ./crsctl check cssd
CSS appears healthy
$ ./crsctl check crsd
CRS appears healthy
$ ./crsctl check evmd
EVM appears healthy

1.2 start and stop crs
-- START CRS：
$ ./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
-- STOP CRS：
$ ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

1.3 check Votedisk
$ ./crsctl query css votedisk
0. 0 /dev/raw/raw2
located 1 votedisk(s).

1.4 check ocr
$ ./ocrconfig -showbackup

2. crs_stat
2.1 check point app
$ ./crs_stat ora.raw2.vip
NAME=ora.raw2.vip
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

2.2 use –v ,check point app
$ ./crs_stat -v ora.raw2.vip
NAME=ora.raw2.vip
TYPE=application
RESTART_ATTEMPTS=0
RESTART_COUNT=0
FAILURE_THRESHOLD=0
FAILURE_COUNT=0
TARGET=ONLINE
STATE=OFFLINE

2.3 use –p ,check point app
$ ./crs_stat -p ora.raw2.vip
NAME=ora.raw2.vip
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/product/crs/bin/racgwrap
ACTIVE_PLACEMENT=1
AUTO_START=1
CHECK_INTERVAL=60
DESCRIPTION=CRS application for VIP on a node
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=raw2
OPTIONAL_RESOURCES=
PLACEMENT=favored
REQUIRED_RESOURCES=
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=eth0
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=255.255.255.0
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=10.85.10.123

2.4 use –ls
$ ./crs_stat -ls
Name Owner Primary PrivGrp Permission
-----------------------------------------------------------------
ora.raw.db oracle oinstall rwxrwxr--
ora.raw.dmm.cs oracle oinstall rwxrwxr--
ora....aw2.srv oracle oinstall rwxrwxr--
ora....w1.inst oracle oinstall rwxrwxr--
ora....w2.inst oracle oinstall rwxrwxr--
ora....SM1.asm oracle oinstall rwxrwxr--
ora....W1.lsnr oracle oinstall rwxrwxr--
ora.raw1.gsd oracle oinstall rwxr-xr--
ora.raw1.ons oracle oinstall rwxr-xr--
ora.raw1.vip root oinstall rwxr-xr--
ora....SM2.asm oracle oinstall rwxrwxr--
ora....W2.lsnr oracle oinstall rwxrwxr--
ora.raw2.gsd oracle oinstall rwxr-xr--
ora.raw2.ons oracle oinstall rwxr-xr--
ora.raw2.vip root oinstall rwxr-xr—

2.5 use –t
$ ./crs_stat –t
Name Type Target State Ho
-----------------------------------------------
ora....c01.lsnr application ONLINE ONLINE gnd-rac01
ora....c01.gsd application ONLINE ONLINE gnd-rac01
ora....c01.ons application ONLINE ONLINE gnd-rac01
ora....c01.vip application ONLINE ONLINE gnd-rac01
ora....c02.lsnr application OFFLINE OFFLINE gnd-rac02
ora....c02.gsd application ONLINE ONLINE gnd-rac02
ora....c02.ons application ONLINE ONLINE gnd-rac02
ora....c02.vip application ONLINE ONLINE gnd-rac02
3. srvctl
3.1 start database
$ ./srvctl start database -d bossmain

3.2 start one instance to point status
$ ./srvctl start database -d bossmain -i bossmain1 -o mount
$ ./srvctl start database -d bossmain -i bossmain1 -o nomount

3.3 close database
$ ./srvctl stop database -d bossmain

3.4 close one instance
$ ./srvctl stop instance -d bossmain -i bossmain1 -o immediate
$ ./srvctl stop instance -d bossmain -i bossmain1 -o abort

3.5 start service on one instance
$ ./srvctl start service -d bossmain -s rawservice -i bossmain1
-- check service status
$ ./srvctl status service -d bossmain –v

3.6 start service on one instance
$ ./srvctl stop service -d bossmain -s rawservice -i bossmain1
-- check service status
$ ./srvctl status service -d bossmain –v

3.7 start/stop/check all nodeapps
$ srvctl start|stop|status|enable nodeapps -n
4. RAC Start
4.1 Maintenance of database and operating system, server
a. stop database
$ lsnrctl stop (each node stop listener)
$ $AGENT_HOME/bin/emctl stop agent (each node stop dbconsole)
$ srvctl stop database -d bossmain (stop all database)
$ srvctl stop nodeapps -n p570db3 (stop node1 service)
$ srvctl stop nodeapps -n gnd-rac02 (stop node2 service)
$ crs_stop –all
Or
$ crsctl start crs
b. close host
c. close power
d. start server
$ srvctl start nodeapps –n rac01 (start node1 service)
$ srvctl start nodeapps -n rac02 (start node2 service)
$ srvctl start database -d bossmain (start all database)
$ lsnrctl start (each node start listener)
$ $AGENT_HOME/bin/emctl start agent (each node start dbconsole)

4.2 Adjust the database parameters of the time, only to close all instances, do not restart the OS and the Server.
a. stop database
$ lsnrctl stop (each node stop listener)
$ srvctl stop database -d database (stop all database)
a. start database
$ srvctl start database -d tpc (start all database)
$ lsnrctl start (each node start listener)

4.3 Adjust the one database parameters of the time, only to close this instances, do not restart the OS and the Server.
a. stop instance
$ lsnrctl stop (one node stop listener)
$ srvctl stop database -d bossmain -i bossmain1 (stop one instance)
a. start instance
$ srvctl start database -d bossmain -i bossmain1 (start one instance)
$ lsnrctl start (one node start listener) restart one instance $AGENT_HOME/bin/emctl stop agent lsnrctl stop srvctl stop instance -d bossmain -i bossmain1 srvctl start instance -d bossmain -i bossmain1 lsnrctl start $AGENT_HOME/bin/emctl start agent