Re: How do I force CDC capture from Aborted to Enabled?

  • From: "Arul Ramachandran" <contactarul@xxxxxxxxx>
  • To: joanne.pomalis@xxxxxxxxxxxxxxxxxxx
  • Date: Thu, 3 Aug 2006 16:29:45 -0700

Any help would be greatly appreciated! 

Did you try to shut and restart the capture process? I guess you must have
tried that.
Other than that, if you have nothing to lose, you can drop and re-create the
CDCPUB user that owns the queues and queue tables - this sort of initializes
ACDC.

Regards,
Arul


On 8/3/06, joanne.pomalis@xxxxxxxxxxxxxxxxxxx <
joanne.pomalis@xxxxxxxxxxxxxxxxxxx> wrote:


 I have set up asyncronous hotlog change data capture from a 9iR2
mainframe oracle database to an AIX 10gR2 database. The mainframe process didn't
work and put the capture into Abended status.

*** SESSION ID:(21.175) 2006-08-01 17:28:51.777
error 10010 in STREAMS process
ORA-10010: Begin Transaction
ORA-00308: cannot open archived log '//'EDB.RL11.ARCHLOG.T1.S5965.DBF''
ORA-04101: OS/390 implementation layer error
ORA-04101, FUNC=LOCATE , RC=8, RS=C5C7002A, ERRORID=1158
::OPIRIP: Uncaught error 447. Error stack::ORA-00447: fatal error in
background
A-00308: cannot open archived log '//'EDB.RL11.ARCHLOG.T1.S5965.DBF''
ORA-04101: OS/390 implementation layer error
ORA-04101, FUNC=LOCATE , RC=8, RS=C5C7002A, ERRORID=1158

This is because I had lower case characters in the log file format in the
init.ora on the mainframe. The actual log file that was created was a
completely different name.

I shut down the database and fixed the init.ora. Switched the log file. I
dropped all the objects that I created for CDC. I recreated the capture and
altered the start scn of the capture to the current log which I found by
running: select to_char(max(first_change#)) from v$log;

I created the other objects, but when I run
dbms_cdc_publish.alter_hotlog_change_source to enable, it immediately
changes the capture from disabled to abended status, and gives me the same
error message as above.

How do I get the capture out of abended status, and how do I get it to NOT
try to find the old archive log file (which isn't there anyways)?

Any help would be greatly appreciated!

Thanks,
Joanne Pomalis






--
Arul

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006