Re: Standby First upgrades

Andrew, database software can be upgraded but the standby can not be opened until the primary is opened. When you upgrade 11g standby to 18c you end up with Oracle 18c software having an 11G database mounted. Oracle 18c can apply logs to a mounted 11G database but nothing else.  When the primary is upgraded, it's not opened by RESETLOGS, so the standby is usable. Database upgrade happens in the UPGRADE mode which is basically database open without system triggers firing. Upgrade process will upgrade the data dictionary using SQL and all block changes will be logged and sent to the standby. When standby applies them the standby database will be upgraded. You need to make sure that the "compatible" parameter is updated, too.

On 8/20/19 1:04 PM, Andrew Kerber wrote:
> 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_at_gmail.com
> <mailto:tim.evdbt_at_gmail.com>> 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_at_gmail.com>
>>> Date: 8/20/19 9:49 AM (GMT-05:00)
>>> To: ORACLE-L <oracle-l_at_freelists.org>
>>> 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
>>>
>>>
>>

--
http://www.freelists.org/webpage/oracle-l