- Import/Export with the flashback_scn option and start replication with aftercsn
- Backup with RMAN and start replciat with atcsn
SCN is used in Oracle Database means SCN (System Change/Commit Number). CSN is used by Oracle GoldenGate means CSN (Checkpoint Sequence Number). They both refer to the same number for Oracle database transactions.
The steps are as follows:â€‹
GGSCI>start extract exext, begin now
SQL> select dbms_flashback.get_system_change_number() from dual; (for schema export) SQL> select current_scn from v$database ; (for database export)