RE: database migration

From: Michael Fontana <mfontana_at_enkitec.com>
Date: Tue, 10 Feb 2009 12:09:18 -0600 (CST)
Message-ID: <390810.13491234289358245.JavaMail.root_at_mail.enkitec.com>

I think we are slightly moving off-topic here. The original poster wanted to compare the various speeds of the methodologies, not if the methodologies themselves were do-able.  

Using RMAN may or may not represent a time-savings from his original intended purpose - to move the data fast with minimal downtime - because it will REQUIRE you to keep the source database tablespaces in READONLY mode while they are:  

1. Being Backed up
2. Being moved across a network, perhaps
3. Being restored to a new target.

Since an endian change is being made, archive log application methodology is out of the picture.      

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, February 10, 2009 11:29 AM To: haroon_a_qureshi_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: database migration  

If you are on Oracle 10gR2, it is more easily to convert the database across platforms using RMAN. I have done this quite few times and succeeded.  

Regards,  

Jaffar  

On Mon, Feb 9, 2009 at 12:09 PM, Haroon A. Qureshi <haroon_a_qureshi_at_yahoo.com> wrote:

Hello,

We are doing a database migration from AIX to Linux. Our database is 600gb. Has anyone used the rman convert database method to migrate the database? Do you have any timings you can share, especially compared to expdp/impdp? Unfortunately, I don't have the luxury of time to try it out myself.

Thanks in advance!
Haroon
--

http://www.freelists.org/webpage/oracle-l

--

Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:12 6
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region (http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/

---

"Winners don't do different things. They do things differently."

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 10 2009 - 12:09:18 CST