Hi Zoltan, I am glad it worked! RMAN sync deletes unneeded objects from SP Server via DP for Oracle. Sometimes it does not happen (backdel = no, SP server is down, etc.) and one has to user tdposync to delete.
Mark "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 07/20/2021 12:49:46 PM: > From: "Zoltan Forray" <zfor...@vcu.edu> > To: ADSM-L@VM.MARIST.EDU > Date: 07/20/2021 12:51 PM > Subject: [EXTERNAL] Re: [ADSM-L] Oracle TDP backups & tdposync > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > 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 INVALID URI REMOVED > u=http-3A__phishing.vcu.edu_&d=DwIBaQ&c=jf_iaSHvJObTbx- > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=hL- > NGaKSmnOPOJkkOgJBhVXc5x6ewXNLzSRSHUD4DnE&s=5rVQvCrDPxSlQMH2hTcR- > pFNJoHZIgXasbKayof_jd4&e= > <INVALID URI REMOVED > u=https-3A__adminmicro2.questionpro.com&d=DwIBaQ&c=jf_iaSHvJObTbx- > siA1ZOg&r=P0djPsyxqr3P1Q7z_dWSw0b5KJCurUx_6PfSjVxDvow&m=hL- > NGaKSmnOPOJkkOgJBhVXc5x6ewXNLzSRSHUD4DnE&s=4k7wY- > nhkJwLHuPw3bM9iLYSGoG0qWBRY_TCUPt7cfU&e= >
