Standby Database

[bhattnirav]

Dear All,

We are planning for DR solution for our Production server.


We plan to keep secondrary server at remote side where network is different. We have point-to-point connectivity between two sites.


Now the server name is different at both the site.

When primary goes down how users are connected to seconday site as secondary server at different network ?



Regards,

Nirav

[LKBrwn_DBA]

Try something like this:

ORCL=
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)(HOST=PrimaryServer)(PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=StandbyServer)(PORT=1521))
    (LOAD_BALANCE=yes)
    (FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=1))
    (CONNECT_DATA=(SERVER=DEDICATED)
    (SERVICE_NAME=ORCL.WORLD))
  )