Hi All,
        I have overcome the problem. I had to use the sequence number. but I
wish to seek help from all of you regarding precautions  to be taken to
recover from a  catalog database loss.


Thanks

Sri




> -----Original Message-----
> From: Gogineni, Sri
> Sent: Friday, June 18, 1999 12:30 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      ORACLE CONNECT AGENT- CATALOG RESTORE
>
> Hi all,
>        We are doing a testing og the ORACLE connect agent with EBU on
> ORACLE 7.3.4 .   I installed two databases , one for the target database
> and the other for the catalog database on the same .
>
>
> After  haing been able to backup and restore the target database , I would
> like to be able to restore the catalog database ( EBU RESTORE CATALOG)
> but it just seems to be failing at the server side giving the below error.
>
>
>
> 06/18/99   12:16:10  ANE4990I (Session: 832, Node: CSIFIWS8064)    Oracle
>                       Connect Agent
> 06/18/99   12:16:11  ANE4990I (Session: 832, Node: CSIFIWS8064)  (20270):
>                       06/17/1999:12:16:28 =>(csifiws8064) sbtinfo():
> ANS1302E
>                       (RC2)    No objects on server match query.
> BKCATL3FB986
> 06/18/99   12:16:11  ANR0403I Session 832 ended for node CSIFIWS8064 (Agnt
> for
>                       Orc Bkp).
> 06/18/99   12:16:11  ANR0406I Session 833 started for node CSIFIWS8064
> (Agnt
>                       for Orc Bkp) (Tcp/Ip 166.49.118.64(34017)).
> 06/18/99   12:16:11  ANE4990I (Session: 833, Node: CSIFIWS8064)    Oracle
>                       Connect Agent
> 06/18/99   12:16:11  ANE4990I (Session: 833, Node: CSIFIWS8064)  (20270):
>                       06/17/1999:12:16:28 =>(csifiws8064) queryObj():
> ANS1302E
>                       (RC2)    No objects on server match query
> 06/18/99   12:16:11  ANE4990I (Session: 833, Node: CSIFIWS8064)    Oracle
>                       Connect Agent
> 06/18/99   12:16:11  ANE4990I (Session: 833, Node: CSIFIWS8064)  (20270):
>                       06/17/1999:12:16:28 =>(csifiws8064) sbtinfo():
> ANS1302E
>                       (RC2)    No objects on server match query.
> BKCATL3FB985
> 06/18/99   12:16:11  ANR0403I Session 833 ended for node CSIFIWS8064 (Agnt
> for
>                       Orc Bkp)
>
>
>
> Do I have to install the catalog database neccessarily on another box even
> for testing. Or is there any minor thing that iam missing out.
>
>
> Thanks
>
> sri