环境说明
OS操作系统:AIX
数据库版 本:ORACLE 11.2.0.4
OGG重新初始化步骤
1、关闭目标端的日志应用进程:
2.确认源端的数据抽取进程已经启动
GGSCI> info all
3、导出数据:
vi exp_data_par
USERID ="/ AS SYSDBA"
DIRECTORY =EXPDATA
SCHEMAS = JYT_OLM,OLM
DUMPFILE =EXP_DATA_OGG_%U.DUMP
LOGFILE = EXP_DATA.LOG
PARALLEL = 10
FLASHBACK_SCN =15179207956928
COMPRESSION =ALL
CLUSTER = N
nohup expdp parfile=/expdata/dmp/exp_data_par &
4、 目标端也备份下数据:
--OGG目标端备份
vi exp_data_par_2
USERID ="/ AS SYSDBA"
DIRECTORY =EXPDATA
SCHEMAS = JYT_OLM,LIXIA,OLM
DUMPFILE =EXP_DATA_OLM_20161104_2_%U.DUMP
LOGFILE = EXP_DATA_OLM.LOG
PARALLEL = 10
COMPRESSION =ALL
CLUSTER = N
JOB_NAME=OGG_EXP
nohup expdp parfile=/expdata/dmp/exp_data_par_2 &
5、复制DUMP文件到目标端:
6、确认目标端日志应用进程没启动:
GGSCI>info all
8、目标端导入数据:
--生成禁用外键的脚本,然后执行该脚本
select 'alter table '||OWNER||'.'||table_name||' disableconstraint '||constraint_name||';'
from dba_constraints where constraint_type='R'
and OWNER in
('JYTSRJ','JS_ADP');
--只导入数据
impdp \'/ as sysdba\' DIRECTORY =EXPDATAREMAP_SCHEMA =OLM:JS_OLMDUMPFILE =EXP_DATA_OGG_%U.DUMP LOGFILE =
IMP_DATA.LOG PARALLEL = 10 CLUSTER = N content=data_only
TABLE_EXISTS_ACTION=TRUNCATE
--生成启用外键的脚本,然后执行脚本
select 'alter table '||OWNER||'.'||table_name||' disableconstraint '||constraint_name||';'
from dba_constraints where constraint_type='R'
and OWNER in
('JYTSRJ','JS_ADP');
9、目标端启动日志应用进程:
ggsci> start R_TS_ADP,aftercsn 15179207956928