★ FEATURED ARTICLE 基于Linux环境使用ogg19版本对oracle 19c同步数据在之前一期文章中提到了 “基于Windows测试OGG远程从ADG备库抽取数据”。文章的最后提到了在Linux环境测试失败的情况在这一期的文章中测试了Linux环境但是使用的数据库版本和OGG版本均是19的。之前那一期的数据库版本是11.2.0.4 ogg版本是12.1.0.1。有可能是因为版本的问题导致。此次案例测试中数据可以成功抽取成功。说明代码有些部分对不上是因为测试过程种来回切换有些关键字也虚拟模糊了步骤和方法是正确的。静默安装OGG./runInstaller -silent -nowait -responseFile /so/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp数据库ADG搭建请翻阅前面的文章链接: oracle 19c搭建dataguard(ADG)全过程源端和目标端创建OGG同步用户源端(10.120.84.25)和目标端创建同步管理账号 --84.25 create tablespace tbsogg datafile DATA/xx/DATAFILE/tbsogg.dbf size 1024m autoextend on next 10m; --103.54 create tablespace tbsogg datafile D:\APP\ADMINISTRATOR\ORADATA\xxx\tbsogg01.dbf size 1024m autoextend on next 10m; create user ggs identified by xxx default tablespace tbsogg temporary tablespace temp; grant connect ,resource,unlimited tablespace to ggs; grant execute on utl_file to ggs; grant select any dictionary,select any table to ggs; grant alter any table to ggs; grant flashback any table to ggs; grant execute on dbms_flashback to ggs; grant execute on sys.DBMS_STREAMS to ggs; grant execute on dbms_xstream_gg_adm to ggs; grant execute on DBMS_CAPTURE_ADM to ggs; grant SELECT ANY TRANSACTION to ggs; EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(ggs); grant execute on sys.DBMS_STREAMS to ggs; grant execute on dbms_xstream_gg_adm to ggs; grant execute on dbms_streams_adm to ggs; grant execute on DBMS_CAPTURE_ADM to ggs; grant execute on dbms_xstream_gg_adm to ggs; grant SELECT ANY TRANSACTION to ggs;数据库连接串配置#primary ORA104 (DESCRIPTION (ADDRESS_LIST (ADDRESS (PROTOCOL TCP)(HOST 192.168.56.104)(PORT 1521)) ) (CONNECT_DATA (SERVICE_NAME woo) ) ) #standby ORA105 (DESCRIPTION (ADDRESS_LIST (ADDRESS (PROTOCOL TCP)(HOST 192.168.56.105)(PORT 1521)) ) (CONNECT_DATA (SERVICE_NAME woo) ) )MGR进程配置port 5000 dynamicportlist 5001-5050 autorestart extract *,retries 5,waitminutes 3 purgeoldextracts ./dirdat/*, usecheckpoints,minkeepdays 3 accessrule, prog *, ipaddr *, allow lagreporthours 1 laginfominutes 30 lagcriticalminutes 45创建OGG登录别名--创建用户凭证别名 add credentialstore --创建到源端的登录别名 --登录源端主库别名 alter credentialstore add user ggsxxx, password Caecaodb2017 alias xx alter credentialstore add user ggsxxx, password Caecaodb2017 alias xx alter credentialstore add user ggsxxx, password Caecaodb2017 alias xxx --登录源端备库别名 alter credentialstore add user ggsxxx, password Caecaodb2017 alias xxx alter credentialstore add user ggsxxx, password Caecaodb2017 alias xxx alter credentialstore add user ggsxxx, password Caecaodb2017 alias xxx --目标端登录别名 alter credentialstore add user ggsxxx, password Caecaodb2017 alias xx --测试验证 dblogin useridalias xxx添加抽取进程add extract escims3, tranlog, begin now, threads 1 如果是RAC修改为2 add exttrail ./dirdat/e3, extract escims3, megabytes 50 edit params escims3 extract escims3 SETENV (TNS_ADMIN/app/oracle/product/19.3.000/db_home/network/admin) userid ggsora105, password xxxx exttrail ./dirdat/e3 discardfile ./dirrpt/escims3.dsc, append, megabytes 20 discardrollover at 05:30 on monday warnlongtrans 3h, checkinterval 10m tranlogoptions logretention enabled tranlogoptions dblogreader tranlogoptions minefromactivedg --tables table ggs.testtab;添加应用进程(有些关键字做了虚拟)dblogin useridalias xxxx add checkpointtable ggs.xxxx --非并行进程 add replicat rs3t, exttrail ./dirdat/e3, checkpointtable ggs.xxxx edit param rs3t replicat rs3t useridalias xxxx discardfile ./dirrpt/rs3t.dsc, append, megabytes 100 discardrollover at 05:30 on monday --tables gettruncates map ggs.testtab ,target maintain.testtab;数据初始化的方式有2种 数据初始化 数据泵初始化方式 SET NUMWIDTH 20; select current_scn from v$database; 12346555158664 expdp \/ as sysdba\ dumpfiletesttabt320251103.dmp logfileexptesttabt320251103.log excludestatistics ggs.testtab flashback_scn21870773 (根据同步当时获取的值填写) 目标端 10.128.103.54 导入数据 impdp \/ as sysdba\ dumpfiletesttabt320251103.dmp logfileimptesttabt320251103.log remap_schemaggs:testtab table_exists_actiontruncate 数据初始化 load init方式 add extract ext_init,sourceistable 参数配置 edit param ext_init extract ext_init SETENV (TNS_ADMIN/OSdata/oraclient/instantclient_19_28/network/admin) useridalias SCIMS8422 rmthost 10.10.1.1, mgrport 5000 rmttask replicat,group rep_init table ggs.testtab; add replicat rep_init,specialrun edit param rep_init replicat rep_init useridalias tn_ncdb10338 assumetargetdefs discardfile ./dirrpt/rep_init.dsc, append, megabytes 100 map ggs.testtab, target maintain.testtab;测试数据GGSCI (ora19 as ggswoo) 27 info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING ESCIMS3 00:00:01 00:00:02 GGSCI (ora19 as ggswoo) 28 stats escims3,daily Sending STATS request to EXTRACT ESCIMS3 ... Start of Statistics at 2025-11-05 21:34:07. Output to ./dirdat/e3: Extracting from GGS.TESTTAB to GGS.TESTTAB: *** Daily statistics since 2025-11-05 21:33:46 *** Total inserts 1.00 Total updates 0.00 Total deletes 0.00 Total upserts 0.00 Total discards 0.00 Total operations 1.00 End of Statistics. GGSCI (ora19 as ggswoo) 29 info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING ESCIMS3 00:00:00 00:00:09
阅读完成 · 觉得有帮助？
