GoldenGate 自动化初始数据

源端、目标端环境如下：

SLES 11SP4

Oracle 11.2.0.4

GoldenGate: 11.2.1.0.33

涉及用户相关信息中数据表及密码已加密或替换。

脚本说明:

 复制出现问题或其他原因需要做ogg初始化需在源端执行ogg_expdp.sh，执行完成后，需要在目标端执行ogg_impdp.sh,执行完成后复制关系启动。

源端ogg_expdp.sh内容：

racle@test2:/orabak> more ogg_expdp.sh 

#!/bin/bash

BACKUPDIRECTORY=/dbbackup

REMOTE_DIR=/dbbackup

fcn=`sqlplus -S / as sysdba <<EOF 

select  'curnt_scn:'||dbms_flashback.get_system_change_number scn from dual;

 exit

 EOF`

fsn=`echo $fcn | awk -F ':' {'print $2'}`

echo "SCN: $fsn"

expdp Gaoyc/XXXCCC  dumpfile=ogg_Gaoyc.dmp logfile=ogg_Gaoyc.log directory=expdp_dir  flashback_scn=$fsn tables=table1,table2,table3

ftp -n<<EOF

open 192.168.15.210

user oracle gyc123

cd $REMOTE_DIR

lcd $BACKUPDIRECTORY

prompt off

bin

mput ogg_Gaoyc*

bye

EOF

echo "Dump is send to 192.168.15.210"

cd $BACKUPDIRECTORY

rm ogg_Gaoyc*

echo "Dump is deleted"

目标端ogg_impdp.sh内容：

[oracle@testdb orabak]$ more ogg_impdp.sh 

#!/bin/bash

dmp_dir=/dbbackup

ogg_dir=/goldengate

q_name=rep_tzdb

sqlplus -s / as sysdba<<EOF

truncate table  Gaoyc.table1;

truncate table  Gaoyc.table2;

truncate table  Gaoyc.table3;

exit

EOF

cd $dmp_dir

csn=`cat ogg_Gaoyc.log | grep  -i flashback_s | awk -F '=' {'print $5'} | awk {'print $1'}`

echo "scn: $csn"

impdp Gaoyc/gyc01  dumpfile=ogg_Gaoyc.dmp logfile=ogg_Gaoyc_impdp.log directory=expdp_dir INCLUDE=TABLE_DATA

echo "Import has been completed"

rm ogg_Gaoyc.*

cd $ogg_dir

commd="start rep_tzdb,  ATCSN $csn"

echo $commd

echo $commd | ./ggsci

说明：

  初始化涉及两个脚本，可以合并为一个脚本，中间可通过ssh无密码登录执行另一个脚本或者通过expect远程登录执行。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24585765/viewspace-2199242/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24585765/viewspace-2199242/