Moving a 9i database - Win2000 server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Moving a 9i database - Win2000 server

  1. #1
    Join Date
    May 2001
    Posts
    31
    I need to move a 9i database from one Win2000 server to another. The new machine is a mirror of the old one - identical directory structure, same version of Oracle. Can I simply copy all db files(dbf,log,control) from cold backup, create a service and start the instance. The name will be the same. Will I need recovery, reset logs, create controlfile. Most of the docs refer to changing dbname and/or file locations. Am I wrong in thinking I can just copy file, create service and start instance?

  2. #2
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    You are right.

    You can just restore from the cold backup and you wont require recovery in this case.

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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