Re: how recover post 19c database upgrade

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 12.1.0.2 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.

Regards

On 3/27/20 8:33 AM, Jeffrey Beckstrom wrote:
> We will be upgrading our EBS 11.2.0.4 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


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