Re: higher version Standby database?
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: Chen Zhou <oracle.unknowns@xxxxxxxxx>
- Date: Fri, 27 Jun 2014 15:00:13 +1000
the standby does not really get created. It is simply a bunch of files that
get logs applied to it.
In this case the files are all still 10.2.0.4 as the primary is leading
here and the logs are applied by 10.2.0.5 binaries. So to recreate the
standby you should simply be able to install the 10.2.0.4 version and start
the apply from the 10.2.0.4 home. You may have to do some magic with the
RAC setup, but that is outside my comfort zone.
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 2:25 PM, Chen Zhou <oracle.unknowns@xxxxxxxxx>
wrote:
> 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@xxxxxxxxxxxx> 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@xxxxxxxxx>
>> 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
>>>
>>
>>
>
Other related posts:
