Re: how recover post 19c database upgrade
- From: "Jeffrey Beckstrom" <jbeckstrom@xxxxxxxxx>
- To: "Howard Latham" <howard.latham@xxxxxxxxx>
- Date: Fri, 27 Mar 2020 09:07:31 -0400
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 <howard.latham@xxxxxxxxx> 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 11.2.0.4 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 <jbeckstrom@xxxxxxxxx> 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
This email has been scanned for spam and viruses. Click here
(
https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1585314079-srL6QI1mdpLZ&r_address=jbeckstrom%40gcrta.org&report=1)
to report this email as spam.
Other related posts: