Table Based GoldenGate initial load

Hello, I will explain how to make Table-based Goldengate initial load and the points to be considered.

In this article, the point to be considered while exporting is flashback scn, in the meantime, flashback scn snapshot of the database needs to be taken.

select dbms_flashback.get_system_change_number from dual;
SELECT CURRENT_SCN FROM V$DATABASE;

After getting flashback scn we can start export shoulder

expdp "'/ as sysdba'" DIRECTORY=TP_DIR dumpfile=Test.load.dmp logfile=Test.load.log cluster=no parallel=2 TABLES=Test.deneme,Test.deneme2,Test.deneme3,Test.deneme4 flashback_scn=16469693058776

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

Leave a Reply

Your email address will not be published. Required fields are marked *