The last archive log received:
select max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# /
Last Standby Seq Received |
---|
116227 |
The last archive log applied:
select thread#, max(sequence#) "Last Standby Seq Applied" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# and val.applied in ('YES','IN-MEMORY') group by thread# order by 1;
THREAD# | Last Standby Seq Applied |
---|---|
1 | 112772 |
As can be seen from the above queries, the standby database is applying older logs that constitute a gap, since the last log applied has a lower sequence number than the last one to be received from the primary database.
The queries were supplied by Oracle Support.
No comments:
Post a Comment