Please help me to resolve the issue, tnsping and database process all are working but getting error messages as well as output.
From primary database,
SQL> select max(sequence#), thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
124 1
94 2
SQL> col DESTINATION for a40
SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -
> FROM V$ARCHIVE_DEST_STATUS -
> WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';
SELECT DEST_ID "ID",STATUS "DB_status",DESTINATION "Archive_dest",ERROR "Error" FROM V$ARCHIVE_DEST WHERE DEST_ID =2;
select error from v$archive_dest_status where error is not null;
DESTINATION STATUS ARCHIVED_THREAD#
---------------------------------------- --------- ----------------
ARCHIVED_SEQ#
-------------
VALID 1
124
bddipdrs ERROR 0
0
SQL> SQL> SQL>
ID DB_status
---------- ---------
Archive_dest
--------------------------------------------------------------------------------
Error
-----------------------------------------------------------------
2 ERROR
bddipdrs
ORA-16198: Timeout incurred on internal channel during remote
archival
From standby database,
SQL> select max(sequence#), thread# from v$archived_log group by thread#;
col DESTINATION for a40
no rows selected
SQL> SQL> SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -
> FROM V$ARCHIVE_DEST_STATUS -
> WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';
SELECT DEST_ID "ID",STATUS "DB_status",DESTINATION "Archive_dest",ERROR "Error" FROM V$ARCHIVE_DEST WHERE DEST_ID =2;
DESTINATION STATUS ARCHIVED_THREAD#
---------------------------------------- --------- ----------------
ARCHIVED_SEQ#
-------------
VALID 0
0
bddipdrs VALID 0
0
VALID 0
0
SQL> SQL> SQL>
ID DB_status
---------- ---------
Archive_dest
--------------------------------------------------------------------------------
Error
-----------------------------------------------------------------
2 VALID
bddipdrs
SQL> SQL> select error from v$archive_dest_status where error is not null;
no rows selected
From standby database,
<msg time='2010-09-02T21:30:25.422+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module='oracle@DC-DB-01 (TNS V1-V3)'
pid='13010'>
<txt>RFS[2]: Possible network disconnect with primary database
</txt>
</msg>
<msg time='2010-09-02T21:31:19.259+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module='oracle@DC-DB-01 (TNS V1-V3)'
pid='13014'>
<txt>RFS[6]: Possible network disconnect with primary database
</txt>
</msg>
<msg time='2010-09-02T21:31:19.265+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module=''
pid='13014'>
<txt>Deleted Oracle managed file +RECOVERY/bddipdrs/archivelog/2010_09_02/thread_2_seq_90.289.728688311
</txt>
</msg>
<msg time='2010-09-02T21:32:10.314+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module='oracle@DC-DB-01 (TNS V1-V3)'
pid='13020'>
<txt>RFS[7]: Possible network disconnect with primary database
</txt>
</msg>
<msg time='2010-09-02T21:32:59.423+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module='oracle@DC-DB-01 (TNS V1-V3)'
pid='13026'>
<txt>RFS[10]: Possible network disconnect with primary database
</txt>
</msg>
<msg time='2010-09-02T21:32:59.430+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module=''
pid='13026'>
<txt>Deleted Oracle managed file +RECOVERY/bddipdrs/archivelog/2010_09_02/thread_1_seq_107.288.728688311
</txt>
</msg>
<msg time='2010-09-02T21:33:00.664+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module=''
pid='13519'>
<txt>Fetching gap sequence in thread 1, gap sequence 107-122
</txt>
</msg>
<msg time='2010-09-02T21:33:45.941+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module='oracle@DC-DB-01 (TNS V1-V3)'
pid='13012'>
<txt>RFS[3]: Possible network disconnect with primary database
</txt>
</msg>
<msg time='2010-09-02T21:33:45.947+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DRS-DB-01' host_addr='192.168.105.101' module=''
pid='13012'>
<txt>Deleted Oracle managed file +RECOVERY/bddipdrs/archivelog/2010_09_02/thread_2_seq_89.301.728688311
</txt>
</msg>
From primary database,
<msg time='2010-09-02T21:34:23.966+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9533'>
<txt>Reclaiming FAL entry from dead process [pid 5732]
</txt>
</msg>
<msg time='2010-09-02T21:34:23.976+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9519'>
<txt>Reclaiming FAL entry from dead process [pid 5720]
</txt>
</msg>
<msg time='2010-09-02T21:34:23.992+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9511'>
<txt>Reclaiming FAL entry from dead process [pid 5734]
</txt>
</msg>
<msg time='2010-09-02T21:34:23.999+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9523'>
<txt>Reclaiming FAL entry from dead process [pid 5724]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.002+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9513'>
<txt>Reclaiming FAL entry from dead process [pid 5730]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.011+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9517'>
<txt>Reclaiming FAL entry from dead process [pid 5728]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.013+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9509'>
<txt>Reclaiming FAL entry from dead process [pid 5738]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.014+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9531'>
<txt>Reclaiming FAL entry from dead process [pid 5740]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.031+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9529'>
<txt>Reclaiming FAL entry from dead process [pid 5742]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.048+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9539'>
<txt>Reclaiming FAL entry from dead process [pid 5746]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.058+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9547'>
<txt>Reclaiming FAL entry from dead process [pid 5750]
</txt>
</msg>
<msg time='2010-09-02T21:34:24.768+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='5697'>
<txt>ARCt: Archival started
</txt>
</msg>
<msg time='2010-09-02T21:34:24.768+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='5697'>
<txt>ARC3: STARTING ARCH PROCESSES COMPLETE
</txt>
</msg>
<msg time='2010-09-02T21:34:25.798+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='5744'>
<txt>ARCq: Standby redo logfile selected for thread 1 sequence 122 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:25.815+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='5695'>
<txt>ARC2: Standby redo logfile selected for thread 2 sequence 88 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:26.535+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9515'>
<txt>ARCd: Standby redo logfile selected for thread 1 sequence 110 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:27.174+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9529'>
<txt>ARCk: Standby redo logfile selected for thread 1 sequence 120 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:27.402+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9533'>
<txt>ARCm: Standby redo logfile selected for thread 1 sequence 112 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:27.498+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9511'>
<txt>ARCb: Standby redo logfile selected for thread 1 sequence 114 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:28.205+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9527'>
<txt>ARCj: Standby redo logfile selected for thread 1 sequence 111 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>
<msg time='2010-09-02T21:34:28.592+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='9531'>
<txt>ARCl: Standby redo logfile selected for thread 1 sequence 119 for destination LOG_ARCHIVE_DEST_2
</txt>
</msg>