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

>>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_at_servicecanada.gc.ca < joanne.pomalis_at_servicecanada.gc.ca> 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

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