Home » Server Options » Data Guard » problem in physical standby configuration
problem in physical standby configuration [message #220171] Mon, 19 February 2007 05:35 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
Hi to everyone,

i have one doubt to setting parameters of standby,

what is the use of these parameters

fal_server
fal_client

can any one explanin this parameter. and what value i have to give of this parameters. what is its use

thanks

Re: problem in physical standby configuration [message #224052 is a reply to message #220171] Mon, 12 March 2007 14:45 Go to previous messageGo to next message
salaku
Messages: 9
Registered: March 2007
Junior Member
FAL_SERVER - if the fetch archive log server for a standby database and is set at the standby database

Set this parameter to the tns entry of production database.

Make sure the tnsnames.ora file in the standby database server has entries to the production database

eg:
FAL_SERVER=primary db


FAL_CLIENT - Fetch archive log client name used by the FAL server to refer to the FAL client. Set on standby site

eg:

FAL_CLIENT=standby db

Given the dependency they have to be configured and modified at the same time.


Re: problem in physical standby configuration [message #225533 is a reply to message #220171] Tue, 20 March 2007 04:44 Go to previous messageGo to next message
amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai
Member

hi,

suppose u have sid on PRDB as orcl, and DRDB as orclstby..
so u have to set parameter in spfile of PRDB as
*.fal_client=orcl
*.fal_server=orclstby

And set the parameter in spfile of DRDB as

*.fal_client=orclstby
*.fal_server=orcl

Regards,
Amit D
Re: problem in physical standby configuration [message #225854 is a reply to message #225533] Wed, 21 March 2007 14:20 Go to previous message
salaku
Messages: 9
Registered: March 2007
Junior Member

Yes that's correct

Previous Topic: Soft link for datafile - Dataguard
Next Topic: does adding/removing of logfile/group propogate to stdby
Goto Forum:
  


Current Time: Thu Apr 18 00:34:04 CDT 2024