RAC regular command

by Posted on

start/stop database

srvctl start/stop database -d instance_name

[grid@node1 ~]$ srvctl status database -d devdb

Instance devdb1 is running on node node1

Instance devdb2 is running on node node2

start database to mount mode

srvctl start database -d instance_name -o mount

check node status

crs_stat -t -v

[grid@rac01 ~]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

———————– ————————————————————————————–

ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE node1

ora.FRA.dg ora….up.type 0/5 0/ ONLINE ONLINE node1

ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE node1

ora….N1.lsnr ora….er.type 0/5 0/0 ONLINE ONLINE node2

ora.VOTING.dg ora….up.type 0/5 0/ ONLINE ONLINE node1

ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE node1

ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE node2

ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

ora….network ora….rk.type 0/5 0/ ONLINE ONLINE node1

ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE node2

ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE node1

ora.rac.db ora….se.type 0/2 2/1 ONLINE ONLINE node1

ora….SM1.asm application 0/5 0/0 ONLINE ONLINE node1

ora….01.lsnr application 0/5 0/0 ONLINE ONLINE node1

ora.rac01.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.rac01.ons application 0/3 0/0 ONLINE ONLINE node1

ora.rac01.vip ora….t1.type 0/0 0/0 ONLINE ONLINE node1

ora….SM2.asm application 0/5 0/0 ONLINE ONLINE node2

ora….02.lsnr application 0/5 0/0 ONLINE ONLINE node2

ora.rac02.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.rac02.ons application 0/3 0/0 ONLINE ONLINE node2

ora.rac02.vip ora….t1.type 0/0 0/0 ONLINE ONLINE node2

ora….ry.acfs ora….fs.type 0/5 0/ ONLINE ONLINE node1

ora.scan1.vip ora….ip.type 0/0 0/0 ONLINE ONLINE node2

 

check applications status on each node

[grid@node1 ~]$ srvctl status nodeapps

VIP node1-vip is enabled

VIP node1-vip is running on node: node1

VIP node2-vip is enabled

VIP node2-vip is running on node: node2

Network is enabled

Network is running on node: node1

Network is running on node: node2

GSD is disabled

GSD is not running on node: node1

GSD is not running on node: node2

ONS is enabled

ONS daemon is running on node: node1

ONS daemon is running on node: node2

 

[grid@node1 ~]$ srvctl config database -d devdb -a

Database unique name: devdb

Database name: devdb

Oracle home: /u02/app/oracle/11.2.0/db_1

Oracle user: oracle

Spfile: +DATA/devdb/spfilerac.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: devdb

Database instances: devdb1,devdb2

Disk Groups: DATA,FRA

Mount point paths:

Services:

Type: RAC

Database is enabled

Database is administrator managed

 

 

check asm disk status

kfod ds=true di=all

[grid@node1 ~]$ kfod ds=true di=all

——————————————————————————–

Disk Size Path Disk Group User Group

==============================================

1: 1048576 Mb /dev/mapper/data01 DATA grid asmadmin

2: 1048576 Mb /dev/mapper/data02 DATA grid asmadmin

3: 1048576 Mb /dev/mapper/data03 DATA grid asmadmin

4: 1048576 Mb /dev/mapper/data04 DATA grid asmadmin

5: 1048576 Mb /dev/mapper/data05 DATA grid asmadmin

6: 1048576 Mb /dev/mapper/data06 DATA grid asmadmin

7: 1048576 Mb /dev/mapper/data07 DATA grid asmadmin

8: 1048576 Mb /dev/mapper/data08 FRA grid asmadmin

9: 1048576 Mb /dev/mapper/data09 DATA grid asmadmin

10: 1048576 Mb /dev/mapper/data10 FRA grid asmadmin

11: 1048576 Mb /dev/mapper/data11 DATA grid asmadmin

Donate

Published by byron

Leave a Reply