Shulou(Shulou.com)06/01 Report--

Today, when cleaning the Trail files of GoldenGate, all of them were accidentally deleted, resulting in the suspension of the EXTRACT process on the source side of GoldenGate.

1. Delete the EXTRACT process of the source-side database:

GGSCI (crm_master) 4 > dblogin userid ogg,password OC8rGBIjkBG

Successfully logged into database.

GGSCI (crm_master) 5 > delete extract EXTND

Deleted EXTRACT EXTND.

GGSCI (crm_master) 6 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPEND 00:00:00 00:00:06

GGSCI (crm_master) 7 > add exttrail. / gglog/nd,extract EXTND,megabytes 1000

EXTTRAIL added.

GGSCI (crm_master) 8 > ADD EXTTRAIL / oradata/gglog/nd, EXTRACT EXTND

EXTTRAIL added.

GGSCI (crm_master) 9 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPEND 00:00:00 00:00:04

EXTRACT STOPPED EXTND 00:00:00 00:07:42

GGSCI (crm_master) 10 > start extnd

Sending START request to MANAGER...

EXTRACT EXTND starting

GGSCI (crm_master) 11 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPEND 00:00:00 00:00:09

EXTRACT RUNNING EXTND 00:07:46 00:00:01

GGSCI (crm_master) 12 >

two。 Check the Trail file number of the source database

[oracle@node1 ogg] $ll.. / gglog/

Total 724

-rw-rw-rw- 1 oracle oinstall 737414 Jul 27 14:34 nd000000

[oracle@node1 ogg] $

3. Specify the Trail number in the target database

GGSCI (crm_slave) 5 > alter REPLICAT repl extseqno 000, extrba 0

REPLICAT altered.

GGSCI (crm_slave) 6 > start repl

Sending START request to MANAGER...

REPLICAT REPL starting

GGSCI (crm_slave) 7 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPL 00:00:00 00:00:00

GGSCI (crm_slave) 8 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.