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

Other related posts: