Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FAL_SERVER and FAL_CLIENT

Vijayaraghavan KrishnanNov 16 2009 — edited Nov 16 2009
Hi to all,

I am going throught the Dataguard Concepts and Administration Docs.

I have one doubt.
For Eg: My primary db is named as : PRD
Standby DB is name as: PRDSTBY

Now with respect to the init parameters, I mentioning

FAL_CLIENT = PRDSTBY (in PRD init file)
FAL_SERVER = PRD (in prd but this works when switch over right?)

FAL_CLIENT = PRDSTBY (in prdstby but this works when switch over right?)
FAL_SERVER = PRD (in PRDSTBY)

Is my understanding is correct?


Regards,
Vijayaraghavan K
This post has been answered by MSK on Nov 16 2009
Jump to Answer

Comments

MSK
Hi
FAL_CLIENT is the one that is requesting the logs to be applied (the standby server)
FAL_SERVER is the one that is sending the logs to be applied (the primary server)
when you want to test failover and want to make your primary as standby and standby as primary, then the roles become opposite and the FAL_CLIENT, FAL-SERVER would be different.

There is a good paper by Alejandro Varjas where he explains the concepts with a very good demo.

Hope this helps

MSK
Robert Geier
No, should be :-

(in PRD init file)
FAL_CLIENT = PRD
FAL_SERVER = PRDSTBY

(in PRDSTBY)
FAL_CLIENT = PRDSTBY
FAL_SERVER = PRD
For understanding purpose, I dont need the failover and switch over

Then I need to have FAL_SERVER = PRD at standby stie
and FAL_CLIENT=PRDSTBY at primary site rite?

Many Thanks,
vijayaraghavan K
MSK
Answer
Yes that is right. FAL_CLIENT should be your standby tnsnames entry. FAL_SERVER should be your prod tnsnames entry
MSK

Edited by: MSK on Nov 16, 2009 5:16 AM
Marked as Answer by Vijayaraghavan Krishnan · Sep 27 2020
Thanks...
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 14 2009
Added on Nov 16 2009
#general-database-discussions
5 comments
2,695 views