Re: Restoring database on a different machine

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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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@xxxxxxx]
Sent: Thursday, April 26, 2007 1:10 AM
To: Ankur Godambe; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ankur Godambe
Sent: Wednesday, April 25, 2007 1:51 PM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: