Do you mean running tdposync as root user? No, this is not required; you can run tdposync as the Oracle user.
I recommend contacting IBM support so that you can provide logs and traces to get this resolved. Mark "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 07/19/2021 08:06:32 AM: > From: "Zoltan Forray" <zfor...@vcu.edu> > To: ADSM-L@VM.MARIST.EDU > Date: 07/19/2021 08:12 AM > Subject: [EXTERNAL] Re: [ADSM-L] Oracle TDP backups & tdposync > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > Thank you for the response. We have looked at that document. > > The DBA tried running it again but is still having issues. We think it > might require ROOT authority? If so, that is going to be an issue since > ROOT is very, very strictly controlled? > > On Sun, Jul 18, 2021 at 2:51 PM Mark Yakushev <bar...@us.ibm.com> wrote: > > > Hi Zoltan, > > > > Please take a look at the documentation - > > https://www.ibm.com/docs/en/spfd/8.1.0?topic=utility-syncdb-command > > > > The connection string would be the same as if you connected to the catalog > > using RMAN. > > > > Mark > > > > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 07/18/2021 > > 07:09:57 AM: > > > > > From: "Zoltan Forray" <zfor...@vcu.edu> > > > To: ADSM-L@VM.MARIST.EDU > > > Date: 07/18/2021 07:11 AM > > > Subject: [EXTERNAL] [ADSM-L] Oracle TDP backups & tdposync > > > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > > > > > Recently, I stumbled upon some Oracle TDP backups that had become > > > abandoned/out of sync with RMAN by about 6-years. > > > > > > Talking with the DBA folks, I found out they have never run tdposync on > > > their numerous Oracle TDB backups - always just synching from the RMAN > > > side, thus causing dozens of TB worth of abandoned Oracle backups. > > > > > > They tried to run tdposync but cannot get past the "# Oracle connection > > > string" issue to determine what value to use. > > > > > > Can someone give us some guidance on how to determine this value? > > > > > > > > > > > > -- > > > *Zoltan Forray* > > > VMware Administrator > > > IBM Spectrum Protect Administrator > > > Virginia Commonwealth University > > > UCC/Office of Technology Services > > > www.ucc.vcu.edu > > > zfor...@vcu.edu - 804-828-4807 > > > Don't be a phishing victim - VCU and other reputable organizations will > > > never use email to request that you reply with your password, social > > > security number or confidential personal information. For more details > > > visit INVALID URI REMOVED > > > u=http-3A__phishing.vcu.edu_&d=DwIBaQ&c=jf_iaSHvJObTbx- > > > > > > > > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=y5zb84U-78CEU5IWJ1UuYyXqXOF52k2SZlPZIX0PWuQ&s=Bzi4NYw6LM1cyY9Rp0ZN64U5c8jvoKMxAOAXe0NnWPg&e= > > > > > <INVALID URI REMOVED > > > u=https-3A__adminmicro2.questionpro.com&d=DwIBaQ&c=jf_iaSHvJObTbx- > > > > > > > > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=y5zb84U-78CEU5IWJ1UuYyXqXOF52k2SZlPZIX0PWuQ&s=q2YEXoomhd5gu9hpJTZjqoBdbg_m5kb_zw0e9KJ13wY&e= > > > > > > > > > > > -- > *Zoltan Forray* > VMware Administrator > IBM Spectrum Protect Administrator > Virginia Commonwealth University > UCC/Office of Technology Services > www.ucc.vcu.edu > zfor...@vcu.edu - 804-828-4807 > Don't be a phishing victim - VCU and other reputable organizations will > never use email to request that you reply with your password, social > security number or confidential personal information. For more details > visit INVALID URI REMOVED > u=http-3A__phishing.vcu.edu_&d=DwIBaQ&c=jf_iaSHvJObTbx- > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=e- > r-25UfV_BkBmjj2gWdPxQdnwRco1prxRkVnE-k- > Dg&s=Q_VeZTMhXHQvOMi22QE8PK0kO-bMfdexmYqii9UYwKQ&e= > <INVALID URI REMOVED > u=https-3A__adminmicro2.questionpro.com&d=DwIBaQ&c=jf_iaSHvJObTbx- > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=e- > r-25UfV_BkBmjj2gWdPxQdnwRco1prxRkVnE-k-Dg&s=bjRe7BRHYRMfsRMpNwnIEyg- > J3Mtyw_CPzfAPRzBldk&e= >
