Oracle DB 12.1.0.2
GG v18.1
Hi ,
could you please help me with the steps to recover goldengate after restore?
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?
Regards,
Joe