Re: FAL_SERVER and FAL_CLIENT

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 17 Jan 2012 11:10:41 +0100
Message-ID: <4F154921.70404_at_nordea.com>

ups, I was wrong - it seems those parameters are simply not used on primary database, and it is standby, which sends the FAL_CLIENT value to the primary

Regards
Remigiusz

W dniu 17.01.2012 11:00, Remigiusz Sokolowski pisze:

> I would say
> FAL_SERVER=primary_role_database
> FAL_CLIENT=standby_role_database
> no matter the function the database fulfills
> and possibly fal_server is actually "ignored" on primary, and fal_client
> is "ignored" on standby
> 
> So one needs to change values of those parameters after a switchover
> 
> W dniu 17.01.2012 10:40, Kamus pisze:

>> Hi lists
>>
>> Maybe this is the question you do not think it should be the question.
>>
>>
>> for FAL_SERVER and FAL_CLIENT parameter in Data Guard (PRIMARY and STANDBY):
>>
>> 1. As all we know:
>> in Primary site:
>> FAL_SERVER=STANDBY
>> FAL_CLIENT=PRIMARY
>>
>> in Standby site:
>> FAL_SERVER=PRIMARY
>> FAL_CLIENT=STANDBY
>>
>>
>>
>> 2. As oracle documentation said:
>> http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams086.htm#REFRN10056
>>
>> FAL_SERVER
>> specifies the FAL (fetch archive log) server for a standby database. The value is an Oracle Net service name, which is assumed to be configured properly on the standby database system to point to the desired FAL server.
>>
>>
>>
>> http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams085.htm
>>
>> FAL_CLIENT
>> specifies the FAL (fetch archive log) client name that is used by the FAL service, configured through the
>> FAL_SERVER initialization parameter, to refer to the FAL client. The value is an Oracle Net service name, which is assumed to be configured properly on the FAL server system to point to the FAL client (standby database).
>>
>>
>>
>> If I'm not misunderstanding, it should be:
>> in Primary site:
>> FAL_SERVER= STANDBY
>> FAL_CLIENT= STANDBY
>>
>> in Standby site:
>> FAL_SERVER=PRIMARY
>> FAL_CLIENT= PRIMARY
>>
>>
>>
>> 3. As we tested (in Oracle 10.2.0.1), without considering switchover or failover, only set FAL_SERVER=PRIMARY in standby site is enough to fetch archive log from primary site. it means no FAL_SERVER and FAL_CLIENT setting in primary at all, and with no FAL_CLIENT setting in standby site.
>>
>> So … what do you think?
>>
>> --
>> Zhang Leyi (Kamus) <kamusis_at_gmail.com>
>>
>> Visit my blog for more: http://www.dbform.com
>> Join ACOUG: http://www.acoug.org
>> Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>

>
>

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, 
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, 
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, 
o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 17 2012 - 04:10:41 CST