Move Database Instances to a different box
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Move Database Instances to a different box

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello DBAs

    Oracle Version: 8.1.7.1
    IBM: Aix 4.3.3 RS/6000

    We have about 7-8 oracle instances in a development box across multiple filesystems (about 6 or 7) and we are planning to move about 5 of them to a different box.
    All these instances are development, and are avaeraging about 6GB per instance (max of 30GB).

    What are the pre-cautionary measures to take and steps required to accomplish this?

    If I shutdown the database instances (normally) and take an instance (1 instance) and have all the physical structure from different filesystems, move to another box, (new filesystems) transfer init.ora, listener.ora and few other important files is it enough to open the database on the new box. If yes, how will the control file identify new filesystems? If no, what is the solution?

    Thanks, ST2000

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    If OS, and Oracle Rel are same between dev box and the new dev box, use Transportable Tablespace option of export. It is simple, and easy.

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Thanks Tamil:

    Please read below..

    I don't have similar instances in the new box. It has 2-3 instances. I want to be able to move entire instance as is to the new box, reducing the number of instances in present box. Suggest me, where I should be able to move much of it in all aspects. I don't want to be using exports as well..

    Thanx, ST2000

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