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

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <krish33moorthy@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 Jan 2011 13:52:00 -0500

Ok,  Looking over all of the messages I'd say there are potentially two
problems:

        1) is sqlnet connectivity between the two databases possible and
yes I mean between both in both directions.  MRP0 will always start and
is waiting for the next redo log needed.  Not having  RFS up means to me
that there is a problem with the sqlnet connectivity.  Either the
standby cannot connect to the primary thereby stating the transfer of
the current log file or your standby destination is disabled.  Take a
look at the primary site's alert log.

        2) Your fal server/fal client setup is fouled up.  Yes the
server is the primary db sqlnet alias on the standby side and the
fal_cleint needs to be the service specified in the archive_log_dest_x
parameter on the primary and that destination HAS to be enabled.


Dick Goulet
Senior Oracle DBA


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of KRISHNA MOORTHY
Sent: Thursday, January 06, 2011 9:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ORACLE 10g DG Synch Up issues (FAL Redo Shipping Client Did Not
Establish Network Login)

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
--
//www.freelists.org/webpage/oracle-l


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


Other related posts: