Hello team, we have the following situation:
2 node RAC11.2.0.2 and a physical standby 11.2.0.2 in ASM. We have to upgrade the RAC environment to 11.2.0.4 assuring the minimal downtime. We are thinking shutdown RAC environment (Prod) and open standby database RW so people can work. Upgrade RAC environment (GI and RDBMS) but do not upgrade database dictionary. Then apply all the archivelogs generated on "standby" database (which is now production) on RAC database, since both are going to be the same version 11.2.0.2 and then upgrade database and open.
Is this possible? or should we restore a full database backup of standby on RAC environment and then upgrade?
Thanks in advance