Thinking Out Loud

February 10, 2015

Goldengate – start replicat ATCSN or AFTERCSN?

Filed under: DataPump,GoldenGate,RMAN — mdinh @ 3:36 am

When using Goldengate to instantiate target database from an Oracle source database, replicat process can be started to coincide with extract based the method used for instantiation, e.g. RMAN or datapump.

ATCSN is used to start replicat if RMAN is used to instantiate target.
From Database Backup and Recovery Reference, UNTIL SCN specifies an SCN as an upper limit.
RMAN restore or recover up to but not including the specified SCN.

AFTERCSN is used to start replicat if datapump is used to instantiate target.
The export operation performed is consistent as of FLASHBACK_SCN.

Hope this helps to clear up when to use ATCSN versus AFTERCSN.

Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database –  Doc ID 1276058.1



  1. it is ATCSN and AFTERCSN, not ATSCN nor AFTERSCN

    Comment by ikke — May 19, 2015 @ 9:08 am | Reply

  2. Thank you for sharing your knowledge/experience

    Comment by eyen1 — June 24, 2016 @ 2:50 am | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at

%d bloggers like this: