Shulou(Shulou.com)06/01 Report--

1. Source process configuration: add local crawl process exta add ext exta, tranlog, begin now specify crawl log to add exttrail / u01qqoracleUniverse productUniverse oracleUniverse exta, MEGABYTES 20 add remote delivery dpea process ADD EXTRACT dpea, EXTTRAILSOURCE / u01/app/oracle/product/ogg_src/dirdat/ra specify dpea process delivery destination add rmttrail / u01Appleoraclepact productSequenceoggdirdatraQuery ext dpea MEGABYTES 20 II. Expdp/impdp initializes the table on the source side: view the current SCN number select current_scn from v$database CURRENT_SCN-1081055 logs in as a sys user and authorizes to read and write to ogg create directory ogg_dir as'/ u01OnOnOnApplet oracleUniverse productUnix oggpromosrcUnioggAccorddirdust; grant read,write on directory ogg_dir to ogg Export data expdp ogg/ogg directory=ogg_dir dumpfile=ogg1.dmp logfile=oggtest1.log tables=ogg.oggtest1 flashback_scn=1081055 target side: log in as a sys user and authorize to read and write to ogg create directory ogg_dir as'/ u01UniplicorAcleUniplicorAcleUniplicorAcleUniplemoggActureActureAccording to grant read,write on directory ogg_dir to ogg; import data impdp ogg/ogg directory=ogg_dir dumpfile=ogg1.dmp logfile=oggtest1.log tables=oggtest1 table_exists_action=replace 3. Add repa process add rep repa, exttrail / u01/app/oracle/product/ogg/dirdat/ra, nodbcheckpoint to edit repa process edit param repa replicat repa userid ogg, password ogg reperror default,abend discardfile / u01plash to add repa process edit param repa replicat repa userid ogg, password ogg reperror default,abend discardfile / u01qqapcale oracle to produce ogg, megabytes to dirrpt, repa.dsct to repa.dsct, to append, 10 to, and to Enable the repa process to parse the trail file start repa aftercsn 1085091 in this case, the dump process in OGG is used to deliver the data to the destination, or you can directly use the extact process to deliver the data to the destination, but each has its own advantages and disadvantages.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.