Re: Standby First upgrades

But why would I open a standby? He was asking about upgrading it, not opening it. When an 11G standby is upgraded to 18c, you end up with Oracle 118c mounting an 11G database. You can not open it. I believe that the goal of the exercise is to have standby immediately available after the upgrade of the primary.

On 8/20/19 12:50 PM, Tim Gorman 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