Re: RMAN restore - golden gate recovery

Posted by ErmanArslansOracleBlog on Mar 02, 2020; 8:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-golden-gate-recovery-tp8086p8105.html

applied_low_position should be the LWMs..

Here in this note it says LWMs can be checked with -> Replicat abend - OGG-01029 Extract reposition err - Could not reposition -- /orasw/app/ggs/dirdat/d2000000 missing. (Doc ID 2071269.1)

 select processed_low_position, applied_low_position from dba_gg_inbound_progress;

So I think that LWM value is presented in the column APPLIED_LOW_POSITION.

Check this presentation -> http://www.aioug.org/OTNYATHRA2017/Oracle_GoldenGate_IRCTC.pdf

Especially pages ->  44-52

Check this blog post as well -> https://raviarra.wordpress.com/2015/09/04/integrated-replicat-abends-as-trail-files-were-missing/   -here again the APPLIED_LOW_POSITION column is used and here we also see AFTER_SCN is used.

These might help you.