各位大神,请帮忙看下:
goldengate 开启后,源端数据库切换日志文件是就会报错,提示如下:
再次开启数据库时,报错如下:
操作系统是redhat7.0 ,oracle 版本是11.2 , goldengate 的版本是,12.3 ,配置如下:
(源和目标)设置数据库参数 alter database force logging;
alter database add SUPPLEMENTAL log data;
alter system set enable_goldengate_replication=true scope=both;
alter system set log_archive_dest_1='LOCATION=/u01/arch/' scope=both;
alter system archive log current; (源和目标) 建立Goldengate的安装目录 mkdir /ogg/ogg
chown -R oracle
install /ogg/ogg安装Goldengate unzip /tmp/123014_fbo_ggs_Linux_x64_shiphome.zip
vim /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
INSTALL_OPTION=ORA11g
SOFTWARE_LOCATION=/ogg/ogg
vi /u01/app/oraInventory/ContentsXML/inventory.xml /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller -silent -nowait -responseFile /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
添加oracle 环境变量
export OGG_HOME=/ogg/ogg
export PATH=$OGG_HOME:$PATH
create user goldengate identified by goldengate default tablespace users;
grant dba to goldengate; 源和目标 ggsci
create subdirs
edit param mgr PORT 7809 start mgr 源端 create user test001 identified by test001 default tablespace users;
grant dba to test001;
conn test001/test001
create table t1 as select * from scott.emp;
ggsci
dblogin userid goldengate,password goldengate
add trandata test001.t1 目标端 create user test001 identified by test001 default tablespace users;
grant dba to test001;
conn test001/test001
create table t1 as select * from scott.emp where 1=2; 源端 ggsci
add ext exta,tranlog,begin now
add exttrail /ogg/ogg/dirdat/la, ext exta, MEGABYTES 20
add extract dpea, EXTTRAILSOURCE /ogg/ogg/dirdat/la
add rmttrail /ogg/ogg/dirdat/ra, ext dpea, MEGABYTES 20
edit param exta
EXTRACT exta
setenv (NLS_LANG = 'AMERICAN_AMERICA.AL32UTF8')
setenv (ORACLE_SID = mytest11)
USERID goldengate, PASSWORD goldengate
EXTTRAIL /ogg/ogg/dirdat/la
dynamicresolution
table test001.t1; edit param dpea
EXTRACT dpea
setenv (NLS_LANG = 'AMERICAN_AMERICA.AL32UTF8')
passthru
rmthost 192.168.14.37, mgrport 7809, compress
rmttrail /ogg/ogg/dirdat/ra
dynamicresolution
table test001.t1; start exta
start dpea
info all 目标端 ggsci
add rep repa, exttrail /ogg/ogg/dirdat/ra, nodbcheckpoint
edit param repa
replicat repa
setenv (NLS_LANG = 'AMERICAN_AMERICA.AL32UTF8')
setenv (ORACLE_SID = rftestdb)
userid goldengate, password goldengate
reperror default,abend
discardfile /ogg/ogg/dirrpt/repa.dsc, append, megabytes 10
assumetargetdefs
dynamicresolution
map test001.t1, target test001.t1; start repa
info all