Home » Server Options » Data Guard » Log apply is not done on physical standby database (11gR2 linux)
Log apply is not done on physical standby database [message #474091] Thu, 02 September 2010 10:41
Bangla
Messages: 49
Registered: August 2008
Member
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>
Previous Topic: failover standby Rac
Next Topic: Newbie questions abt data guard
Goto Forum:
  


Current Time: Thu Mar 28 04:55:01 CDT 2024