<div>
<div class="content wysiwyg-content">
Hi, I have an oracle 10G that not in synch with DR box. I run the below query and found the gap, right now I want to apply the archive log and reduce the gap, what can I do here? what is the step?<br />
<br />
SQL&gt; select 'Thread '||a.thread#, max(a.sequence#) primary, max(b.sequence#) DR, max(a.sequence# ) - max(b.sequence#) gap<br />
&nbsp; 2 &nbsp; &nbsp; &nbsp; from v$archived_log a, v$archived_log b where a.archived='YES' and b.applied='YES' and b.applied='YES'<br />
&nbsp; &nbsp;and a.thread#=b.thread# group by a.thread#; &nbsp;3<br />
<br />
'THREAD'||A.THREAD# &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PRIMARY &nbsp; &nbsp; &nbsp; &nbsp; DR &nbsp; &nbsp; &nbsp; &nbsp;GAP<br />
--------------------------<wbr />----------<wbr />----------<wbr />- ---------- ---------- ----------<br />
Thread 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33891 &nbsp; &nbsp; &nbsp;33875 &nbsp; &nbsp; &nbsp; &nbsp; 16<br />
Thread 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32882 &nbsp; &nbsp; &nbsp;32863 &nbsp; &nbsp; &nbsp; &nbsp; 19<br />

</div>
</div>


Hi, I have an oracle 10G that not in synch with DR box. I run the below query and found the gap, right now I want to apply the archive log and reduce the gap, what can I do here? what is the step?

SQL> select 'Thread '||a.thread#, max(a.sequence#) primary, max(b.sequence#) DR, max(a.sequence# ) - max(b.sequence#) gap
  2       from v$archived_log a, v$archived_log b where a.archived='YES' and b.applied='YES' and b.applied='YES'
   and a.thread#=b.thread# group by a.thread#;  3

'THREAD'||A.THREAD#                                PRIMARY         DR        GAP
----------------------------------------------- ---------- ---------- ----------
Thread 1                                             33891      33875         16
Thread 2                                             32882      32863         19


DR getting gap with primary, data guard

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.