南通网站排名方法,建网站 网站内容怎么做,怎么看kk园区视频,wordpress首页默认中文ogg一般来说有4个进程#xff0c;Manager进程#xff0c;Extract进程#xff0c;Pump进程#xff0c;Replicat进程Manager进程#xff1a;是GoldenGate的控制进程#xff0c;它主要作用有以下几个方面#xff1a;启动、监控、重启GoldenGate的其他进程#xff0c;报告错…ogg一般来说有4个进程Manager进程Extract进程Pump进程Replicat进程Manager进程是GoldenGate的控制进程它主要作用有以下几个方面启动、监控、重启GoldenGate的其他进程报告错误及时间分配数据存储空间发布阀值报告等。Extract进程运行在数据库源端负责从源端数据表或日志中捕获数据。Extract进程利用其内在的checkpoint机制周期性地检查 并记录其读写的位置通常是写入到本地的trail文件。这种机制是为了保证如果Extract进程终止或者操作系统宕机我们重启Extract进程 后GoldenGate能够恢复到以前的状态从上一个断点处继续往下运行而不会有任何数据损失。Pump进程(如果trail文件落本地才会用这个进程一般OGG都会把traile文件落地)运行在数据库源端其作用非常简单。如果源端使用了本地trail文件那么Pump进程就会把Trail文件以数据块的形式通过 TCP/IP协议发送到目标端我们下面的配置都是这种方式。Pump进程本质是Extract进程的一种特殊形式如果不使用Trail文件那么 Extract进程在抽取完数据后直接投递到目标端。与Pump进程相对应的叫Server Collector进程这个进程不需要引起我们关注因为在实际操作过程中无需对其进行任何配置它运行在目标端任务就是把Extract/Pump进程投递过来的数据块重新组装成Trail文件。Replicat进程运行在目标端是数据投递的最后一站负责读取目标端Trail文件中的内容并将解析其解析为DML或DDL语句然后应用到目标数据库中。测试环境源端IP172.16.0.30 SID:prod目标;IP: 172.16.0.40 SID:prod(实例名可以不一致)1、安装ogg软件安装方式如下(两端均执行)oracle用户下创建ogg目录mkdir /home/oracle/ogg[oraclelocalhost ~]$ cd ogg/[oraclelocalhost ogg]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip[oraclelocalhost ogg]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar设置LD_LIBRARY_PATH参数export LD_LIBRARY_PATH$ORACLE_HOME/lib查看运行./ggsci命令行接口所缺是的库文件可能会出现libnnz11.solibclntsh.so.11.1缺失只需要将libnnz10.solibclntsh.so.10.1软解析到缺失的文件即可[oraclelocalhost ogg]$ ldd ./ggsci2、数据库环境准备(两端均执行)打开最小附加日志SQLalter database add supplemental log data;SQLselect supplemental_log_data_min from v$database;创建数据库ogg用户SQLCREATE USER ogg IDENTIFIED BY ogg DEFAULT TABLESPACE USERS ;授权ogg用户如果对用户权限要求不严格可以直接授予dba权限否则授予如下权限源端GRANT CONNECT TO goldengate;GRANT CREATE SESSION TO goldengate;GRANT ALTER SESSION TO goldengate;GRANT RESOURCE TO goldengate;GRANT SELECT ANY DICTIONARY TO goldengate;GRANT SELECT ANY TABLE TO goldengate;GRANT FLASHBACK ANY TABLE TO goldengate;GRANT ALTER ANY TABLE TO goldengate;目标端GRANT ALTER SESSION TO goldengate;GRANT CREATE SESSION TO goldengate;GRANT CONNECT TO goldengate;GRANT RESOURCE TO goldengate;GRANT SELECT ANY DICTIONARY TO goldengate;GRANT SELECT ANY TABLE TO goldengate;GRANT FLASHBACK ANY TABLE TO goldengate;GRANT INSERT ANY TABLE TO goldengate;GRANT UPDATE ANY TABLE TO goldengate;GRANT DELETE ANY TABLE TO goldengate;3、主备库创建mgr管理进程添加端口7809(两端均执行)创建ogg子目录[oraclelocalhost ogg]$ ./ggsciGGSCIcreate subdirsGGSCI (localhost.localdomain) 10 edit params mgrport 7809GGSCI (localhost.localdomain) 11 start mgrGGSCI (localhost.localdomain) 11 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGmgr可以添加如下参数DYNAMICPORTLIST 7820-7830, 7833, 7835autostart er *autorestart er *, retries 5, waitminutes 3 (自动启动所有参数会尝试5次每次等待3分钟)purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 7(自动清理过期的trail文件会保留7天)4、添加表级附加日志ggscidblogin userid ogg, password oggggsciadd trandata hzq.*5、添加抽取进程 (源端)GGSCI add ext exta, tranlog, begin nowexta为进程名一般为ext开头表示是extract进程后面可以加1-2位字符标识begin可以是now也可以是指定的时间为exta进程配置本地队列本地的trail文件以la开头GGSCI add exttrail ./dirdat/lc, ext exta, MEGABYTES 20添加投递进程pmpa将本地的./dirdat/la文件传送到目标端GGSCI add extract pmpa, EXTTRAILSOURCE ./dirdat/lc为pmpa进程配置远程队列队列的位置是源端的主机目录,传送到目标断后命名以rc开头。GGSCI add rmttrail ./dirdat/rc, ext dpea, MEGABYTES 20GGSCI (localhost.localdomain) 23 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EXTA 00:00:00 00:00:02EXTRACT STOPPED PMPA 00:00:00 00:00:016、配置进程参数(源端)GGSCI (localhost.localdomain) 25 edit params extaEXTRACT extasetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )setenv (ORACLE_SID prod)USERID ogg, PASSWORD oggEXTTRAIL ./dirdat/lcdynamicresolution--GETUPDATEBEFORES--DDL INCLUDE ALL (DDL复制参数)--DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT (ddl复制参数)--NOCOMPRESSDELETEStable hzq.*;GGSCI (localhost.localdomain) 28 edit params pmpaextract pmpasetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )passthru--REPORT AT 01:59--reportrollover at 02:00rmthost 172.16.0.40, mgrport 7809, compressrmttrail ./dirdat/rcdynamicresolutiontable hzq.*;启动进程GGSCIstart ext *GGSCI (localhost.localdomain) 29 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXTA 00:00:00 00:00:04EXTRACT RUNNING PMPA 00:00:00 00:00:057、配置目标端进程和参数(目标端)GGSCI add rep rep1a, exttrail ./dirdat/rc, nodbcheckpointGGSCIedit param rep1areplicat rep1asetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )setenv (ORACLE_SID prod)userid ogg, password oggreperror default,abenddiscardfile ./dirrpt/rep1a.dsc,append, megabytes 10assumetargetdefs--allownoopupdatesdynamicresolution--DDL include all--ddloptions report--DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5ASSUMETARGETDEFS--INSERTALLRECORDSmap hzq.*, target hzq.*;启动参数GGSCI (localhost.localdomain) 12 start rep1aGGSCI (localhost.localdomain) 11 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING REP1A 00:00:00 00:00:06ogg一般来说有4个进程Manager进程Extract进程Pump进程Replicat进程Manager进程是GoldenGate的控制进程它主要作用有以下几个方面启动、监控、重启GoldenGate的其他进程报告错误及时间分配数据存储空间发布阀值报告等。Extract进程运行在数据库源端负责从源端数据表或日志中捕获数据。Extract进程利用其内在的checkpoint机制周期性地检查 并记录其读写的位置通常是写入到本地的trail文件。这种机制是为了保证如果Extract进程终止或者操作系统宕机我们重启Extract进程 后GoldenGate能够恢复到以前的状态从上一个断点处继续往下运行而不会有任何数据损失。Pump进程(如果trail文件落本地才会用这个进程一般OGG都会把traile文件落地)运行在数据库源端其作用非常简单。如果源端使用了本地trail文件那么Pump进程就会把Trail文件以数据块的形式通过 TCP/IP协议发送到目标端我们下面的配置都是这种方式。Pump进程本质是Extract进程的一种特殊形式如果不使用Trail文件那么 Extract进程在抽取完数据后直接投递到目标端。与Pump进程相对应的叫Server Collector进程这个进程不需要引起我们关注因为在实际操作过程中无需对其进行任何配置它运行在目标端任务就是把Extract/Pump进程投递过来的数据块重新组装成Trail文件。Replicat进程运行在目标端是数据投递的最后一站负责读取目标端Trail文件中的内容并将解析其解析为DML或DDL语句然后应用到目标数据库中。测试环境源端IP172.16.0.30 SID:prod目标;IP: 172.16.0.40 SID:prod(实例名可以不一致)1、安装ogg软件安装方式如下(两端均执行)oracle用户下创建ogg目录mkdir /home/oracle/ogg[oraclelocalhost ~]$ cd ogg/[oraclelocalhost ogg]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip[oraclelocalhost ogg]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar设置LD_LIBRARY_PATH参数export LD_LIBRARY_PATH$ORACLE_HOME/lib查看运行./ggsci命令行接口所缺是的库文件可能会出现libnnz11.solibclntsh.so.11.1缺失只需要将libnnz10.solibclntsh.so.10.1软解析到缺失的文件即可[oraclelocalhost ogg]$ ldd ./ggsci2、数据库环境准备(两端均执行)打开最小附加日志SQLalter database add supplemental log data;SQLselect supplemental_log_data_min from v$database;创建数据库ogg用户SQLCREATE USER ogg IDENTIFIED BY ogg DEFAULT TABLESPACE USERS ;授权ogg用户如果对用户权限要求不严格可以直接授予dba权限否则授予如下权限源端GRANT CONNECT TO goldengate;GRANT CREATE SESSION TO goldengate;GRANT ALTER SESSION TO goldengate;GRANT RESOURCE TO goldengate;GRANT SELECT ANY DICTIONARY TO goldengate;GRANT SELECT ANY TABLE TO goldengate;GRANT FLASHBACK ANY TABLE TO goldengate;GRANT ALTER ANY TABLE TO goldengate;目标端GRANT ALTER SESSION TO goldengate;GRANT CREATE SESSION TO goldengate;GRANT CONNECT TO goldengate;GRANT RESOURCE TO goldengate;GRANT SELECT ANY DICTIONARY TO goldengate;GRANT SELECT ANY TABLE TO goldengate;GRANT FLASHBACK ANY TABLE TO goldengate;GRANT INSERT ANY TABLE TO goldengate;GRANT UPDATE ANY TABLE TO goldengate;GRANT DELETE ANY TABLE TO goldengate;3、主备库创建mgr管理进程添加端口7809(两端均执行)创建ogg子目录[oraclelocalhost ogg]$ ./ggsciGGSCIcreate subdirsGGSCI (localhost.localdomain) 10 edit params mgrport 7809GGSCI (localhost.localdomain) 11 start mgrGGSCI (localhost.localdomain) 11 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGmgr可以添加如下参数DYNAMICPORTLIST 7820-7830, 7833, 7835autostart er *autorestart er *, retries 5, waitminutes 3 (自动启动所有参数会尝试5次每次等待3分钟)purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 7(自动清理过期的trail文件会保留7天)4、添加表级附加日志ggscidblogin userid ogg, password oggggsciadd trandata hzq.*5、添加抽取进程 (源端)GGSCI add ext exta, tranlog, begin nowexta为进程名一般为ext开头表示是extract进程后面可以加1-2位字符标识begin可以是now也可以是指定的时间为exta进程配置本地队列本地的trail文件以la开头GGSCI add exttrail ./dirdat/lc, ext exta, MEGABYTES 20添加投递进程pmpa将本地的./dirdat/la文件传送到目标端GGSCI add extract pmpa, EXTTRAILSOURCE ./dirdat/lc为pmpa进程配置远程队列队列的位置是源端的主机目录,传送到目标断后命名以rc开头。GGSCI add rmttrail ./dirdat/rc, ext dpea, MEGABYTES 20GGSCI (localhost.localdomain) 23 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EXTA 00:00:00 00:00:02EXTRACT STOPPED PMPA 00:00:00 00:00:016、配置进程参数(源端)GGSCI (localhost.localdomain) 25 edit params extaEXTRACT extasetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )setenv (ORACLE_SID prod)USERID ogg, PASSWORD oggEXTTRAIL ./dirdat/lcdynamicresolution--GETUPDATEBEFORES--DDL INCLUDE ALL (DDL复制参数)--DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT (ddl复制参数)--NOCOMPRESSDELETEStable hzq.*;GGSCI (localhost.localdomain) 28 edit params pmpaextract pmpasetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )passthru--REPORT AT 01:59--reportrollover at 02:00rmthost 172.16.0.40, mgrport 7809, compressrmttrail ./dirdat/rcdynamicresolutiontable hzq.*;启动进程GGSCIstart ext *GGSCI (localhost.localdomain) 29 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXTA 00:00:00 00:00:04EXTRACT RUNNING PMPA 00:00:00 00:00:057、配置目标端进程和参数(目标端)GGSCI add rep rep1a, exttrail ./dirdat/rc, nodbcheckpointGGSCIedit param rep1areplicat rep1asetenv ( NLS_LANG AMERICAN_AMERICA.ZHS16GBK )setenv (ORACLE_SID prod)userid ogg, password oggreperror default,abenddiscardfile ./dirrpt/rep1a.dsc,append, megabytes 10assumetargetdefs--allownoopupdatesdynamicresolution--DDL include all--ddloptions report--DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5ASSUMETARGETDEFS--INSERTALLRECORDSmap hzq.*, target hzq.*;启动参数GGSCI (localhost.localdomain) 12 start rep1aGGSCI (localhost.localdomain) 11 info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING REP1A 00:00:00 00:00:06
