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

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 6 Jan 2011 15:06:09 +0000
Message-ID: <AANLkTimXh3PdGEJ6DuHmgW3egZ+fKdC=WPOrOmYWUoaQ_at_mail.gmail.com>



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:06:09 CST

Original text of this message