RE: Restoring database on a different machine

From: <oracle-l-bounce_at_freelists.org>
Date: Wed, 25 Apr 2007 13:14:12 -0700
Message-ID: <F2B0430DD90A1C4383C1F887FBAC45DB0380D62B@kusex2.ketera.com>

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 Received on Wed Apr 25 2007 - 15:14:12 CDT