dblogin userid goldengate, password WSdS3VN9

删除指定目录的日志文件

--delete extract e_bil
add extract e_bil, tranlog, begin now,threads 2
add exttrail /usr1/userdata/goldengate/dirdat/bossbil_ods/ex, extract e_bil,megabytes 200



删除并增加传输进程：
--delete extract p_bil
add extract p_bil, exttrailsource /usr1/userdata/goldengate/dirdat/bossbil_ods/ex
add rmttrail /backup/goldengate/dirdat/bossbil_ods3/re, extract p_bil, megabytes 200


启动抽取和传输进程：
start e_bil 
start p_bil




--删除目标端进程
delete replicat r_bil3

--重新添加复制进程
add checkpointtable goldengate.ckpt_bil3
add replicat r_bil3, exttrail /backup/goldengate/dirdat/bossbil_ods3/re, checkpointtable goldengate.ckpt_bil3


--查看源端SCN:
select to_char(dbms_flashback.get_system_change_number,99999999999999999999999999) getscn from dual;
14322757697893
--启动复制进程：
start r_bil3, aftercsn 14322757697893





dblogin userid goldengate, password WSdS3VN9
--delete extract e_crm
删除抽取进程相关GGLOG日志
mkdir -p  /usr1/userdata/goldengate/dirdat/bosscrm_ods/
--rm -rf f*
增加新的抽取进程：
--delete extract e_crm
add extract e_crm, tranlog, begin now,threads 2
add exttrail /usr1/userdata/goldengate/dirdat/bosscrm_ods/ex, extract e_crm,megabytes 200
删除并增加传输进程：
--delete extract p_crm
add extract p_crm, exttrailsource /usr1/userdata/goldengate/dirdat/bosscrm_ods/ex
add rmttrail /backup/goldengate/dirdat/bosscrm_ods3/re, extract p_crm, megabytes 200
启动抽取和传输进程：
start e_crm
start p_crm

--
delete replicat r_crm3
add replicat r_crm3, exttrail /backup/goldengate/dirdat/bosscrm_ods3/re, checkpointtable goldengate.ckpt_crm3

--查看源端SCN:
select to_char(dbms_flashback.get_system_change_number,99999999999999999999999999) getscn from dual;
14322757697893

start r_crm3, aftercsn 14322757813405
