Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006

    Unanswered: Help on Restore Oracle 9i DBF files into Windows XP server

    Dear All,

    Not sure if this topic has been discussed before but I dont seem to be able to locate any when i perform a search.

    Can any experts kindly guide me on the followings:

    1) I have just installed Oracle 9i ver 9.2.0 into a Window XP Server. Everything went smoothly so this is not an issue. The controlfiles, redo files, system01.dbf etc were created.

    2) I have to restore the DBF files into the new database, how am i going to restore the data to the database? Can anyone show me the process?

    3) Actually the DBF files were copied from another XP server. I have stopped the Oracle services and zip up the file and move it to the new XP server. (is this the right way?)

    I'm really kinda stuck here so would really appreciate some form of help here. Many Thanks.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    If you moved EVERY required file into the exact same location on the new server, then just open the database.
    It won't know it resides on a different system.
    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.

  3. #3
    Join Date
    Feb 2006
    Hi Thanks for the hint.

    So which means I will need to know the EXACT path of all the datafiles which were residing in the other server?

    Do I need to make the database off-line 1st?

    Thanks again.

Posting Permissions

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