standby database

[anukhe]

Hi to all
On a standby database I found unequel sequence# between two views

select max(SEQUENCE#) from v$log_history;


MAX(SEQUENCE#)
--------------
2046

select max(SEQUENCE#) from v$log;

MAX(SEQUENCE#)
--------------
2043

The 2046 is the same as on the primary database
Why is that? Which view is actual ?

Platform: Lynux red hat
Database: oracle 9.2.0.4

Thaks
Anukhe

[Mohith123]

Please see the definition of column sequence#

V$LOG_HISTORY
SEQUENCE# Sequence number of the archived log

V$LOG
SEQUENCE# Log sequence number

[anukhe]

Please see the definition of column sequence#

V$LOG_HISTORY
SEQUENCE# Sequence number of the archived log

V$LOG
SEQUENCE# Log sequence number

Why the sequence# I'v got is not the same between those views?

[Mohith123]

V$LOG_HISTORY
shows the SEQUENCE# of archived redo log
where as V$LOG
shows the SEQUENCE# of current online redo log