linux网站建设模板,营销技巧第一季,成都营销推广公司,wordpress底部插件一.Checkpoints 理论说明有关GG的Checkpoints 在系列一#xff0c; GG的架构中以说明#xff1a;OracleGolden Gate 系列一 --GG 架构 说明http://blog.csdn.net/tianlesoftware/article/details/6925907这里在单独拿出来说明一下#xff0c;因为这是一个较为重要的概念。Ch… 一.Checkpoints 理论说明有关GG的Checkpoints 在系列一 GG的架构中以说明OracleGolden Gate 系列一 --GG 架构 说明http://blog.csdn.net/tianlesoftware/article/details/6925907 这里在单独拿出来说明一下因为这是一个较为重要的概念。 Checkpoints storethe current read and write positions of a process to disk for recovery purposes.These checkpoints ensure that data changes that are marked for synchronizationactually are extracted by Extract and replicated by Replicat, and they preventredundant processing. --Checkpoint 存储了进程当前读和写的位置。 Checkpoints 保证已经改变的数据已经同步从而阻止其他冗余的操作。 They providefault tolerance by preventing the loss of data should the system, the network,or an Oracle GoldenGate process need to be restarted. For complexsynchronization configurations, checkpoints enable multiple Extract or Replicatprocesses to read from the same set of trails. --通过Checkpoints 可以在以下情况下的数据丢失系统或者网络故障重启GG进程。Checkpoints支持多个Extact 或者Replicat 进程读取同一个trail 文件。 Checkpoints workwith inter-process acknowledgments to prevent messages from being lost in thenetwork. Oracle GoldenGate has a proprietary guaranteed-message delivery technology. Extract createscheckpoints for its positions in the data source and in the trail. Replicat createscheckpoints for its position in the trail. --默认情况下Extract 和 Replicat 进程都会在trail文件里记录checkpoints 的位置。 A checkpointsystem is used by Extract and Replicat processes that operate continuously, butit is not required by Extract and Replicat processes that run in batch mode. Abatch process can be re-run from its start point, whereas continuous processingrequires the support for planned or unplanned interruptions that is provided bycheckpoints. --checkpoints 机制保证了Extract 和 Replicat 进程可以连续的操作。 Replicat storesits checkpoints in a checkpoint table in the target database to couple the commitof its transaction with its position in the trail file. This ensures that atransaction will only be applied once, even if there is a failure of theReplicat process or the database process. For reporting purposes, Replicat alsohas a checkpoint file on disk in the dirchk subdirectory of the OracleGoldenGate directory. --Replicat 在Target 库的checkpoint 表里记录了已经提交了事务在trail 文件里的位置。这样就可以保证事务只被应用一次即使在replicat 进程或者DB 出现故障的情况下。 为了做报告Replicat也会在GG 安装目录的dirchk 目录里存放一个checkpoint 文件。 You canoptionally configure Replicat to use this file as its sole checkpoint store,and not use a checkpoint table at all. In this mode, however, there can becases where the checkpoint in the file is not consistent with what was appliedafter a database recovery, if the failure either rolled back or rolled forwarda transaction that was considered applied by Replicat. The checkpoint table guaranteesconsistency after recovery. --我们可以在不使用checkpoint 的情况下配置Replicat 进程使用这个本地的文件来存储checkpoint但是使用本地的checkpoint 文件, 在数据库做了recover的情况下不能保证数据的一致性。 在事务rolled back 或 rolledforward失败的情况下使用本地checkpoint 文件还是可以保证一致性。 而如果使用checkpoint table在databaserecover 的情况下也可以保证数据的一致性。 所以推荐也是使用checkpont。 Replicatmaintains checkpoints that provide a known position in the trail from which to startafter an expected or unexpected shutdown. To store a record of its checkpoints,Replicat uses a checkpoint table in the target database. This enables theReplicat checkpoint to be included within the Replicat transaction itself, toensure that a transaction will only be applied once, even if there is a failureof the Replicat process or the database process. Thecheckpoint table remains small because rows are deleted when no longer needed, andit does not affect database performance. --Checkpoint 保留了很少的记录对于哪些很长时间内不需要的的数据会自动删除所以checkpoint 不会对数据库造成性能上的影响。 GoldenGate的检查点信息有两种存放方式1. 存放在GGHOME\dirchk下的文件中。 这种是默认的方法一个进程对应一个文件。提取进程可以只使用这种模式。不需要checkpoint table。 但是这种方式在db recovery 之后可能出现数据不一致。 gg2:/u01/backup cd /u01/ggate/dirchkgg2:/u01/ggate/dirchk lsREP1.cpr REPT2.cpr 2. 存放在数据库指定的表中需要单独配置。 配置步骤如下1在./GLOBALS文件里添加checkpoint 表名 CHECKPOINTTABLE [owner.table] --指定的检查点记录表2连上DB创建checkpoint 表 GGSCI DBLOGIN [SOURCEDB dsn][,USERID db_user[, PASSWORD pw]] GGSCI ADD CHECKPOINTTABLE [owner.table] --生成这个检查点记录表3在新增复制进程时可以在添加时指定checkpointtable[owner.table] 替代nodbcheckpoint使用数据库记录检查点信息。 二.示例2.1 配置./GLOBALS 参数GGSCI (gg2) 65 view params ./GLOBALS GGSCHEMA ggateCHECKPOINTTABLE ggate.checkpoint 当我们在GLOBALS 文件里指定了默认的checkpoint 之后新的Replicat groups 在创建时会自动使用这个参数不需要其他指令。 2.2 连上数据库创建checkpoint表 GGSCI (gg2) 58 dblogin useridggategg2,password ggateSuccessfully logged into database. GGSCI (gg2) 59 add checkpointtableggate.checkpointSuccessfully created checkpoint tableGGATE.CHECKPOINT. 2.3 在创建Replicat进程时指定checkpoint 表GGSCI (gg2) 14 add replicatrep1,exttrail /u01/ggate/dirdat/lt, checkpointtable ggate.checkpointREPLICAT added. 至此Checkpoint 的配置就完成。 我们查看一下checkpoint 表。 SQL conn ggate/ggatedeConnected.SQL desc checkpoint Name Null? Type ------------------------------------------------- ---------------------------- GROUP_NAME NOT NULLVARCHAR2(8) GROUP_KEY NOT NULLNUMBER(19) SEQNO NUMBER(10) RBA NOT NULLNUMBER(19) AUDIT_TS VARCHAR2(29) CREATE_TS NOT NULL DATE LAST_UPDATE_TS NOT NULL DATE CURRENT_DIR NOT NULLVARCHAR2(255) SQL select * from checkpoint; GROUP_NA GROUP_KEY SEQNO RBA AUDIT_TS CREATE_TS LAST_UPDATE_ CURRENT_DIR-------- ---------- ---------- --------------------------------------- ------------ ------------ ----------------------REP1 3987940558 12 1564 2011-11-17 17:21:55.471376 17-NOV-11 17-NOV-11 /u01/ggate -------------------------------------------------------------------------------------------------------版权所有文章允许转载但必须以链接方式注明源地址否则追究法律责任! Blog: http://blog.csdn.net/tianlesoftwareWeibo: http://weibo.com/tianlesoftwareEmail: tianlesoftwaregmail.comSkype: tianlesoftware -------加群需要在备注说明Oracle表空间和数据文件的关系否则拒绝申请----DBA1 群62697716(满); DBA2 群62697977(满) DBA3 群62697850(满) DBA 超级群63306533(满); DBA4 群83829929(满) DBA5群 142216823(满) DBA6 群158654907(满) DBA7 群69087192(满) DBA8 群172855474DBA 超级群2151508914 DBA9群102954821 聊天 群40132017(满)转载于:https://www.cnblogs.com/zlja/archive/2011/11/17/2449537.html
