This discussion is archived
1 Reply Latest reply: Dec 3, 2013 3:21 AM by mseberg RSS

Determining the last archive applied on Logical Standby

Jimbo Explorer
Currently Being Moderated

Hi,

 

I am trying to determine the last log received and applied on my Logical Standby

 

SQL> select thread#, max(sequence#) "Last Standby Seq Received"

from v$archived_log val, v$database vdb

where val.resetlogs_change# = vdb.resetlogs_change#

group by thread# order by 1;

 

   THREAD# Last Standby Seq Received

---------- -------------------------

         1                       14

 

SQL> select thread#, max(sequence#) "Last Standby Seq Applied"

from v$archived_log val, v$database vdb

where val.resetlogs_change# = vdb.resetlogs_change#

and applied='YES'

group by thread# order by 1;

 

Does not return anything

 

These statements work ok on a physical standby.

 

I know Sql Apply is enabled on my logical standby - my broker configuration is enabled and for the logical standby database, it is showing the Intended State as APPLY-ON with no Transport or Apply Lag on any of the databases

 

Q. How do I determine the last seq applied on my logical standby ?

 

thanks,

Jim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points