Not quite. A resetlogs is only done on failover or when opening a snapshot
standby.
There are some new upgrade options wrt Dataguard in oracle 12.2 and above that
do allow an upgrade of the standby first. However, with. 11.2.0.4, a standby
first upgrade can only be done if using a logical standby. You might be able to
covert it to a logical standby and upgrade from there...
Sent from my iPad
On Aug 20, 2019, at 11:50, Tim Gorman <tim.evdbt@xxxxxxxxx> wrote:
Not true. To upgrade, database has to be opened, and to open a standby, you
have to RESETLOGS.
Snapshot standby uses Flashback database to restore prior to the RESETLOGS so
that managed recovery can resume uninterrupted.
On 8/20/19 9:43 AM, gogala.mladen wrote:
Yes it is possible because upgrade doesn't do resetlogs.
Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------
From: Howard Latham <howard.latham@xxxxxxxxx>
Date: 8/20/19 9:49 AM (GMT-05:00)
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Standby First upgrades
Oracle 11.2.0.4 and 18.3
DATAGUARD
RHEL 6
I have been told I can, but looking at ORACLE Doc it says NO!
Is it possible to do a standby first upgrade from 11.2.0.4 to 18 in a
dataguard setup?
My gut feeling BTW is no.
Best Wishes
Howard A. Latham