Determine if Shareplex and Oracle are on the same redo log (74)
Determine if Shareplex and Oracle are on the same redo log
Shareplex for Oracle all versions: This sql statement can be used to determine if Shareplex is falling behind Oracle in processing the redo logs.
seqno from the shareplex_actid is the redo log sequence number Shareplex is currently on.
sequence# from v$log where status=CURRENT is the redo log sequence number Oracle is currently on.
Issue this sql statement...
select sequence#-seqno "Logs Shareplex is behind" from shareplex_actid,v$log where status=CURRENT;
Logs Shareplex behind
This will return a value of how many redo logs Shareplex is behind oracle. If the number is 0, then you are caught up in processing the redo logs.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.