Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restoring database on a different machine

Re: Restoring database on a different machine

From: Jeremy Paul Schneider <jeremy.schneider_at_ardentperf.com>
Date: Wed, 25 Apr 2007 16:26:57 -0500
Message-ID: <18be0f260704251426p4f049beod93856b119785bde@mail.gmail.com>


Sorry, I didn't read the question closely enough. I don't know about using a 64-bit ORACLE_HOME to create a physical standby for a database created on a 32-bit ORACLE_HOME. But as Andrew pointed out you can always just use the 32-bit binaries on your 64-bit server.

On 4/25/07, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
>
> Do you see any reason? I think the recovery could fail only if there is
> a difference in the format of archivelogs generated from 9.2.0.4 32- bit
> and 9.2.0.4 64-bit or there is a difference between recovery mechanisms
> between 32 and 64-bit which is very unlikely. Is there anything else as
> well that may affect?
>
> Thanks
>
> -----Original Message-----
> From: Kerber, Andrew W. [mailto:Andrew.Kerber_at_umb.com]
> Sent: Thursday, April 26, 2007 1:10 AM
> To: Ankur Godambe; oracle-l_at_freelists.org
> Subject: RE: Restoring database on a different machine
>
> I am thinking that you cannot set up a standby database that way, you
> may have to create a 32 bit standby instance...
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ankur Godambe
> Sent: Wednesday, April 25, 2007 1:51 PM
> To: oracle-l_at_freelists.org
> Subject: Restoring database on a different machine
>
> Hi,
>
> I have got a production 9.2.0.4 32-bit database on Redhat AS3. One of
> the local disks having dbfs has crashed; the server is not under
> warranty and looks like we will not be able to recover from the failed
> hardware. Fortunately we have disks with RAID5 and the db is still up
> but of course with degraded performance. To move the whole database with
> minimum downtime to a new machine I have planned to create a standby
> from backup, apply archives and switchover. I guess that's the most
> efficient way to reduce the downtime. The problem here is that the new
> sever is running with 64-bit Redhat AS4. Can this be used for restoring
> the dbfs and then switchover? The difference is 32-bit v/s 64-bit and
> AS3 v/s AS4. I will be installing the same version of database (9.2.0.4)
> but 64bit on new machine. Will restoration between 32-bit and 64-bit
> create a problem? Has someone faced similar problem or restored database
> between 32-bit and 64-bit with different OS version?
> Unfortunately, I cannot test it because of time constraint. Any advice
> would be helpful.
>
> Thanks,
> Ankur
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> ------------------------------------------------------------------------
> ------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the
> individual or entity intended as the recipient. If you are not the
> intended recipient, any use, copying, printing, reviewing, retention,
> disclosure, distribution or forwarding of the message or any attached
> file is not authorized and is strictly prohibited. If you have received
> this electronic mail message in error, please advise the sender by reply
> electronic mail immediately and permanently delete the original
> transmission, any attachments and any copies of this message from your
> computer system. Thank you.
>
> ========================================================================
> ======
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 16:26:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US