Re: higher version Standby database?
- From: George Leonard - Business Connexion <George.Leonard@xxxxxxxxx>
- To: "jack@xxxxxxxxxxxx" <jack@xxxxxxxxxxxx>
- Date: Tue, 15 Jul 2014 04:48:24 +0000
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@xxxxxxxxx<mailto:george.leonard@xxxxxxxxxx>
Web: http://www.bcx.com<mailto:george.leonard@xxxxxxxxxx>
[cid:6EA60917-E50D-422D-BF1F-E8C59EADC861]
On 27 Jun 2014, at 7:00 AM, Jack van Zanen
<jack@xxxxxxxxxxxx<mailto:jack@xxxxxxxxxxxx>> 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@xxxxxxxxx<mailto: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<mailto: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<mailto: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:
