Re: higher version Standby database?
Date: Tue, 15 Jul 2014 04:48:24 +0000
Message-ID: <8733850B-A37D-4FC1-9DE1-ACE7FC6D943F_at_bcx.co.za>
What happened here.
Question, is the DB home 10.2.0.5 or the RAC binary level.
if the RAC is at 10.2.0.5, try as below installing a 10.2.0.4 home, restarting the DR/standby out of there,
Yours Sincerely
George Leonard
Oracle Engineered System Specialist
Mobile: +27.82 655 2466
eMail: george.leonard_at_bcx.co.za<mailto:george.leonard_at_oracle.com>
Web: http://www.bcx.com<mailto:george.leonard_at_oracle.com>
[cid:6EA60917-E50D-422D-BF1F-E8C59EADC861]
On 27 Jun 2014, at 7:00 AM, Jack van Zanen <jack_at_vanzanen.com<mailto:jack_at_vanzanen.com>> wrote:
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_at_gmail.com<mailto:oracle.unknowns_at_gmail.com>> 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_at_vanzanen.com<mailto: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<mailto: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 Tue Jul 15 2014 - 06:48:24 CEST