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

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 6 Jan 2011 09:16:31 -0600
Message-ID: <AANLkTikt=aVAr66SkkpTwdGVS_N6hudZLvwvs_vK=A_H_at_mail.gmail.com>

Did you try manually copying the missing logs and registering them? Usually it will resume properly after that.

On Thu, Jan 6, 2011 at 9:06 AM, Howard Latham <howard.latham_at_gmail.com>wrote:

> 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
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 06 2011 - 09:16:31 CST