Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2013
    Posts
    2

    Red face Unanswered: move database oracle 9i from old server to another server

    hi
    I want to work formate the server and then re-install the Oracle database 9i new
    While taking a Cold backup server before work formate
    How to re-install version database as it was before the work formate Server.
    thanks.
    i need steps to do that.

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    After you have installed the Oracle software create a new (empty) database, then import from your backup.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2013
    Posts
    2
    hi
    thanks
    Indicate below what I will do
    1 File ( oradata ) Copy from the file oracle before format server
    2 taking a copy export from database
    3 formate server 2003
    4 install Oracle 9i empty data with the same sid oracle
    5 import
    Is this steps true or not.
    Or the file copy ( oradate) should be placed in the new version of Oracle

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle 9i has been obsoleted & unsupported this whole Century.
    Please join the 21st Century at your earliest convenience.

    How is it that you are willing to upgrade server Hardware & OS but not Oracle version?
    Last edited by anacedent; 01-08-13 at 11:36.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    I agree with anacedent, if you have maintenance from oracle you are entitled to upgrade to the newest version free of cost. However I understand there are times that you can't.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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