BATCH模式回退分为三部分
1.运行extract获取以前的改变数据
2.运行reverse工具转换事务
3.运行replicat应用回滚数据

INSERT INTO TEST2
  SELECT LEVEL AS ID,'aaa' aa FROM DUAL CONNECT BY LEVEL < 100;

SELECT to_char(SYSDATE,'yyyymmdd hh24:mi:ss') FROM dual

20100310 17:20:29

INSERT INTO TEST2
  SELECT LEVEL AS ID,'bbb' aa FROM DUAL CONNECT BY LEVEL < 10000;

SELECT to_char(SYSDATE,'yyyymmdd hh24:mi:ss') FROM dual

20100310 17:21:00

目标是在TARGET上回退掉NAME=bbb的数据

配置extract,replicat参数文件
 [ogg@zhangqiaoc goldengate]$ cat test_extract.prm
 SPECIALRUN, TRANLOG
 BEGIN 2010-03-10 17:20:29
 END   2010-03-10 17:21:00
 USERID ogg@source10, PASSWORD oracle
 GETUPDATEBEFORES
 NOCOMPRESSDELETES
 RMTHOST 83.16.16.201, MGRPORT 7809
 EXTFILE /home/ogg/goldengate/dirdat/i1
 TABLE HR.TEST2;
 
 [ogg@zhangqiaoc goldengate]$ cat test_replicat.prm
 SPECIALRUN
 END 2010-03-10 17:21:00
 EXTFILE /home/ogg/goldengate/dirdat/o1
 USERID ogg@target10,password oracle
 ASSUMETARGETDEFS
 MAP HR.TEST2 , TARGET HR.TEST2;

[ogg@zhangqiaoc goldengate]$ extract paramfile test_extract.prm

***********************************************************************
                 Oracle GoldenGate Capture for Oracle
                      Version 10.4.0.19 Build 002
   Linux, x86, 32bit (optimized), Oracle 10 on Sep 18 2009 00:01:59
 
Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.

                    Starting at 2010-03-10 17:50:28
***********************************************************************

Operating System Version:
Linux
Version #1 Mon Sep 19 18:20:28 EDT 2005, Release 2.6.9-22.EL
Node: zhangqiaoc
Machine: i686
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 3872

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
SPECIALRUN, TRANLOG
BEGIN 2010-03-10 17:20:29
END   2010-03-10 17:21:00
USERID ogg@source10, PASSWORD ******
GETUPDATEBEFORES
NOCOMPRESSDELETES
RMTHOST 83.16.16.201, MGRPORT 7809
--RMTFILE /home/ogg/goldengate/dirdat/r1, MAXFILES 10
EXTFILE /home/ogg/goldengate/dirdat/i1
TABLE HR.TEST2;

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                                2G
CACHEBUFFERSIZE (soft max):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (min):        2.92G
CACHESIZEMAX (strict force to disk):   2.68G

Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"

2010-03-10 17:50:29  GGS INFO        112  No recovery is required for target file /home/ogg/goldengate/dirdat/i1, at RBA 0 (file not opened).

2010-03-10 17:50:29  GGS INFO     Z0-05M  Output file /home/ogg/goldengate/dirdat/i1 is using format RELEASE 10.4.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

TABLE resolved (entry HR.TEST2):
  TABLE HR.TEST2;

Using the following key columns for source table HR.TEST2: ID, NAME.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

Report at 2010-03-10 17:50:29 (activity since 2010-03-10 17:50:29)

Output to /home/ogg/goldengate/dirdat/i1:

From Table HR.TEST2:
       #                   inserts:      9999
       #                   updates:         0
       #                   deletes:         0
       #                  discards:         0

[ogg@zhangqiaoc goldengate]$ reverse /home/ogg/goldengate/dirdat/i1 /home/ogg/goldengate/dirdat/o1

Oracle GoldenGate Dynamic Rollback
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized) on Sep 17 2009 23:55:16

Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.

Reversed /home/ogg/goldengate/dirdat/i1 to /home/ogg/goldengate/dirdat/o1
Total Data Bytes            228870
  Avg Bytes/Record              22
Insert                        9999
After Images                  9999

[ogg@zhangqiaoc goldengate]$ replicat paramfile test_replicat.prm

***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
                      Version 10.4.0.19 Build 002
   Linux, x86, 32bit (optimized), Oracle 10 on Sep 18 2009 00:08:30
 
Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.

                    Starting at 2010-03-10 17:52:17
***********************************************************************

Operating System Version:
Linux
Version #1 Mon Sep 19 18:20:28 EDT 2005, Release 2.6.9-22.EL
Node: zhangqiaoc
Machine: i686
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 3923

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
SPECIALRUN
END 2010-03-10 17:21:00
EXTFILE /home/ogg/goldengate/dirdat/o1
USERID ogg@target10,password ******
ASSUMETARGETDEFS
MAP HR.TEST2 , TARGET HR.TEST2;

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                              512M
CACHEBUFFERSIZE (soft max):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (min):           1G
CACHESIZEMAX (strict force to disk):    881M

Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"

For further information on character set settings, please refer to user manual.
Opened trail file /home/ogg/goldengate/dirdat/o1 at 2010-03-10 17:52:18

2010-03-10 17:52:18  GGS INFO        379  Positioning with begin time: Jan 1, 1970 12:00:00 AM, starting record time: Mar 10, 2010 5:20:54 PM at extrba 896.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

Opened trail file /home/ogg/goldengate/dirdat/o1 at 2010-03-10 17:52:18

MAP resolved (entry HR.TEST2):
  MAP HR.TEST2, TARGET HR.TEST2;

2010-03-10 17:52:18  GGS WARNING     109  No unique key is defined for table TEST2. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  ID, NAME

Using the following key columns for target table HR.TEST2: ID, NAME.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name :  /home/ogg/goldengate/dirdat/o1
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     B  (x42)
RecLength  :    20 (x0014)    IO Time    : 2010-03-10 17:20:54.000000 
IOType     :     3  (x03)     OrigNode   :   255  (xff)
TransInd   :     .  (x02)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :        198       AuditPos   : 20405692
Continued  :     N  (x00)     RecCount   :     1  (x01)

2010-03-10 17:20:54.000000 Delete             Len    20 RBA 1099572
Name: HR.TEST2
___________________________________________________________________

Reading /home/ogg/goldengate/dirdat/o1, current RBA 1099702, 9999 records

Report at 2010-03-10 17:52:31 (activity since 2010-03-10 17:52:18)

From Table HR.TEST2 to HR.TEST2:
       #                   inserts:         0
       #                   updates:         0
       #                   deletes:      9999
       #                  discards:         0

Last log location read:
     FILE:      /home/ogg/goldengate/dirdat/o1
     RBA:       1099702
     TIMESTAMP: 2010-03-10 17:20:54.000000
     EOF:       NO
     READERR:   400

修改replicat参数文件，指向生产库，可以回退生产库的修改
需要的原extract文件中增加：TRANLOGOPTIONS EXCLUDEUSER OGG；过滤掉复制用户产生的数据