Saturday, October 22, 2011

The stapes to restart oracle database RAC with ASM

====Stop database, asm, listener, nodeapps finally crs===
1. STOP DATABASE
srvctl stop database -d DB_NAME
2. STOP ASM
srvctl stop asm -n NODE_NAME1
srvctl stop asm -n NODE_NAME2

3. STOP LISTENER
srvctl stop listener -n NODE_NAME1
srvctl stop listener -n NODE_NAME2

4. STOP NODEAPPS
srvctl stop nodeapps -n NODE_NAME1
srvctl stop nodeapps -n NODE_NAME2
5. STOP CRS
crsctl stop crs -- (on NODE_NAME1)
crsctl stop crs -- (on NODE_NAME2)

====Start crs, nodeapps, listner, asm and finally database===
1. START CRS
crsctl start crs -- (on NODE_NAME1)
crsctl start crs -- (on NODE_NAME2)
RESET to trace level 0
./crsctl debug log crs allcomp:0
2. START NODEAPPS
srvctl start nodeapps -n NODE_NAME1
srvctl start nodeapps -n NODE_NAME2

3. START LISTENER
srvctl start listener -n NODE_NAME1
srvctl start listener -n NODE_NAME2
4. STOP ASM
srvctl start asm -n NODE_NAME1
srvctl start asm -n NODE_NAME2
date
export SRVM_TRACE=y
env
srvctl start instance -d DB_NAME -i DB_NAME1

5. START DATABASE
srvctl start database -d DB_NAME

kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
Status of all instances and services

[p570db3][grid]/home/grid> srvctl status database -d bossmain
Instance bossmain1 is running on node p570db3
Instance bossmain2 is running on node p570db4
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
 srvctl status nodeapps -n  p570db3
-n <node_name> option has been deprecated.
VIP p570db3-vip is enabled
VIP p570db3-vip is running on node: p570db3
Network is enabled
Network is running on node: p570db3
GSD is disabled
GSD is not running on node: p570db3
ONS is enabled
ONS daemon is running on node: p570db3
eONS is enabled
eONS daemon is not running on node: p570db3
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
srvctl status asm -n p570db3
ASM is running on p570db3

No comments: