Oracle Data Pump can be used to load the historical data from the source database to the target database to ensure the source and target databases are in synch before the data can be replicated. Data Pump is useful when a subset of the database is being replicated. If the full database is being replicated, consider using standby database, rman duplicate or rman restore and recover to create the target database, although Data Pump can be still be used for copying the full database.
...
No Format | ||
---|---|---|
| ||
echo ======================================== echo EXPORT echo ======================================== expdp SYSTEM/xxxxxx@d112f_dbvisit210 dumpfile=OE_SHEMA.dmp directory=DATA_PUMP_DIR \ flashback_scn=xxxxxxxxxx tables=OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,\ OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,\ OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,\ OE.STRESSTESTTABLE,OE.WAREHOUSES \ logfile=exp_OE_schema.log JOB_NAME=DP_d112f_0001 echo ======================================== echo IMPORT echo ======================================== impdp SYSTEM/xxxx@d112f_dbvisit230 dumpfile=OE_SHEMA.dmp directory=DATA_PUMP_DIR logfile=imp_OE_SCHEMA.log |
Note |
---|
The EXPORT part has to be run on the source server and the IMPORT part has to be run on the target server. If you have multiple tables that differ just by the special character and you select one-by-one, then you get duplicate file names when the APPLY.sh is generated. Please check the APPLY.sh file before exporting and confirm dump file names are unique and make adjustments if necessary in the file before running. |
Note |
---|
If have LOB tables that are have high amount of concurrent updates as well as reads of the LOB column and you are getting ORA-01555: snapshot too old:
|
The normal order of starting the replication and running Data Pump is:
...