Answer: If your network is stable and secure, you can use RMTTASK. The reason is that RMTTASK doesn't stage captured data into files nor it has checkpoints. In the case of any failure, you have to start from scratch. The pro side is that RMMTTASK approach can give you better performance by using bulk loading APIs like SQL*Loader. However, it doesn't offer encryption and has limitations on datatypes such as lobs and UDTs. For other cases, you would use RMTFILES.
You can start with creating an initial load extract. The following is an example parameter file and the commands to create the extract. When using RMTFILE to creating trail files from initial load extract, there is a restriction on file has a 2GB size limit. For large initial load tasks, you need to use the MAXFILES and MEGABYTES options of the RMTFILE to create multiple trail files. When creating the extract, you need to use SOURCEISTABLE to define it as an initial load extract.
extract extinitd useridalias awsuser RMTHOST 129.144.0.33, MGRPORT 7865,socksproxy 127.0.0.1:9000 ENCRYPTTRAIL AES192 RMTFILE ./dirdat/ld, purge, maxfiles 100, megabytes 2048, format release 12.2 TABLE awsuser.member; GGCSI> add extract extinitd, sourceistable
GGCSI> start extract extinitd GGCSI> view report extinitd
*********************************************************************** * ** Run Time Statistics ** * *********************************************************************** Report at 2016-12-16 20:55:37 (activity since 2016-12-16 20:55:32) Output to ./dirdat/ld: From Table AWSUSER.MEMBER: # inserts: 10 # updates: 0 # deletes: 0 # discards: 0 REDO Log Statistics Bytes parsed 0 Bytes output 1365
You then can create a regular replicat shown as follows:
replicat repinitd useridalias ggadmin_tgt discardfile ./dirrpt/repinitd.dsc,append megabytes 50 map awsuser.member, TARGET pdb1.pmdemo.member;
add replicat repinitd exttrail ./dirdat/ld, checkpointtable PDB1.pmdemo.chkpttbl
GGSCI> stats repinitd Sending STATS request to REPLICAT REPINITD ... Start of Statistics at 2016-12-16 21:10:13. Replicating from AWSUSER.MEMBER to PDB1.PMDEMO.MEMBER: *** Total statistics since 2016-12-16 21:10:10 *** Total inserts 10.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 10.00 *** Daily statistics since 2016-12-16 21:10:10 *** Total inserts 10.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 10.00 *** Hourly statistics since 2016-12-16 21:10:10 *** Total inserts 10.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 10.00 *** Latest statistics since 2016-12-16 21:10:10 *** Total inserts 10.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 10.00 End of Statistics.