Re: higher version Standby database?
Date: Fri, 27 Jun 2014 08:45:09 +1000
Message-ID: <CAFeFPA-Cu9b6ZJN53iTvxE0WCYDc9r2NnWBymKscM=Me259t1g_at_mail.gmail.com>
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-lReceived on Fri Jun 27 2014 - 00:45:09 CEST