GoldenGate

Gurus:

I have a simple extract and replicat defined. Whenever I run the extract, it ended up being abended after a couple of minutes with the following errors. I understand it was trying to check the old archived logs. However, I didn't want it to check old information, I would like to work from the newly initialized time and forward. Here was what I did:

I defined a simple initial load extract to replicated everything in the source table to the target table which was successful. I used this to get my environment initialized. The source and target were in sync in my limited knowledge.

I then issued "alter extract extoc_dz begin now" and then started the extract process again. The problem was that I still got the following error which was trying to find the old archived log which was no longer there.

How can I fix this problem?

What should I do to make GG start to work after the initialization point I newly did, not requesting those old archived logs?

Please advise.

error message excerpt:

2011-11-09 09:52:25 ERROR OGG-00446 Could not find archived log for sequence 1193 thread 2 under default destinations SQL <SELECT name FROM v$archived
log WHERE sequence# = :oraseq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND de
leted = 'NO>, error retrieving redo file name for sequence 1193, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2011-11-
09 09:50:35.

2011-11-09 09:52:25 ERROR OGG-01668 PROCESS ABENDING.


definitions of the extract and replicate:

GGSCI > ADD EXTRACT extoc_dz, TRANLOG, THREADS 3, BEGIN NOW
GGSCI > ADD RMTTRAIL /oracle/ogg/dirdat/oc, EXTRACT extoc_dz
GGSCI > ADD REPLICAT repoc_dz, EXTTRAIL /oracle/ogg/dirdat/oc

GGSCI (ddiadlodev1) 12> view params extoc_dz
EXTRACT extoc_dz
USERID ogg@mydb, PASSWORD *****
TRANLOGOPTIONS ASMUSER sys@gg_asm1, asmpassword *****
THREADOPTIONS PROCESSTHREADS EXCEPT 3
RMTHOST ddiadlodev1, MGRPORT 15000
RMTTRAIL /oracle/ogg/dirdat/oc
TABLE dzhou.dz_users;

GGSCI (ddiadlodev1) 13> view params repoc_dz
REPLICAT repoc_dz
ASSUMETARGETDEFS
USERID ogg@mydb, PASSWORD *****
MAP dzhou.dz_users, TARGET dzhou.dz_new_users;


Thanks a lot for all your help.

dz