Home » Server Options » Data Guard » fal server (10g Rel2 , Linux AS4)
fal server [message #355871] Tue, 28 October 2008 04:11 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I want to implement a Physical Standby database on my oracle server . The details are:

Listener on Primary : prod
TNS alias poitig to Primary : toprod
Listener on Standby : stand
TNS alias poiting to Standby : tostand

Now my doubt is , what need to be given on fal_server and fal_client of the init.ora parameters on the primary and the standby machine .

And what all would be the problems/issues with the standby database .

Any help on this will be appreciated .

Regards,
Rajasekhar
Re: fal server [message #355878 is a reply to message #355871] Tue, 28 October 2008 05:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
On the primary, the FAL_SERVER would be toprod and the FAL_CLIENT would be tostand. The entries would be opposite for the standby parameters.
Re: fal server [message #356008 is a reply to message #355878] Wed, 29 October 2008 00:37 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thanks ebrian , for that reply .

And I was also asking you that what would be the most occurring and facing issues with respect to a physical standby database.

Can you please help me out .

Regards,
Rajasekhar
Re: fal server [message #356174 is a reply to message #356008] Wed, 29 October 2008 17:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Ebrain,

>>On the primary, the FAL_SERVER would be toprod and the FAL_CLIENT would be tostand. The entries would be opposite for the standby parameters.

Are you sure this is correct??

I think in Primary database

FAL_SERVER = tostand

FAL_CLIENT = toprod

Standby database:

Opposite of primary database.

Please correct me if i am wrong..

Thank you in advance

Babu

Re: fal server [message #356189 is a reply to message #356174] Wed, 29 October 2008 21:02 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Babu,
You are correct. I meant to put:

On the STANDBY, the FAL_SERVER would be toprod and the FAL_CLIENT would be tostand. The entries would be opposite for the PRIMARY parameters.

Thanks for catching that !
Re: fal server [message #356302 is a reply to message #356174] Thu, 30 October 2008 04:27 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi Babu,

Thanks for clearing that confusion , but for a small clarification as I did mention in my mail that the details about my TNS and Listeners are as below :

Listener on Primary : prod
TNS alias pointing to Primary : toprod
Listener on Standby : stand
TNS alias pointing to Standby : tostand


Can you please mention once again what to mention (FAL_SERVER and FAL_CLIENT) in the init.ora parameters in the Primary and in the Physical Standby databases.

And is it mandatory to specify these parameters in Oracle 10g Rel2 .

And also we need to mention the parameters like
log_archive_dest_1 and log_archive_dest_2 . What should be the values for this .

Please clarify on this .

Regards,

Raj

[Updated on: Thu, 30 October 2008 04:37]

Report message to a moderator

Re: fal server [message #356428 is a reply to message #356302] Thu, 30 October 2008 13:03 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Good Question.

Usually I try that database & TNS Alias name both are same. That's why NO confusion for me.

Quote:

Listener on Primary : prod
TNS alias pointing to Primary : toprod
Listener on Standby : stand
TNS alias pointing to Standby : tostand


I hope the same TNS alias entry your having in primary & standby database.

FAL_SERVER & FAL_CLIENT should be NET Service names.

Try in Prod.

FAL_SERVER = tostand
FAL_CLINET = toprod

From Standby:

FAL_SERVER = toprod
FAL_CLINET = tostand

Thank you in advance
Babu
Previous Topic: Starting DB with standby controlfile.
Next Topic: Urgent..Error on Switchover Physical Standby DB..=(
Goto Forum:
  


Current Time: Thu Mar 28 11:30:30 CDT 2024