重置 oracle ogg,ogg进程重新初始化

ogg进程重新初始化

Extract：

GGSCI>alter extract EXPMMUC, tranlog, begin now

GGSCI>alter extract DPMMUC, begin now

启动源端进程：

GGSCI> start extract EXPMMUC

GGSCI> start extract DPMMUC

SQL>  select dbms_flashback.get_system_change_number scn from dual;

scn

------------------------

10919386996390

SQL> create directory expdir as '/ogghome/ogghome2/my_dump';

目录已创建。

SQL> grant read,write on directory expdir to goldengate;

授权成功。

SQL> create directory impdir as '/ogghome/my_dump';

目录已创建。

SQL> grant read,write on directory impdir to goldengate;

授权成功。

nohup expdp goldengate/***** directory=expdir dumpfile=init%U.dmp logfile=init.log tables=MM_PS.T_USER_GRADE,MM_PS.GRADEHISTORY,MM_UC.T_USER_INFO,MM_UC.T_STATION_INFO,MM_UC.T_NUMBER_ROU