GoldenGate Extract wants archivelog from before checkpoint

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 13 Jul 2012 09:55:52 +1000
Message-ID: <4FFF6408.80809_at_tpg.com.au>



G'day,

I'm in the process of migrating a 9i database to 11g with the help of GoldenGate. Due to some misunderstanding somewhere, the GoldenGate extract on the 9i instance has been down for 2 weeks. The abend was caused be a relocation error, perhaps due to memory leaks? It is a very old non-supported version, after all. When we start it up now it abends with this message:

2012-07-12 18:45:13  GGS ERROR       190  Could not find archived log for sequence 187880 thread 1 under default destinations SQL<SELECT  name    FROM gv$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread AND         archived = 'YES' AND         deleted = 'NO' AND         name not like '+%'         AN>, error retrieving redo file name for sequence 187880, archived = 1, use_alternate = 0.
2012-07-12 18:45:13  GGS ERROR       190  PROCESS ABENDING.

Clear - it needs archived log sequence 187880 which was created (according to the database) on 27 June. That log is missing, not backed up and not retrievable. We are looking at starting all over again.. :(

What is strange though is this line in the extract detailed info:

Log Read Checkpoint Oracle Redo Logs

                      2012-06-30 10:00:00  Seqno 188166, RBA 189710336


How now? We already are up to log sequence 188166 and still need 187880? Why? Am I missing something here? The command we use to restart the extract is

GSSCI> start extract E1

Should I give it a sequence number here? Any help will be appreciated.

Version info:

  • Oracle EE 9.2.0.8
  • GoldenGate for Oracle 9i and HPUX B11.11 ( 10.4.0.19 )
  • HPUX 11.1
Cheers,
Tony
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 12 2012 - 18:55:52 CDT

Original text of this message