Re: higher version Standby database?

From: Chen Zhou <oracle.unknowns_at_gmail.com>
Date: Thu, 26 Jun 2014 21:25:19 -0700
Message-ID: <CAJUY3dSDHtiGgSMUJB+yra1OaNpgfBKG38LGCfhPsdtb4KT4kQ_at_mail.gmail.com>

Hi,
Thank you everyone for your suggestions. Jack,
The situation is the primary is at lower version (10.2.0.4 RAC) and the standby was created using a higher version binary (10.2.0.5). Ian,
The preliminary test in Dev shows the application works with 10.2.0.5. So the application probably works with 10.2.0.5. It seems to me recreating a 10.2.0.4 standby and upgrade at a later time is a safer approach in this case. I will pass your suggestions on to my colleague.
Thank you,
Chen

On Thu, Jun 26, 2014 at 3:45 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:

> I don't see how the standby database can be 10.2.0.5.
>
> Most likely the standby database is same version as the primary but just
> running from the 10.2.0.5 home.
> I am fairly certain no patches will have been applied to the standby
> database itself (how could it?)
>
> I have no RAC experience so am not entirely sure how much wrok this is,
> but this would be my steps.
>
> Take full offline backup of standby
> Install oracle 10.2.0.4 home next to the 10.2.0.5 home.
> Start the standby from the 10.2.0.4 home.
> Switchover.
> Plan upgrade for a later date when you are in less of a hurry. As extended
> support for 10G ends next year I would suggest 11 or maybe even 12
>
> Jack
>
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>
> On Fri, Jun 27, 2014 at 3:07 AM, Chen Zhou <oracle.unknowns_at_gmail.com>
> wrote:
>
>> Hi, Everyone,
>> A colleague of mine asked me if I knew what to do in this situation. We
>> have a 10.2.0.4 RAC system that needs to be migrated to better servers.
>> Because of other issues with the primary database, one hurried decision led
>> to anther, yet another, the end result is he ends up having a 10.2.0.5
>> standby RAC database now. The goal is to activate the standby and retire
>> the primary database/servers. However with the primary at 10.2.0.4 and
>> standby at 10.2.0.5.12 with some additional patches, both of us don't know
>> what is a safe and sure way to migrate in this situation.
>> Redo the standby would be the last choice due to time-constraint and the
>> stressed-out primary database.
>> Thank you in advance for sharing your thoughts.
>> Chen
>>
>
>

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

Received on Fri Jun 27 2014 - 06:25:19 CEST