How to Upgrade with AutoUpgrade and Data Guard
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- You can use AutoUpgrade on your Oracle Database with Data Guard. It’s easy and simple. This demo shows how to upgrade to Oracle Database 19c without compromising the standby database. Check out this blog post series for more details and step-by-step instructions: dohdatabase.co...
Thanks so much, short but very clear demo
Hi,
Glad you liked it. Thanks for the positive feedback. Appreciated.
Regards,
Daniel
Very nice video. Very simple to follow. Thank you.
Hi Kamaldeep,
Thanks for the feedback. Much appreciated.
Happy upgrading!
Daniel
Thanks Daniel , that was very informative
Glad you enjoyed it.
Regards,
Daniel
It was showing 12c after upgrade.. pls check
Hi,
Good catch. The database is upgraded fine, however, it seems like we used the wrong environment settings in the demo (that's not ideal). We should have set the environment to the 19c Oracle home and used the binaries from there.
Regards,
Daniel
if we create GRP at the primary side it will automatically create one at standby and if we drop it from primary it will automatically drop from standby.
Hi,
Yes, you are right. In Oracle Database 19c, creation of restore points propagate to the standby database as well. However, propagated restore points will NEVER be guaranteed on the standby database. For an upgrade, you want to have a guaranteed restore point on the standby database as well. Thus, you must create it manually on the standby database.
Regards,
Daniel
as per video steps downtime will start as soon standby is mounted on new version binary and there will be no rollback...
and downtime will finish once db upgrade with postfix up n switchover completes.
Hi Pankaj,
You're right that downtime starts when you stop and mount the standby in the new Oracle Home. But there is a rollback. I set a guaranteed restore point that I can use in case of fallback. Even if I have started the standby in the new Oracle Home, I can still flashback and restart in the old Oracle Home. We have a demo of that here:
th-cam.com/video/P12UqVRzarw/w-d-xo.html
Regards,
Daniel
short and sweet demo.
after standby database relocated to 19c home and db put in upgrade/mount mode , the step to put DR database in recovery mode i.e. "alter database recover managed standby managed" wasn't specified.. I am not sure if that was handled in dgmgrl, but did not observe this step. please clarify if possible.
Hi Balwant,
The Data Guard broker configuration has the standby database set to "APPLY-ON". The Data Guard broker is on during the upgrade, so broker will ensure that redo apply gets turned on in the standby database. That's why it isn't shown.
Regards,
Daniel
Thanks Daniel.What about downtime and prerequisite for this.
Hi Gopi,
You can find the prerequisites in my introduction post of my Data Guard blog post series: dohdatabase.com/2022/07/27/upgrade-data-guard. It also has a dedicated post about downtime.
Regards,
Daniel