RE: GoldenGate extract error
- From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- To: <alex@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 May 2010 13:38:23 -0400
Alex, I may have found a solution. Are you still having problems? Are your
online and archived log files in ASM?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Alex Octan
Sent: Friday, May 28, 2010 9:41 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: GoldenGate extract error
This is very interesting!!
I am facing with the same problem, but on Solaris platform.
It was working, I tried to change the Extractor processes and I started to
get this error too.
Any clue is more than welcome.
Thanks.
Alex
On Thu, May 27, 2010 at 15:57, Terrian, Thomas J Mr CTR DLA J6DIB
<Tom.Terrian.ctr@xxxxxxx> wrote:
Oracle 11g
HPUX
Anyone using GoldenGate?
I am getting the following error for my Extract process:
2010-05-27 14:48:14 GGS ERROR 500 Oracle GoldenGate Capture
for
Oracle, ext1.prm: Could not find archived log for sequence 2317
thread 1
under default destinations SQL <SELECT name FROM gv$archived_log
WHERE
sequence# = :ora_seq_no AND thread# = :ora_thread AND
resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND
deleted = 'N>, error retrieving redo file name for sequence 2317,
archived =
1, use_alternate = 0Not able to establish initial position for begin
time
2010-05-27 10:41:17.
The database is in ASM and the archive file does exist. Does anyone
know
why the Extract process cannot see the archived log?
Tom
Other related posts: