Database - RAC/Scalability (MOSC)

MOSC Banner

oracle 12.2.0 2 node rac standby switch-over

edited Oct 23, 2019 5:02AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

i have 2 node rac cluster with 2 node standby running on linux server

Primary : rac1,rac2

standby : stdrac1,stdrac2

These entries for tnsnames

RAC =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))

    #(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.81)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = rac)

    )

  )

STDRAC =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = racs1)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = stdrac.localdomain) (UR=A)

    )

  )

It can switch-over sucessfully  as long ass racs1 up and running. what if node racs1 dies, How do i do  swicthover ?

Thanks 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center