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