RMAN restore - golden gate recovery

[Roshan]

Oracle DB 12.1.0.2
Golden Gate v18.2
RAC 2 nodes

Hello Erman,

my environment has a downstream replication of tables from source. I would like to know after I restore the DB on a new server and reconfigure the downstrean replication, how would I recover the tablespaces containing the tables replicated using GoldenGate and as from what scn should I start replicat after restore?

Thanks,

Roshan

[Roshan]

I have checked the doc (ID 2521049.1).

SQL> desc dba_gg_inbound_progress
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SERVER_NAME                               NOT NULL VARCHAR2(128)
 PROCESSED_LOW_POSITION                             VARCHAR2(4000)
 APPLIED_LOW_POSITION                               VARCHAR2(4000)
 APPLIED_HIGH_POSITION                              VARCHAR2(4000)
 SPILL_POSITION                                     VARCHAR2(4000)
 OLDEST_POSITION                                    VARCHAR2(4000)
 APPLIED_LOW_SCN                           NOT NULL NUMBER
 APPLIED_TIME                                       DATE
 APPLIED_MESSAGE_CREATE_TIME                        DATE
 SOURCE_DATABASE                                    VARCHAR2(128)
 SOURCE_ROOT_NAME                                   VARCHAR2(128)
 LOGBSN                                             VARCHAR2(4000)

Can you please advise which field should I choose to check the low water mark?

Are the steps below ok to check the csn in trail files?

Logdump 18 >open <any trail file on server>
Logdump 19 >pos <low water mark CSN>
Reading forward from RBA <low water mark CSN>
Logdump 20 >detail data
Logdump 21 >ggstoken detail
Logdump 22 >sfh

How do I start from rba 0 of that trail with AFTERCSN?

alter replicat<replicat_name> extseqno <seq num from trail file> extrba 0

then

start replicat <replicat_name> aftercsn <low watermark CSN>
Regards,

Roshan

[ErmanArslansOracleBlog]

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.