DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, October 6, 2016

The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary database

We have got a error from OEM "The Data Guard status of xxxx is Error ORA-03135: connection lost contact."After that, we have resolve the error using below steps,

Step:1

Check the command in primary database side

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
ERROR     ORA-12541: TNS:no listener

Step:2

Start the listener in standby side

lsnrctl status
lsnrctl start listener_dbname

Step:3

Mount the standby database and enable MRP Process

Startup mount

alter database recover managed standby database disconnect from session;

Step:4

After login to primary database side,defer and enable the standby destination  log_archive_dest

SQL>Show parameter log_archive_dest_state;

SQL> alter system set log_archive_dest_state_2=defer;

System altered.

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

Step 5:

Check the status of standby side from primary database

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
VALID

Step:6

Check both primary and standby database sync now.....

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;


   Thread Last Sequence Received Last Sequence Applied Difference
--------- ---------------------- --------------------- ----------
        1                  51031                 51031          0
        2                  49482                 49482          0



1 comment:

Sridevi Koduru (Oracleappstechnical.com) said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.