fal server fal client

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

fal server fal client

Roshan
Oracle DB 12.1.0.2 on source and destination
Hi,

I would like to have same SID on both primary and standby.

The TNS entries are shown below:

--standbyentry

DWDR =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dwaredr)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dware1)
    )
  )

--primary entry

DWARE =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = dware-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dware1)
    )
  )

Can I set the FAL_server and FAL_CLIENT to dware1?

Regards,

Roshan
Reply | Threaded
Open this post in threaded view
|

Re: fal server fal client

ErmanArslansOracleBlog
Administrator
Suppose yo uhave a conf like DB1(primary) -> DB3(standby)

*.FAL_SERVER=DB3
FAL Server means the primary database, so this parameter is used to determine the primary database after a switch over operation. So, when a switchover happens, DB1 will be the new standby and DB1 will fetch the archivelogs from the new primary, DB3.(in case DB3 cant send the archivelogs itself)

*.FAL_CLIENT=DB1
# This parameter is used to determine the standby database after a switch over operation. So, when log switch happens, DB1 will be the new standby and DB3 will send the log files using this info.

these are set to TNS Entries... Not to the service_name given in those TNS Entries.