Dataguard logs

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Dataguard-logs-tp1478.html

Hello Erman,

I am doing a healthcheck on a database where dataguard is implemented(Oracle 9i)

SQL> select sequence#
from v$archived_log
where standby_dest='NO'
minus
select sequence#
from v$archived_log
where standby_dest='YES'
minus
select min(sequence#) from v$archived_log  2    3    4    5    6    7    8    9
10  ;
 
 
SEQUENCE#
----------
    386140
    386141
    386176
    386204
    386205
    386206
    386207
    386208
    386226
    386273
    386303
 
 
SEQUENCE#
----------
    386304
    386305
    386306
    386307
    386308
    386309
    386310
    386311
    386381
    386382
    386383
 
 
SEQUENCE#
----------
    386384
    386385
    386386
    386387
    386388
    386404
    386507
    386508
    386509
    386510
    386511
....
 
Do I need to transfer the archived  redo with above thread number to standby database?

SELECT UNIQUE THREAD# AS THREAD, MAX(SEQUENCE#)
  2  OVER (PARTITION BY thread#) AS LAST from V$ARCHIVED_LOG;
 
 
    THREAD       LAST
---------- ----------
         1     387993

Can you please advise
Regards,
Roshan