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 >> > >