How do I force CDC capture from Aborted to Enabled?

> 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

--
http://www.freelists.org/webpage/oracle-l