Re: ZDLRA patched to 19.2.1.2.2105-RELEASE.x86_64 is now broken!!

Hi Gabriel,

Thanks so much for the response. I thought we were foolish to get to bleeding edge for a minute there.

Oracle development logged into our system last night and fixed it. I am so relieved!!

Apparently an ORA-4031 caused one of the backend processes to die. This backend process just happens to be the one that did all the work for VB and delete protected dbs. Once the RA instance was restarted things kicked off again.

It may have something to do with this:
Bug 33206160 <https://support.oracle.com/epmos/faces/BugDisplay?id=33206160&parent=SrDetailText&sourceId=3-26604755721> - WHEN PROCESS DIES DUE TO ORA-4031, USER_SCHEDULER_RUNNING_JOBS NOT CLEANED UP

We had the ora-4031 well before the patch too and it doesn’t cause such issues. Oracle also said ORA-4031 was supposed to be fixed in RA 19 so we’ll see if they can fix it this time.  

Cheers,

Leng.

> On 9 Aug 2021, at 10:19 pm, Gabriel Hanauer <gabriel.hanauer_at_gmail.com> wrote:
>
> Hello Leng,
>
> We updated it on august, 2.
>
> No problems at all.
>
> [root_at_celzdldbadm01 ~]# rpm --query ra_automation
> ra_automation-19.2.1.1.2.202105-32919847.x86_64
>
> Did a restore database validate and it finishes without problem:
>
> channel ORA_SBT_TAPE_1: restored backup piece 1
> channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:25
> Finished restore at 09/08/2021 09:14:37
>
> RMAN>
>
> Regards,
>
> On Sun, Aug 8, 2021 at 10:14 PM Leng Burgess <lkaing_at_gmail.com <mailto:lkaing_at_gmail.com>> wrote:
> G’Day all,
>
> Has anyone upgrade to the latest ZDLRA?
>
> [root_at_zdlradbadm02 oracle]# rpm --query ra_automation
> ra_automation-19.2.1.1.2.202105-RELEASE.x86_64
>
> Oracle Platinum Patching patched our system on Jul 27th and now our RA is broken!
>
> Inc level 1 forever are no longer merged with into virtual level 0s, or Virtual Backups (VB). The RA reported "ORA-64830: Incremental backup for database x is not up-to-date.” for ALL protected dbs.
>
> Restore of datafile hangs because it can’t find the VB to restore.
>
> Restore of archivelogs and other items are fine because they don’t get merged into a VB.
>
> Removal of a protected db just marks it with a cross but doesn’t remove it at all.
>
> I’ve also taken a new Level 0 and subsequent level 1s are not merged into VB. I just have level 1 and level 1s! This is not good as we’ll run out of RA space to backup our databases and defeats the whole purpose of an incremental forever that we paid for in the RA!!
>
> Yes, a sev 1 escalated SR and bug is logged but so far no joy. A whole lot of diagnostics, traces, radumps have been given to Oracle and no signs of what they are doing with it all!!
>
> Anybody having any luck out there?
>
> Thanks,
>
> Leng.--
> http://www.freelists.org/webpage/oracle-l <http://www.freelists.org/webpage/oracle-l>
>
>
>
>
> --
> Gabriel Hanauer

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