RAC - application continuity ADD ,Failover and relocate services command

Application continuity commands:

Instance name: SMRRAC1, SMRRAC2


STEP 1 : Add service acsmmrac  failovertype TRANSACTION  commit_outcome TRUE

• srvctl add service -db smrrac -service acsmrrac -preferred smrrac1 -available smrrac2 -failovertype TRANSACTION -commit_outcome TRUE -failoverretry 30 -failoverdelay 10 -retention 86400 -replay_init_time 1800 -notification TRUE

STEP 2: Start acsmrrac service

• srvctl start service -db smrrac -service acsmrrac

STEP 3: Check cluster service

•  crsctl status resource -t

STEP 4:

Check service details on node

•  srvctl status database -d smrrac -v

STEP 5 :

Failover planned instance smrrac1

• srvctl stop instance -i smrrac1 -d smrrac -failover

STEP 6 :

Relocate services 

•  srvctl relocate service -s acsmrrac-db smrrac -oldinst smrrac2 -newinst smrrac1

#################################################################################

• SQL PLUS Command : 

col username format a10
col service_name format a20
SELECT INST_ID, USERNAME, SERVICE_NAME, FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER FROM GV$SESSION WHERE USERNAME='INFODBA' ORDER BY INST_ID;

#################################################################################

• TNSNAMES.ORA Entry 

acsmrrac =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =scan-smrplm.smr.motherson.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = acsmrrac)
    )
  )