oracle goldengate 必须追加日志,oracle goldengate 开启后,数据库的重做日志就会被损坏...

各位大神,请帮忙看下:

goldengate 开启后,源端数据库切换日志文件是就会报错,提示如下:

thread-2108435-1-1.html

再次开启数据库时,报错如下:

thread-2108435-1-1.html

操作系统是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

5b24fae4cde99750994428c024162093.gifinstall /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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值