-
moving oracle from solaris to AIX
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.
-
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?
-
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.
-
export/import??
logical standby??
replication??
depends what you want to do.
Jeff Hunter
-
I wanna go ahead with export/import.
But how to start working this project? Any idea ?
-
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 .
-
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
-
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
-
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?
-
cant mix files between OS's old chap
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|