This content has been marked as final. Show 7 replies
Thanks for the replay, Please find the scenario below.
And suggests me accordingly.
FAL_SERVER=standby1, standby2, standby3
On Standby1 DB:_
FAL_SERVER=PROD, standby2, standby3
On Standby2 DB:_
FAL_SERVER= PROD, standby, standby3
On Standby3 DB:_
FAL_SERVER= PROD, standby1, standby2
Looks textbook correct :
Boston Database (Standby Role)
Chicago Database (Primary Role)
Denver Database (Standby Role)
Athish wrote:FAL_CLIENT is Oracle TNS service of the local system and FAL_SERVER is Oracle TNS service of remote system.
I am little bit confused about FAL_SERVER and FAL_CLIENT parameter in Data Guard.
We are planning to configure multiple standby database in Data Guard environment. Let Assume that, i have production db named as 'PROD' and multiple standby name like standby1,standby2, standby3.
My Environment is:_
DB Version: 220.127.116.11
OS Version: OE5LU6
So in this case how to specify above Net service name in spfile on production server and also on other standby server.
Kindly Suggests me.
if you have three standby databases of primary , then from primary you must have three values in FAL_SERVER so that archives will be send to the all destinations.
and From the stadnby database, FAL_SERVER should be the oracle TNS service where you receiving the archive log files,
Note:- If you have RAC primary then mention each service differentiated by commas as shown example below.
From standby to Primary RAC:- FAL_SAERVER='PROD1','PROD2'
These parameters are dynamic, so that you can alter them at any time.