Thanks for the assistance. The DBA finally got it working and purged long abandoned Oracle backups - some going back to 2015 - and released 60TB+ of backups. He now realized they have to run tdposync on a regular basis - not just RMAN sync.
On Mon, Jul 19, 2021 at 1:01 PM Mark Yakushev <bar...@us.ibm.com> wrote: > 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= > > -- *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 http://phishing.vcu.edu/ <https://adminmicro2.questionpro.com>
