Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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 --------------------- 0
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.
