Re: how recover post 19c database upgrade

From: Mladen Gogala <>
Date: Fri, 27 Mar 2020 16:12:36 -0400
Message-ID: <>

I always do RMAN backup. You upgrade your database, you back it up and discard all of your pre-upgrade backups since they can no longer be restored. I have upgraded database to 19c and have tested recovery because the client wanted their development DB refreshed from production. The desired backup was made available and the client has run their "masking" script. Restore worked just fine. I don't see any need to change the backup strategy with 19c.


On 3/27/20 8:33 AM, Jeffrey Beckstrom wrote:
> We will be upgrading our EBS database to 19C. Since EBS, we
> also have to then convert the database to multi-tenant. Support is
> telling me that a post-upgrade backup is not required and that rman
> pre plugin recovery option is not designed to recover through an upgrade.
> Question, in event of a catastrophe, how would we recover our database
> post upgrade?
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Fri Mar 27 2020 - 21:12:36 CET

Original text of this message