Golden Gate Sync Using EXPDP and IMPDP :
1. Find CURRENT_SCN or FLASHBACK SCN:
1. Find CURRENT_SCN or FLASHBACK SCN:
select CURRENT_SCN, dbms_flashback.get_system_change_number from v$database;
2. No need to stop the EXRACT and REPLICATE Source: EXPDP with FLASHBACK_SCN = 999999999 scp expdp dump file to target server
3. Target: IMPDP – import Metadata and data STOP EXTRACT STOP REPLICATE Added following command into REPLICATE.prm file for NEW TABLE only: MAP Schema_Name.New_Table_Name ,TARGET Schema_Name.New_Table_Name ,
FILTER ( @GETENV ("TRANSACTION", "CSN") > 999999999); START EXTRACT START REPLICATE
No comments:
Post a Comment