REPLICAT R_FGEDU_INT Last Started 2026-04-10 09:35:00 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File /GoldenGate/app/dirdat/ei000002
2026-04-10 10:00:00 RBA 3456789

# 步骤2：停止集成模式Replicat进程
GGSCI (fgedu.net.cn)> STOP R_FGEDU_INT

Sending STOP request to REPLICAT R_FGEDU_INT …
Request processed.

# 步骤3：创建经典模式Replicat进程
GGSCI (fgedu.net.cn)> ADD REPLICAT R_FGEDU_CLS, EXTTRAIL /GoldenGate/app/dirdat/ec, CHECKPOINTTABLE fgedu.ogg_chkpt

REPLICAT added.

# 步骤4：创建参数文件
GGSCI (fgedu.net.cn)> EDIT PARAMS R_FGEDU_CLS

REPLICAT R_FGEDU_CLS
USERIDALIAS fgedu_alias
ASSUMETARGETDEFS
MAP fgedu01.fgedu_orders, TARGET fgedu02.fgedu_orders;
MAP fgedu01.fgedu_products, TARGET fgedu02.fgedu_products;
MAP fgedu01.fgedu_customers, TARGET fgedu02.fgedu_customers;

# 步骤5：启动经典模式Replicat进程
GGSCI (fgedu.net.cn)> START R_FGEDU_CLS

Sending START request to MANAGER …
REPLICAT R_FGEDU_CLS starting

# 步骤6：验证进程状态
GGSCI (fgedu.net.cn)> INFO R_FGEDU_CLS

REPLICAT R_FGEDU_CLS Last Started 2026-04-10 10:05:00 Status RUNNING
Checkpoint Lag 00:00:02 (updated 00:00:01 ago)
Log Read Checkpoint File /GoldenGate/app/dirdat/ec000001
2026-04-10 10:05:00 RBA 4567890

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING E_FGEDU_INT 00:00:00 00:00:02
REPLICAT RUNNING R_FGEDU_INT 00:00:00 00:00:01

# 步骤2：检查数据同步延迟
GGSCI (fgedu.net.cn)> LAG E_FGEDU_INT

At EOF, no more records to process.

GGSCI (fgedu.net.cn)> LAG R_FGEDU_INT

At EOF, no more records to process.

# 步骤3：源端插入测试数据
SQL> INSERT INTO fgedu01.fgedu_orders VALUES (99999, ‘TEST’, SYSDATE, 100);

1 row created.

SQL> COMMIT;

Commit complete.

# 步骤4：目标端验证数据
SQL> SELECT * FROM fgedu02.fgedu_orders WHERE order_id = 99999;

ORDER_ID ORDER_STATUS ORDER_DATE AMOUNT
———- ———— —————– ———-
99999 TEST 10-APR-26 100

# 步骤5：检查进程统计信息
GGSCI (fgedu.net.cn)> STATS E_FGEDU_INT, TOTAL

Sending STATS request to EXTRACT E_FGEDU_INT …

Start of Statistics at 2026-04-10 10:15:00.
Output to /GoldenGate/app/dirdat/ei:

Extracting from fgedu01.fgedu_orders to fgedu01.fgedu_orders:
*** Total statistics since 2026-04-10 08:40:00 ***
Total inserts 10000.00
Total updates 5000.00
Total deletes 1000.00
Total discards 0.00
Total operations 16000.00

GGSCI (fgedu.net.cn)> STATS R_FGEDU_INT, TOTAL

Sending STATS request to REPLICAT R_FGEDU_INT …

Start of Statistics at 2026-04-10 10:15:00.
Replicating from fgedu01.fgedu_orders to fgedu02.fgedu_orders:
*** Total statistics since 2026-04-10 09:35:00 ***
Total inserts 10001.00
Total updates 5000.00
Total deletes 1000.00
Total discards 0.00
Total operations 16001.00
from GoldenGate视频:www.itpux.com

# 切换前评估
# 1. 检查当前延迟
GGSCI (fgedu.net.cn)> LAG *

At EOF, no more records to process.

# 2. 检查Trail文件积压
$ ls -lh /GoldenGate/app/dirdat/ | wc -l
125

# 3. 检查数据库资源
SQL> SELECT NAME, VALUE FROM V$SGAINFO;

NAME VALUE
——————————– ———-
Fixed SGA Size 2925488
Redo Buffers 7667712
Buffer Cache Size 4294967296
In-Memory Area Size 0
Shared Pool Size 2147483648
Large Pool Size 268435456
Java Pool Size 268435456
Streams Pool Size 536870912
Granule Size 16777216
Maximum SGA Size 8589934592

