Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unanswered: Copy entire DB to a new server - How to?

    Hi all.
    I learned Oracle about 2 years ago but never really had the chance to work with it, so now i'm not really able to work on it (i forgat allmost everything).

    The thing is, now (at my work place), i need to move a production Oracle 8i server (8.1.6) to a new server with the same Oracle version but different machine.
    the problems are:
    1. i dont remember how to.
    2. the database is 70 GigaByte (datafiles + Indexes). i dont think i can use Export/Import to do the job.
    3. i dont remember if the indexes shuld be recreate after doing the copy.
    4. i have the filling that i need to use a cold backup in order to copy the database, am i wrong?

    Please... Please... any answer or a directive of How-To will be allmost "A life saver..." :-)
    Thanks in advance,
    Makore.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Look here
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Feb 2005
    Posts
    2

    Thanks, I'll try it.

    Hi LKBrwn_DBA.
    Thanks for your reply, it looks like an easy job when it's described like that.
    regards,
    Makore.

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    I take it both servers run the same OS or you might have problems doing datafile copy.

    Alan

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    keep in mind you don't need the actual CONTROLFILES (just the backup-controlfile from trace). those will
    be created when you startup the new instance. Otherwise you
    will get an error when you attempt to startup.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •