How to Upgrade with AutoUpgrade and Data Guard

[@fikriatshokonelidze6343]

Thanks so much, short but very clear demo

[@upgradenow]

Hi, Glad you liked it. Thanks for the positive feedback. Appreciated. Regards, Daniel

[@KamaldeepKhanuja]

Very nice video. Very simple to follow. Thank you.

[@upgradenow]

Hi Kamaldeep, Thanks for the feedback. Much appreciated. Happy upgrading! Daniel

[@MrEnrique2k]

Thanks Daniel , that was very informative

[@upgradenow]

Glad you enjoyed it. Regards, Daniel

[@saurabhnigam27]

It was showing 12c after upgrade.. pls check

[@upgradenow]

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

[@shahabpatel7638]

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.

[@upgradenow]

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

[@balwantc]

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.

[@upgradenow]

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

[@gopiv5272]

Thanks Daniel.What about downtime and prerequisite for this.

[@upgradenow]

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

[@pankajaggarwal5355]

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.

[@upgradenow]

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: kzbin.info/www/bejne/hmKVhqSMh9-UqNk Regards, Daniel