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_ROUTER,MM_UC.T_USER_ROUTER flashback_scn=10919386996390 parallel=2 &
gd-uc02:[/ogghome/ogghome2/my_dump$]ls -ltr
total 84486968
-rw-r--r-- 1 oracle asmadmin 17772 Jun 10 15:47 init.log
-rw-r----- 1 oracle asmadmin 21954220032 Jun 10 15:47 init01.dmp
-rw-r----- 1 oracle asmadmin 21302800384 Jun 10 15:47 init02.dmp
-rw------- 1 oracle oinstall 17765 Jun 10 15:47 nohup.out
scp /ogghome/ogghome2/my_dump/init01.dmp user@host:/ogghome/my_dump
scp /ogghome/ogghome2/my_dump/init02.dmp user@host:/ogghome/my_dump
chmod 777 /ogghome/my_dump/init01.dmp
chmod 777 /ogghome/my_dump/init02.dmp
nohup impdp goldengate/***** directory=impdir dumpfile=init01.dmp,init02.dmp logfile=init.log table_exists_action=replace &
按照rep进程启动scn
start REPMMUC, aftercsn 10919386996390
start REPMMUC2, aftercsn 10919386996390
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24996904/viewspace-1179819/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24996904/viewspace-1179819/