Re: Move of a database from Solaris to AIX server

  • From: Bob <orcl@xxxxxxxxxxx>
  • Date: Tue, 14 Nov 2006 19:43:12 -0500

Hi Anurag

This is called "Platform Migration"

High level overview

The source database needs to be the same version as the target
If the Endian  is the same for each platform then you useTTS
If the Endian is different, you need RMAN to convert the datafiles along with TTS NFS mounts of the target are a big help and could be quicker (& more logical) than FTP

On and enterprise system this isnt trivial undertaking.
You will have to estimate the outage needed by doing benchmarks before the actual migration.

Then you need to think about any application code, utl_file directories etc

Here is someone elses overview  - with options

http://www.dbasupport.com/oracle/ora10g/transportable_tablespace01.shtml

But thats it in the nutshell


Bob

--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."



Anurag Verma wrote:

Hi All,
Can we move a Oracle 9i (9.2.0.7 <http://9.2.0.7>) database from a Solaris 9(64 bit server) server to an AIX 5.2 (64 bit) server, by using RMAN backup/restore/recovery?? Anurag


Other related posts: