move database from one server to another
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: move database from one server to another

  1. #1
    Join Date
    Sep 2004
    Posts
    18

    move database from one server to another

    Hello,

    I have to move a 9i database from one server to another. Can somebody provide me the steps to accomplish this task?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Do you know how to install Oracle on the new server?
    Good, install it.

    Do you know how to back up your database?
    I hope so. Back it up and restore the database on the new server.
    Then start the database. If you are installing on Windows you will need to create a service, which you can do at the dos level. On Unix you have to put the right files in the /etc directory. You can find this in the before you install guide for your platform.

    Then configure your listener. Of course you don't mention what version of os you are running, whether or not you are changing Oracle versions and what they are. Unless your database is huge, it should be a simple thing to move the database.

  3. #3
    Join Date
    Sep 2004
    Posts
    18
    Thanks. It is on HP-UX.

    I was thinking I do it this way. After installing oracle 9i on the new server, create datafiles in the new server like the one in the other server. Then take an export file of the old one and import int into the new server.

    correct me if i am wrong.

  4. #4
    Join Date
    Sep 2004
    Posts
    18
    >>create datafiles

    typo, i meant to write tablespaces

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    IMHO, the easiest way to do it is:
    1. install oracle software on new server
    2. shutdown db on old server
    3. copy all database files
    4. startup db on new server
    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."

  6. #6
    Join Date
    Sep 2004
    Posts
    18
    Thanks Marist89,

    Before I copy all databasefiles from old to new server, dont i have to create tablespaces ?

    correct me if i am wrong.

  7. #7
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    No, your database files (*.dbf) will contain all the tablespace information you need. Perhaps you're confusing tablespaces with data files themselves?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    By copying over the datafiles, redo logs, init file, etc. you are moving your database. you might need to recreate the password file, and you will need to set up the listener. But that is it.

  9. #9
    Join Date
    Sep 2004
    Posts
    18
    I thank one and all for their advice here. From all your views, i am going to do these steps on HP-UX. Hope i am correct.

    Backup controlfile using trace option on Source Database.
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
    Shutdown the original database.
    Copy all datafiles, redolog files, init.ora files to the other server location.
    Setup listener for the new instance.
    Start the listener
    Edit the create controlfile with the path of datafiles and redolog files placed on the new server/location
    svrmgrl> connect internal;
    svrmgrl> @create_controlfile_script;
    statement processed
    svrmgrl> alter database open resetlogs;

    Hope I am correct !!

    any inputs??

  10. #10
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Originally posted by surnag
    I thank one and all for their advice here. From all your views, i am going to do these steps on HP-UX. Hope i am correct.

    Backup controlfile using trace option on Source Database.
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
    Shutdown the original database.
    Copy all datafiles, redolog files, init.ora files to the other server location.
    Setup listener for the new instance.
    Start the listener
    Edit the create controlfile with the path of datafiles and redolog files placed on the new server/location
    svrmgrl> connect internal;
    svrmgrl> @create_controlfile_script;
    statement processed
    svrmgrl> alter database open resetlogs;

    Hope I am correct !!

    any inputs??
    Backing up the controlfile to trace is a good way to see where all of your files are and to make sure that you get them. However you should not need to either recreate the control files or do a resetlogs. In fact you should not do either since you are doing a cold backup.

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