GoldenGate Extract wants archivelog from before checkpoint
- From: De DBA <dedba@xxxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Jul 2012 09:55:52 +1000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
