oracle goldengate 开启后，数据库的重做日志就会被损坏

chennie

各位大神，请帮忙看下：


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 oracleinstall /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

chennie

补充： 报错如下
SQL> alter system switch logfile;
alter system switch logfile
                          *
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 47709
Session ID: 191 Serial number: 5


SQL> startup
ORACLE instance started.

Total System Global Area 3073216512 bytes
Fixed Size                    2257192 bytes
Variable Size                  704646872 bytes
Database Buffers         2348810240 bytes
Redo Buffers                   17502208 bytes
Database mounted.
ORA-00316: log 2 of thread 1, type 0 in header is not log file
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/mytest11/redo02.log'

newkid

这个只能找oracle support了。

chennie

newkid 发表于 2019-2-22 23:29
这个只能找oracle support了。

我试过ogg11.ogg12 版本都是这样。如果在正式库操作，那就太危险了