# 切换实施步骤
# 1. 创建集成模式Extract
GGSCI (fgedu.net.cn)> ADD EXTRACT E_CORE_INT, INTEGRATED TRANLOG, BEGIN NOW

EXTRACT (Integrated) added.

GGSCI (fgedu.net.cn)> REGISTER EXTRACT E_CORE_INT, DATABASE

2026-04-10 02:00:00 INFO OGG-02003 Extract E_CORE_INT successfully registered with database at SCN 987654321.

# 2. 配置并行Extract
GGSCI (fgedu.net.cn)> EDIT PARAMS E_CORE_INT

EXTRACT E_CORE_INT
USERIDALIAS fgedu_alias
EXTTRAIL /GoldenGate/app/dirdat/ci
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 1000)
TABLE fgedu_core.*;

# 3. 创建集成模式Replicat（并行）
GGSCI (fgedu.net.cn)> ADD REPLICAT R_CORE_INT, INTEGRATED COORDINATED, EXTTRAIL /GoldenGate/app/dirdat/ci, CHECKPOINTTABLE fgedu.ogg_chkpt, THREADS 4

REPLICAT (Integrated) added.

# 4. 启动新进程
GGSCI (fgedu.net.cn)> START E_CORE_INT

Sending START request to MANAGER …
EXTRACT E_CORE_INT starting

GGSCI (fgedu.net.cn)> START R_CORE_INT

Sending START request to MANAGER …
REPLICAT R_CORE_INT starting

# 5. 验证切换结果
GGSCI (fgedu.net.cn)> INFO ALL

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING E_CORE_INT 00:00:00 00:00:02
REPLICAT RUNNING R_CORE_INT 00:00:00 00:00:01

# 6. 停止旧进程
GGSCI (fgedu.net.cn)> STOP E_CORE_CLS
GGSCI (fgedu.net.cn)> STOP R_CORE_CLS

# 7. 删除旧进程
GGSCI (fgedu.net.cn)> DELETE EXTRACT E_CORE_CLS
GGSCI (fgedu.net.cn)> DELETE REPLICAT R_CORE_CLS

# 解决方案
# 检查Streams Pool配置
SQL> SHOW PARAMETER STREAMS_POOL;

NAME TYPE VALUE
———————————— ———– ——————————
streams_pool_size big integer 0

# 增加Streams Pool
SQL> ALTER SYSTEM SET STREAMS_POOL_SIZE=512M SCOPE=SPFILE;

System altered.

# 重启数据库
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 重新注册
GGSCI (fgedu.net.cn)> REGISTER EXTRACT E_FGEDU_INT, DATABASE

2026-04-10 02:30:00 INFO OGG-02003 Extract E_FGEDU_INT successfully registered with database.

# 问题2：集成模式Replicat启动失败
# 错误信息
ERROR OGG-02003 Replicat R_FGEDU_INT failed to start.

# 解决方案
# 检查检查点表
SQL> SELECT * FROM fgedu.ogg_chkpt;

no rows selected

# 创建检查点表
GGSCI (fgedu.net.cn)> ADD CHECKPOINTTABLE fgedu.ogg_chkpt

Checkpoint table created.

# 重新创建Replicat
GGSCI (fgedu.net.cn)> DELETE REPLICAT R_FGEDU_INT
GGSCI (fgedu.net.cn)> ADD REPLICAT R_FGEDU_INT, INTEGRATED, EXTTRAIL /GoldenGate/app/dirdat/ei, CHECKPOINTTABLE fgedu.ogg_chkpt

# 问题3：模式切换后延迟增大
# 分析步骤
GGSCI (fgedu.net.cn)> LAG R_FGEDU_INT

At EOF, no more records to process.

# 检查Replicat状态
GGSCI (fgedu.net.cn)> INFO R_FGEDU_INT, DETAIL

REPLICAT R_FGEDU_INT Last Started 2026-04-10 03:00:00 Status RUNNING
Checkpoint Lag 00:05:00 (updated 00:00:01 ago)

# 解决方案：增加并行线程
GGSCI (fgedu.net.cn)> STOP R_FGEDU_INT
GGSCI (fgedu.net.cn)> ALTER REPLICAT R_FGEDU_INT, THREADS 4
GGSCI (fgedu.net.cn)> START R_FGEDU_INT

echo “=== OGG模式切换前检查 ===”
echo “检查时间: $(date)”
echo “”

# 检查数据库版本
echo “1. 检查数据库版本…”
sqlplus -s / as sysdba <

Part05-风哥经验总结与分享

5.1 OGG模式切换最佳实践

根据多年生产环境实战经验，总结以下最佳实践：