Oracle GoldenGate – Adamhuan's Data Center

GoldenGate：删除extract

这里只是做一个记录：
如果之前在OGG中配置了EXTRACT，但是现在需要删除，那么你直接执行“delete extract [extract_name]”就可以了。

具体如下所示：

GGSCI (ogg1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EORA        00:00:00      00:00:03    
EXTRACT     STOPPED     PUMP_SO     00:00:00      11:24:55    
EXTRACT     RUNNING     PUSH_SO     00:00:00      00:00:09    


GGSCI (ogg1) 2> delete extract pump_so
Deleted EXTRACT PUMP_SO.


GGSCI (ogg1) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EORA        00:00:00      00:00:04    
EXTRACT     RUNNING     PUSH_SO     00:00:00      00:00:01    


GGSCI (ogg1) 4>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

GGSCI (ogg1) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA 00:00:00 00:00:03

EXTRACT STOPPED PUMP_SO 00:00:00 11:24:55

EXTRACT RUNNING PUSH_SO 00:00:00 00:00:09

GGSCI (ogg1) 2> delete extract pump_so

Deleted EXTRACT PUMP_SO.

GGSCI (ogg1) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA 00:00:00 00:00:04

EXTRACT RUNNING PUSH_SO 00:00:00 00:00:01

GGSCI (ogg1) 4>

——————————————
Do[……]

发表于： 2016年4月2日 2016年4月2日
作者： Adamhuan
分类： Oracle GoldenGate
标签： delete extract, extract, GoldenGate, Oracle
发表评论: GoldenGate：删除extract

OGG: OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo

如题所示的错误，发生在为Oracle RAC配置OGG的时候，启动源端（RAC）的抽取进程。
该错误的详细反馈如下：

[oracle@rac2 ogg_1]$ cat ggserr.log | grep --color "OGG-00446"
2016-03-30 11:14:05  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extdata.prm:  No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000.
2016-03-30 11:27:49  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extdata.prm:  No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000.
2016-03-30 11:31:23  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extdata.prm:  No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:30:22.000000.
[oracle@rac2 ogg_1]$

1

2

3

4

5

[oracle@rac2 ogg_1]$ cat ggserr.log | grep --color "OGG-00446"

2016-03-30 11:14:05 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000.

2016-03-30 11:27:49 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000.

2016-03-30 11:31:23 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:30:22.000000.

[oracle@rac2 ogg_1]$

造成该错误的原因是因为RAC的共享存储采用了ASM（自动存储管理），而OGG的抽取进程无法连接到ASM，[……]

发表于： 2016年3月30日 2016年3月30日
作者： Adamhuan
分类： Oracle GoldenGate
标签： Extract Fails Due to an ASM Connection Configuration Issue (文档 ID 1061093.1), GoldenGate, ogg, OGG-00446
发表评论: OGG: OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo

OGG:ERROR: Could not delete DB checkpoint for REPLICAT REPL

在OGG的配置过程中，可能你会遇到如题的错误。
它的具体场景是，你的OGG中有一个REPLICAT复制进程，但是你希望删掉重新配置：

GGSCI (ogg3) 17> delete replicat REPL  
ERROR: Could not delete DB checkpoint for REPLICAT REPL (Database login required to delete database checkpoint)

GGSCI (ogg3) 18>

1

2

3

4

GGSCI (ogg3) 17> delete replicat REPL

ERROR: Could not delete DB checkpoint for REPLICAT REPL (Database login required to delete database checkpoint)

GGSCI (ogg3) 18>

解法：
其实，对于REPLICAT这样的进程要执行删除，你需要先“dblogin”才可[……]