Database Networking (MOSC)

MOSC Banner

ORA-03135: connection lost contact

edited Oct 22, 2009 7:57AM in Database Networking (MOSC) 3 commentsAnswered
Hi, 1)    I executed the following comand on primary to create standby database. 

ALTER DATABASE ADD STANDBY LOGFILE .....

2) When I ran DG_phy_stby_diag.sql on standby database I got the following error:

SQL>
SQL> -- Determine if any error conditions have been reached by querying thev$dataguard_status
SQL> -- view (view only available in 9.2.0 and above):
SQL>
SQL> column message format a80
SQL> select message, timestamp
  2  from v$dataguard_status
  3  where severity in ('Error','Fatal')
  4  order by timestamp;

MESSAGE                                                                          TIMESTAMP
-------------------------------------------------------------------------------- -------------------------
RFS[2]: Unable to open standby log 4: 313                                        10ÔÂ-12-2009 09:09:42
RFS[1]: Unable to open standby log 7: 313                                        10ÔÂ-12-2009 09:09:42

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center