Re: Copying DBs between heterogenous environments

From: HansF <News.Hans_at_telus.net>
Date: Tue, 03 May 2005 22:11:28 GMT
Message-Id: <pan.2005.05.03.22.13.50.644211@telus.net>

On Tue, 03 May 2005 15:01:37 -0700, dominica_at_gmail.com interested us by writing:

> Actually, my Oracle consultant know this.
> But I don't have details.
>
> He did it all the time for a BIG COMPANY (famous website).
> He migrate 200+ databases using this method to move
> from different Unix favor to another one.
> He work like a "CHARM" for him.

Works ike a CHARM as long as the file systems are compatible. Since OP is using raw disk, there are a number of conditions that must be watched - endian being the most important.

Best recommendation to handle the entire mess is pretty simple - use RMAN ...

Other than that, it's pretty simple to test this. use dd and see whether the target DB comes up on the other box.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Tue May 03 2005 - 17:11:28 CDT