Re: Standby First upgrades
Date: Tue, 20 Aug 2019 12:04:47 -0500
Message-Id: <FB6E9402-C95F-4B5D-8FA0-5C6590D900B1_at_gmail.com>
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> 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-lReceived on Tue Aug 20 2019 - 19:04:47 CEST