FAL_SERVER and FAL_CLIENT parameter in Oracle dataguard

FAL_SERVER and FAL_CLIENT parameter in Oracle dataguard

FAL_SERVER Parameter
FAL means fetch archive log. Its clearly indicate with name that fetch the archive log.
FAL_SERVER used to fetch archive log server for a standby database.
Value in FAL_SERVER parameter act as Oracle Net Service name which point to standby database.

FAL_CLIENT Parameter
FAL_CLIENT specifies the FAL(fetch archive log) client name that is used by the FAL service.
It configured for point the FAL Client.
Value in FAL_CLIENT is also an Oracle Net Service Name.

Example of using in Dataguard
We need tnsname.ora file which is having Oracle net service name configured for Primary and Standby site. Both has same tnsnames.ora file.

TNSNAMES.Ora file

TESTPR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PrimServer)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testpr)
)
)


TESTDR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = StandServer)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdr)
)
)

Configure FAL_Server and FAL_CLIENT on Primary and Standby
Configured the value onf FAL_SERVER and FAL_CLIENT on Primary and Standby site as follows:
On Primary Database

ALTER SYSTEM SET FAL_SERVER=;
ALTER SYSTEM SET FAL_CLIENT=;


ALTER SYSTEM SET FAL_SERVER=TESTDR;
ALTER SYSTEM SET FAL_CLIENT=TESTPR;

On Standby Database

ALTER SYSTEM SET FAL_SERVER=;
ALTER SYSTEM SET FAL_CLIENT=;


ALTER SYSTEM SET FAL_SERVER=TESTPR;
ALTER SYSTEM SET FAL_CLIENT=TESTDR;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.