# 1. 检查源表数据量
SQL> SELECT table_name, num_rows, ROUND(blocks*8/1024,2) AS size_mb
FROM dba_tables
WHERE owner = ‘FGEDU’
AND table_name IN (‘FGEDU_ORDERS’, ‘FGEDU_CUSTOMERS’)
ORDER BY size_mb DESC;

TABLE_NAME NUM_ROWS SIZE_MB
—————————— ———- ———-
FGEDU_ORDERS 10000000 2048.5
FGEDU_CUSTOMERS 5000000 1024.3

# 2. 添加补充日志
GGSCI (fgedu.net.cn) 1> dblogin useridalias fgedu_ggadmin
Successfully logged into database.

GGSCI (fgedu.net.cn) 2> add trandata fgedu.fgedu_orders
Logging of supplemental redo data enabled for table FGEDU.FGEDU_ORDERS.

GGSCI (fgedu.net.cn) 3> add trandata fgedu.fgedu_customers
Logging of supplemental redo data enabled for table FGEDU.FGEDU_CUSTOMERS.

# 3. 获取当前SCN
SQL> SELECT current_scn FROM v$database;

CURRENT_SCN
———–
12345678

# 4. 记录加载开始SCN
# SCN: 12345678

# 1. 创建目标表结构
SQL> CREATE TABLE fgedu.fgedu_orders (
order_id NUMBER(10) PRIMARY KEY,
customer_id NUMBER(10),
order_date DATE,
order_amount NUMBER(10,2),
order_status VARCHAR2(20),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Table created.

SQL> CREATE TABLE fgedu.fgedu_customers (
customer_id NUMBER(10) PRIMARY KEY,
customer_name VARCHAR2(100),
email VARCHAR2(100),
phone VARCHAR2(20),
address VARCHAR2(200),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Table created.

# 2. 禁用约束和索引（提高加载性能）
SQL> ALTER TABLE fgedu.fgedu_orders DISABLE CONSTRAINT SYS_C0012345;
SQL> ALTER INDEX fgedu.idx_orders_customer DISABLE;

# 3. 创建GoldenGate用户
SQL> CREATE USER fgedu_ggadmin_target IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users;

User created.

SQL> GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER, CREATE VIEW TO fgedu_ggadmin_target;

Grant succeeded.

SQL> GRANT DBA TO fgedu_ggadmin_target;

Grant succeeded.

# 1. 登录源端GoldenGate
$ cd /oracle/goldengate
$ ./ggsci

GGSCI (fgedu.net.cn) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

# 2. 创建初始加载Extract
GGSCI (fgedu.net.cn) 2> add extract initext, sourceistable
Extract INITEXT added.

# 3. 配置初始加载Extract参数
GGSCI (fgedu.net.cn) 3> edit params initext

EXTRACT initext
SETENV (NLS_LANG=”AMERICAN_AMERICA.AL32UTF8″)
SETENV (ORACLE_HOME=/oracle/app/oracle/product/19c/dbhome_1)
SETENV (ORACLE_SID=fgedudb)

USERIDALIAS fgedu_ggadmin
RMTHOST 192.168.1.100, MGRPORT 7809
RMTTASK REPLICAT, GROUP initrep

# 性能参数
FETCHBATCHSIZE 5000
FLUSHBATCHES 100

# 表映射
TABLE fgedu.fgedu_orders;
TABLE fgedu.fgedu_customers;

# 保存并退出

# 4. 验证配置
GGSCI (fgedu.net.cn) 4> view params initext

EXTRACT initext
SETENV (NLS_LANG=”AMERICAN_AMERICA.AL32UTF8″)
SETENV (ORACLE_HOME=/oracle/app/oracle/product/19c/dbhome_1)
SETENV (ORACLE_SID=fgedudb)

USERIDALIAS fgedu_ggadmin
RMTHOST 192.168.1.100, MGRPORT 7809
RMTTASK REPLICAT, GROUP initrep

FETCHBATCHSIZE 5000
FLUSHBATCHES 100

TABLE fgedu.fgedu_orders;
TABLE fgedu.fgedu_customers;

# 1. 登录目标端GoldenGate
$ cd /oracle/goldengate
$ ./ggsci

GGSCI (fgedu-target.net.cn) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

# 2. 创建初始加载Replicat
GGSCI (fgedu-target.net.cn) 2> add replicat initrep, specialrun
REPLICAT added.

# 3. 配置初始加载Replicat参数
GGSCI (fgedu-target.net.cn) 3> edit params initrep

REPLICAT initrep
SETENV (NLS_LANG=”AMERICAN_AMERICA.AL32UTF8″)
SETENV (ORACLE_HOME=/oracle/app/oracle/product/19c/dbhome_1)
SETENV (ORACLE_SID=fgedudb_target)

USERIDALIAS fgedu_ggadmin_target

# 性能参数
BULKLOAD
INSERTAPPEND
MAXTRANS 1000

# 错误处理
HANDLECOLLISIONS
REPERror DEFAULT, ABEND

# 表映射
MAP fgedu.fgedu_orders, TARGET fgedu.fgedu_orders;
MAP fgedu.fgedu_customers, TARGET fgedu.fgedu_customers;

# 保存并退出

# 4. 验证配置
GGSCI (fgedu-target.net.cn) 4> view params initrep

REPLICAT initrep
SETENV (NLS_LANG=”AMERICAN_AMERICA.AL32UTF8″)
SETENV (ORACLE_HOME=/oracle/app/oracle/product/19c/dbhome_1)
SETENV (ORACLE_SID=fgedudb_target)

USERIDALIAS fgedu_ggadmin_target

BULKLOAD
INSERTAPPEND
MAXTRANS 1000

HANDLECOLLISIONS
REPERror DEFAULT, ABEND

MAP fgedu.fgedu_orders, TARGET fgedu.fgedu_orders;
MAP fgedu.fgedu_customers, TARGET fgedu.fgedu_customers;

# 1. 启动初始加载Extract
GGSCI (fgedu.net.cn) 5> start extract initext

Sending START request to MANAGER …
EXTRACT INITEXT starting

# 2. 监控加载进度
GGSCI (fgedu.net.cn) 6> info extract initext

EXTRACT INITEXT Last Started 2026-04-03 14:30:00 Status RUNNING

# 3. 查看统计信息
GGSCI (fgedu.net.cn) 7> stats extract initext

Sending STATS request to EXTRACT INITEXT …

Start of Statistics at 2026-04-03 14:35:00.

Extracting from FGEDU.FGEDU_ORDERS to FGEDU.FGEDU_ORDERS:
Total inserts 10000000.00
Total operations 10000000.00

Extracting from FGEDU.FGEDU_CUSTOMERS to FGEDU.FGEDU_CUSTOMERS:
Total inserts 5000000.00
Total operations 5000000.00

End of Statistics.

# 4. 查看报告
GGSCI (fgedu.net.cn) 8> view report initext

2026-04-03 14:30:00 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, initext.prm: EXTRACT starting.
2026-04-03 14:30:00 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, initext.prm: Connected to database fgedudb.
2026-04-03 14:35:00 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, initext.prm: Extracting from FGEDU.FGEDU_ORDERS to FGEDU.FGEDU_ORDERS.
2026-04-03 14:40:00 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, initext.prm: Extracting from FGEDU.FGEDU_CUSTOMERS to FGEDU.FGEDU_CUSTOMERS.
2026-04-03 14:45:00 INFO OGG-01051 Oracle GoldenGate Capture for Oracle, initext.prm: EXTRACT ending.

# 5. 验证加载完成
GGSCI (fgedu.net.cn) 9> info extract initext

EXTRACT INITEXT Last Started 2026-04-03 14:30:00 Status STOPPED

# 6. 在目标端验证数据
SQL> SELECT COUNT(*) FROM fgedu.fgedu_orders;

COUNT(*)
———-
10000000

SQL> SELECT COUNT(*) FROM fgedu.fgedu_customers;

COUNT(*)
———-
5000000