moving oracle from solaris to AIX

[zakriyamhd]

hi!

i have been asked to move the present oracle 9.2.0.5 production db from solaris to aix box.

Aix box is very new nothing on it, any idea how to do this.

Plz guide me.

[gandolf989]

How large is your database? How much downtime do you have to move the database? Are you using RAC, Replication, Standby server? Are you going to move the data, conduct stress test on the new database, and then move the data again to go live?

[zakriyamhd]

My database size is 150 gigs, used only for reporting purposes so downtime is acceptable (on weekends is ok), Not on rac or replication OR Standby .Only one instance which is up and running 24hrs.

One procedure to go ahead , I dont even know how to approach this.

[marist89]

export/import??

logical standby??

replication??

depends what you want to do.

[zakriyamhd]

I wanna go ahead with export/import.
But how to start working this project? Any idea ?

[zakriyamhd]

guys any procedure or docs to start working on this project? Can you suggest me from where to start working on this? Like any step by step by procedure .

[fraze]

Check out the Utilities documentation for all the details on export/import

http://download-west.oracle.com/docs...a96652/toc.htm

Very high level process would be something like:

Create empty DB on target OS
Full, consistent export of source database
Copy export file to target OS
Do full import on target OS

There are a few different ways to handle the "create empty DB" bit so this discussion might help you:

http://asktom.oracle.com/pls/ask/f?p...D:550622776061

HTH

[pando]

export/import is may be the way to do it

logical standby can be an option as well

I would not use replication, setting replication for hundreds of tables can be tedious

the other option, probaly not considered by you but can be fun is, upgrade to 10gR2 and transport all the tablespaces

[ritesh_das]

Is it not possible to put all the tablespaces in begin backup and copy all the files from solaris to aix... and apply the archives?

Or since down time is acceptable in the weekend... a cold backup of the source database... and use the files to create aix db? ... would these files be still valid across plat forms?

and what about RMAN backed up files?

[davey23uk]

cant mix files between OS's old chap