在dg库上搭建ogg
备注： Oracle DG (主->备库1->备库2） 级联方式
主库： 10.118.242.216 sid_name=sfpay2备库1： 10.118.242.215 sid_name=sfpay2 => ogg 主库ogg库1： 10.118.230.27 sid_name=sfpay3 => ogg备库1ogg库2： 10.118.242.214 sid_name=sfpay1 => ogg备库2
ogg 方式： 一个捕获进程，多个pump 进程（一对多方式）
ogg 一库多实例时，请配置好 setenv 参数（oracle_sid,nls_lang, oracle_home), 记住 tnsname.ora 对应好. 注意ogg source 端，target 端 时区。
ogg extract 端 不需要 做checkpoint ，以及备库只能做 DML ogg 同步，DDL 不支持。
-----日志： ---------------------------------------------------------------------------DatabaseLanguageandCharacterSet:NLS_LANG="AMERICAN_AMERICA.AL32UTF8"NLS_LANGUAGE="AMERICAN"NLS_TERRITORY="AMERICA"NLS_CHARACTERSET="AL32UTF8"
SourceContext:SourceModule:[er.redo.ora]SourceID:[/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]SourceFunction:[REDO_validate_config]SourceLine:[5980]ThreadBacktrace:[12]elements:[/data/gg11.2/libgglog.so(CMessageContext::AddThreadContext()+0x1e)[0x7f9bedb5ad2e]]:[/data/gg11.2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*,unsignedint,...)+0x2ec)[0x7f9bedb5388c]]:[/data/gg11.2/libgglog.so(_MSG_ERR_DDL_STANDBY_NOT_SUPPORTED(CSourceContext*,CMessageFactory::MessageDisposition)+0x2c)[0x7f9bedb43e16]]:[/data/gg11.2/extract(REDO_validate_config(int,unsignedint*,int*)+0xdc9)[0x6a4ab9]]:[/data/gg11.2/extract(redo_log_setup()+0x34)[0x57abf4]]:[/data/gg11.2/extract(extract_main(int,char**)+0x3bf)[0x57e0ef]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f)[0x63309f]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104)[0x6332f4]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::MainThread::Run(int,char**)+0x8b)[0x6333fb]]:[/data/gg11.2/extract(main+0x2c)[0x57dc5c]]:[/lib64/libc.so.6(__libc_start_main+0xfd)[0x383e61ed5d]]:[/data/gg11.2/extract(__gxx_personality_v0+0x3b2)[0x4f64aa]]
2015-11-2511:33:05ERROROGG-00520DDLreplicationisnotsupportedforstandbydatabases.
2015-11-2511:33:05ERROROGG-01668PROCESSABENDING.---------------------------------------------------------------------------------------------
测试结果： source 端（DG备库1） 的所有数据初始话，都以 DG主库 为准（scn, 数据的导出） source 端（DG备库1） 的ogg 操作，都需要在 DG 主库上执行ogg脚本，trandata log. 参数可以忽略。
1： 主库 执行ogg 脚本2： 因standby database 不支持 ogg 的DDL 方式，注销掉所有ddl 方式。3： ogg source端，dg 备库1 在info trandata schema.* 时，可能为disabled 状态，但是DG主库enable 即可。 GGSCI(sfpay.datatest.mysql02)40>infotrandatadm_ord.*
LoggingofsupplementalredologdataisdisabledfortableDM_ORD.TEMP_20151105_T.
4： source 端参数：
GGSCI(sfpay.datatest.mysql02)46>dbloginuseridogg@ogg Password:Successfullyloggedintodatabase.
GGSCI(sfpay.datatest.mysql02)49>viewparamsmgr
port7809dynamicportlist7810-7900useridogg@ogg,passwordoggautorestartextract*,waitminutes2,retries7lagreporthours1laginfominutes30lagcriticalminutes45purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays5purgeddlhistoryminkeepdays3,maxkeepdays5,frequencyminutes20PURGEMARKERHISTORYMINKEEPDAYS3,MAXKEEPDAYS5,FREQUENCYMINUTES20
GGSCI(sfpay.datatest.mysql02)50>viewparamsexp001
extractexp001setenv(ORACLE_HOME="/u01/app/oracle/product/11.2.0.4/dbhome_1")setenv(NLS_LANG="AMERICAN_AMERICA.AL32UTF8")dynamicresolutiongettruncatesnumfiles5000useridogg@ogg,passwordoggtranlogoptionsconvertucs2clobsTRANLOGOPTIONSLOGRETENTIONDISABLEDTRANLOGOPTIONSDBLOGREADERtranlogoptionsaltarchivelogdestprimaryinstancesfpay2/data/archivelog--TRANLOGOPTIONSASMUSERsys@ASM,ASMPASSWORDoracle123--THREADOPTIONSMAXCOMMITPROPAGATIONDELAY20000reportcountevery2minutes,ratediscardfile./dirrpt/exp001.dsc,append,megabytes1000warnlongtrans2h,checkinterval3mexttrail./dirdat/p1--ddlincludeall--ddloptionsaddtrandata,report--addtesttabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)51>viewparamspump214
extractpump214passthrureportat02:00reportrolloverat02:10rmthost10.118.242.214,mgrport7809rmttrail./dirdat/t1dynamicresolutionnumfiles2000--addtablestabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)52>viewparamspump01
extractpump01setenv(ORACLE_SID="sfpay3")passthrureportat02:00reportrolloverat02:10rmthost10.118.230.27,mgrport7809rmttrail./dirdat/e1dynamicresolutionnumfiles2000--addtablestabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)53>infoall
ProgramStatusGroupLagatChkptTimeSinceChkpt
MANAGERRUNNINGEXTRACTRUNNINGEXP00100:00:00unknownEXTRACTRUNNINGPUMP0100:00:0000:00:09EXTRACTRUNNINGPUMP21400:00:0000:00:09
source端 添加捕获extract 进程组： GGSCI > add extract exp001, tranlog ,begin now --(, threads 2) --添加进程组 GGSCI > add exttrail ./dirdat/p1, extract exp001, megabytes 500 --添加本地exttrial 文件。
source 端 添加pump 进程组以及 target exttrail 文件：
--在启动之前，配置好target 端参数，及启动mgr 进程--
GGSCI >add extract pump214, exttrailsource./dirdat/p1,begin now --添加pump 进程组 GGSCI >add rmttrail./dirdat/t1,extract pump214,megabytes 500 --添加远程trail 文件
GGSCI >add extract pump01, exttrailsource./dirdat/p1,begin now --添加pump 进程组 GGSCI >add rmttrail./dirdat/e1,extract pump01,megabytes 500 --添加远程trail 文件
5 ，target 端 rep214:
GGSCI(sfpay-asmtest)18>viewparams./GLOBALS
GGSCHEMAOGGCHECKPOINTTABLEOGG.CHECKPOINT
GGSCI(sfpay-asmtest)19>viewparamsmgr
port7809dynamicportlist7810-7900useridogg@ogg,passwordoggautorestartextract*,waitminutes2,retries7lagreporthours1laginfominutes30lagcriticalminutes45purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays5purgeddlhistoryminkeepdays3,maxkeepdays5,frequencyminutes20PURGEMARKERHISTORYMINKEEPDAYS3,MAXKEEPDAYS5,FREQUENCYMINUTES20
GGSCI(sfpay-asmtest)20>viewparamsrep214
REPLICATrep214SETENV(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)USERIDogg@ogg,PASSWORDoggDISCARDFILE./dirrpt/rep214.dsc,PURGE,MAXBYTES104857600sqlexec"Altersessionsetconstraints=deferred"REPORTAT01:59reportrolloverat02:00--handlecollisionsreperrordefault,abendREPORTCOUNTEVERY30MINUTES,RATEDDLINCLUDEMAPPED,EXCLUDEINSTR'SHRINKSPACE'ddloptionsreportassumetargetdefschecksequencevalueallownoopupdatesdynamicresolutionnumfiles2000--ERRORIGNOREDDLERROR10636IGNORE--20151028addMAPdm_sypay.*,TARGETdm_sypay.*;MAPdm_ord.*,TARGETdm_ord.*;pump01 同样，略过。
6， 数据初始化 expdp 通过flshback_scn , DG主库。
7， target 端启动： GGSC > add replicat rep214, exttrail ./dirdat/e1, begin now GGSCI > start replicat ,aftercsn 6553589
8 ,测试：
9， 完成。
主库： 10.118.242.216 sid_name=sfpay2备库1： 10.118.242.215 sid_name=sfpay2 => ogg 主库ogg库1： 10.118.230.27 sid_name=sfpay3 => ogg备库1ogg库2： 10.118.242.214 sid_name=sfpay1 => ogg备库2
ogg 方式： 一个捕获进程，多个pump 进程（一对多方式）
ogg 一库多实例时，请配置好 setenv 参数（oracle_sid,nls_lang, oracle_home), 记住 tnsname.ora 对应好. 注意ogg source 端，target 端 时区。
ogg extract 端 不需要 做checkpoint ，以及备库只能做 DML ogg 同步，DDL 不支持。
-----日志： ---------------------------------------------------------------------------DatabaseLanguageandCharacterSet:NLS_LANG="AMERICAN_AMERICA.AL32UTF8"NLS_LANGUAGE="AMERICAN"NLS_TERRITORY="AMERICA"NLS_CHARACTERSET="AL32UTF8"
SourceContext:SourceModule:[er.redo.ora]SourceID:[/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]SourceFunction:[REDO_validate_config]SourceLine:[5980]ThreadBacktrace:[12]elements:[/data/gg11.2/libgglog.so(CMessageContext::AddThreadContext()+0x1e)[0x7f9bedb5ad2e]]:[/data/gg11.2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*,unsignedint,...)+0x2ec)[0x7f9bedb5388c]]:[/data/gg11.2/libgglog.so(_MSG_ERR_DDL_STANDBY_NOT_SUPPORTED(CSourceContext*,CMessageFactory::MessageDisposition)+0x2c)[0x7f9bedb43e16]]:[/data/gg11.2/extract(REDO_validate_config(int,unsignedint*,int*)+0xdc9)[0x6a4ab9]]:[/data/gg11.2/extract(redo_log_setup()+0x34)[0x57abf4]]:[/data/gg11.2/extract(extract_main(int,char**)+0x3bf)[0x57e0ef]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f)[0x63309f]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104)[0x6332f4]]:[/data/gg11.2/extract(ggs::gglib::MultiThreading::MainThread::Run(int,char**)+0x8b)[0x6333fb]]:[/data/gg11.2/extract(main+0x2c)[0x57dc5c]]:[/lib64/libc.so.6(__libc_start_main+0xfd)[0x383e61ed5d]]:[/data/gg11.2/extract(__gxx_personality_v0+0x3b2)[0x4f64aa]]
2015-11-2511:33:05ERROROGG-00520DDLreplicationisnotsupportedforstandbydatabases.
2015-11-2511:33:05ERROROGG-01668PROCESSABENDING.---------------------------------------------------------------------------------------------
测试结果： source 端（DG备库1） 的所有数据初始话，都以 DG主库 为准（scn, 数据的导出） source 端（DG备库1） 的ogg 操作，都需要在 DG 主库上执行ogg脚本，trandata log. 参数可以忽略。
1： 主库 执行ogg 脚本2： 因standby database 不支持 ogg 的DDL 方式，注销掉所有ddl 方式。3： ogg source端，dg 备库1 在info trandata schema.* 时，可能为disabled 状态，但是DG主库enable 即可。 GGSCI(sfpay.datatest.mysql02)40>infotrandatadm_ord.*
LoggingofsupplementalredologdataisdisabledfortableDM_ORD.TEMP_20151105_T.
4： source 端参数：
GGSCI(sfpay.datatest.mysql02)46>dbloginuseridogg@ogg Password:Successfullyloggedintodatabase.
GGSCI(sfpay.datatest.mysql02)49>viewparamsmgr
port7809dynamicportlist7810-7900useridogg@ogg,passwordoggautorestartextract*,waitminutes2,retries7lagreporthours1laginfominutes30lagcriticalminutes45purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays5purgeddlhistoryminkeepdays3,maxkeepdays5,frequencyminutes20PURGEMARKERHISTORYMINKEEPDAYS3,MAXKEEPDAYS5,FREQUENCYMINUTES20
GGSCI(sfpay.datatest.mysql02)50>viewparamsexp001
extractexp001setenv(ORACLE_HOME="/u01/app/oracle/product/11.2.0.4/dbhome_1")setenv(NLS_LANG="AMERICAN_AMERICA.AL32UTF8")dynamicresolutiongettruncatesnumfiles5000useridogg@ogg,passwordoggtranlogoptionsconvertucs2clobsTRANLOGOPTIONSLOGRETENTIONDISABLEDTRANLOGOPTIONSDBLOGREADERtranlogoptionsaltarchivelogdestprimaryinstancesfpay2/data/archivelog--TRANLOGOPTIONSASMUSERsys@ASM,ASMPASSWORDoracle123--THREADOPTIONSMAXCOMMITPROPAGATIONDELAY20000reportcountevery2minutes,ratediscardfile./dirrpt/exp001.dsc,append,megabytes1000warnlongtrans2h,checkinterval3mexttrail./dirdat/p1--ddlincludeall--ddloptionsaddtrandata,report--addtesttabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)51>viewparamspump214
extractpump214passthrureportat02:00reportrolloverat02:10rmthost10.118.242.214,mgrport7809rmttrail./dirdat/t1dynamicresolutionnumfiles2000--addtablestabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)52>viewparamspump01
extractpump01setenv(ORACLE_SID="sfpay3")passthrureportat02:00reportrolloverat02:10rmthost10.118.230.27,mgrport7809rmttrail./dirdat/e1dynamicresolutionnumfiles2000--addtablestabledm_sypay.*;tabledm_ord.*;
GGSCI(sfpay.datatest.mysql02)53>infoall
ProgramStatusGroupLagatChkptTimeSinceChkpt
MANAGERRUNNINGEXTRACTRUNNINGEXP00100:00:00unknownEXTRACTRUNNINGPUMP0100:00:0000:00:09EXTRACTRUNNINGPUMP21400:00:0000:00:09
source端 添加捕获extract 进程组： GGSCI > add extract exp001, tranlog ,begin now --(, threads 2) --添加进程组 GGSCI > add exttrail ./dirdat/p1, extract exp001, megabytes 500 --添加本地exttrial 文件。
source 端 添加pump 进程组以及 target exttrail 文件：
--在启动之前，配置好target 端参数，及启动mgr 进程--
GGSCI >add extract pump214, exttrailsource./dirdat/p1,begin now --添加pump 进程组 GGSCI >add rmttrail./dirdat/t1,extract pump214,megabytes 500 --添加远程trail 文件
GGSCI >add extract pump01, exttrailsource./dirdat/p1,begin now --添加pump 进程组 GGSCI >add rmttrail./dirdat/e1,extract pump01,megabytes 500 --添加远程trail 文件
5 ，target 端 rep214:
GGSCI(sfpay-asmtest)18>viewparams./GLOBALS
GGSCHEMAOGGCHECKPOINTTABLEOGG.CHECKPOINT
GGSCI(sfpay-asmtest)19>viewparamsmgr
port7809dynamicportlist7810-7900useridogg@ogg,passwordoggautorestartextract*,waitminutes2,retries7lagreporthours1laginfominutes30lagcriticalminutes45purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays5purgeddlhistoryminkeepdays3,maxkeepdays5,frequencyminutes20PURGEMARKERHISTORYMINKEEPDAYS3,MAXKEEPDAYS5,FREQUENCYMINUTES20
GGSCI(sfpay-asmtest)20>viewparamsrep214
REPLICATrep214SETENV(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)USERIDogg@ogg,PASSWORDoggDISCARDFILE./dirrpt/rep214.dsc,PURGE,MAXBYTES104857600sqlexec"Altersessionsetconstraints=deferred"REPORTAT01:59reportrolloverat02:00--handlecollisionsreperrordefault,abendREPORTCOUNTEVERY30MINUTES,RATEDDLINCLUDEMAPPED,EXCLUDEINSTR'SHRINKSPACE'ddloptionsreportassumetargetdefschecksequencevalueallownoopupdatesdynamicresolutionnumfiles2000--ERRORIGNOREDDLERROR10636IGNORE--20151028addMAPdm_sypay.*,TARGETdm_sypay.*;MAPdm_ord.*,TARGETdm_ord.*;pump01 同样，略过。
6， 数据初始化 expdp 通过flshback_scn , DG主库。
7， target 端启动： GGSC > add replicat rep214, exttrail ./dirdat/e1, begin now GGSCI > start replicat ,aftercsn 6553589
8 ,测试：
9， 完成。
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
