moving oracle from solaris to AIX
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: moving oracle from solaris to AIX

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,002
    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?
    this space intentionally left blank

  3. #3
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    export/import??

    logical standby??

    replication??

    depends what you want to do.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    I wanna go ahead with export/import.
    But how to start working this project? Any idea ?

  6. #6
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    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 .

  7. #7
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  9. #9
    Join Date
    Sep 2005
    Posts
    4
    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?

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width