RE: (EXT) Re: how recover post 19c database upgrade

From: Steve Wales (AddOns) <"Steve>
Date: Fri, 27 Mar 2020 17:48:41 +0000
Message-ID: <>

Depending upon your storage methodology can you take SAN level snapshots ?

We recently went through Oracle 12 to Oracle 18 upgrade, also upgrading our ERP system.

We have a ZFS storage appliance. I shutdown the database and took a snapshot before I started. Upgraded to Oracle 18, another shutdown and snapshot and then ERP system upgrade and new snapshot and then restarted regular backups.

If I needed to restore I had my ZFS snapshots at each of the milestones I could snap back to as needed.


From: <> On Behalf Of Jeffrey Beckstrom Sent: Friday, March 27, 2020 7:08 AM
To: Howard Latham <> Cc: oracle-l-freelist <> Subject: (EXT) Re: how recover post 19c database upgrade

I do not wish to flash back. Lets say that upgrade finished at time point A. At time point B, something dreadfull happens requiring recovery. We would want to recover until right before the time point B incident.
>>> Howard Latham <<>> 3/27/20 9:00 AM >>>
I'm not going to say ofcourse it will be fine but for testing purposes I have had to upgrade from to 19c and flashed back many times over the last year successfully. Use guaranteed restore point.

Best Wishes

Howard A. Latham

On Fri, 27 Mar 2020 at 12:35, 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

This email has been scanned for spam and viruses. Click here<> to report this email as spam.


The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived.

Received on Fri Mar 27 2020 - 18:48:41 CET

Original text of this message