Re: ORACLE 10g DG Synch Up issues (FAL Redo Shipping Client Did Not Establish Network Login)

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Thu, 6 Jan 2011 07:27:12 -0800 (PST)
Message-ID: <353435.43983.qm_at_web82105.mail.mud.yahoo.com>

have you ensured that your fal_server and fal_client are setup correctly on both the primary and the standby
on primary
fal_server would be the standby
fal_client would be primary

 on standby
fal_server would be the primary
fal_client would be standby

 if using tnsnames rather than full connect string then make sure tnsnames.roa is full accessible and/or TNS_ADMIN is setup on startup

example of how fal_server/client should look like

fal_server                           string      

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=abc)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=abc_XPT)(SERVER=dedicated))),

---

From: Howard Latham <howard.latham_at_gmail.com> To: KRISHNA MOORTHY <krish33moorthy_at_gmail.com> Cc: oracle-l_at_freelists.org
Sent: Thu, January 6, 2011 9:06:09 AM
Subject: Re: ORACLE 10g DG Synch Up issues (FAL Redo Shipping Client Did Not Establish Network Login)

Gap recovery doesnt always seem to work - you may have to do it manually.

On 6 January 2011 15:03, KRISHNA MOORTHY <krish33moorthy_at_gmail.com> wrote:

Hi,
>
>OS : RedHatLinux5
>Oracle:oracle 10.2.0
>
>standby logs
>-------------
>Thu Jan 6 19:36:51 2011
> alter database recover managed standby database disconnect from session
>Thu Jan 6 19:36:51 2011
>Attempt to start background Managed Standby Recovery process (CCM)
>MRP0 started with pid=20, OS id=17001
>Thu Jan 6 19:36:51 2011
>MRP0: Background Managed Standby Recovery process started (CCM)
>Managed Standby Recovery not using Real Time Apply
>Media Recovery Waiting for thread 1 sequence 25666
>Fetching gap sequence in thread 1, gap sequence 25666-25672
>Thu Jan 6 19:36:57 2011
>Completed: alter database recover managed standby database disconnect
>from session
>Thu Jan 6 19:41:59 2011
>FAL[client]: Failed to request gap sequence
> GAP - thread 1 sequence 25666-25672
> DBID 1031489578 branch 672398063
>FAL[client]: All defined FAL servers have been attempted.
>
>Regards
>Krishna
>
>
>On 1/6/11, Howard Latham <howard.latham_at_gmail.com> wrote:
>> Need alert logs please.
>>
>> On 6 January 2011 14:48, KRISHNA MOORTHY <krish33moorthy_at_gmail.com> wrote:
>>
>>> Hi,
>>>
>>> We have oracle 10g dataguard configuration (one standby database).It was
>>> working fine for last 6 months.Standby database has down for 2 days.
>>>
>>> I have copied the password file and restored the entire database
>>> backup in standby site.
>>>
>>> I am getting the following error messag in Udump in primary box when i
>>> start the MRP process..
>>>
>>> FAL Redo Shipping Client Did Not Establish Network Login
>>>
>>> RFS process has not statrted.
>>>
>>>
>>> select process,status from v$managed_standby;SQL>
>>>
>>> PROCESS STATUS
>>> --------- ------------
>>> ARCH CONNECTED
>>> ARCH CONNECTED
>>> MRP0 WAIT_FOR_GAP
>>>
>>> Regards
>>> Krishna
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>
>> --
>> Howard A. Latham
>>
>> Sent from my Nokia N97
>>
>

-- 
Howard A. Latham

Sent from my Nokia N97
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 06 2011 - 09:27:12 CST