Results 1 to 6 of 6

Thread: Recover BD

  1. #1
    Join Date
    Jul 2005
    Posts
    15

    Unanswered: Recover BD

    Hi!
    I've a very big problem.
    I had a db and my computer has broken. I could recover all the files of the db (.DAT,...) How can I do Oracle to recognize my db?
    Please I need help!!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Explain a little further about the "Computer has Broken" ...
    Did you restore from an old backup? Did you have to replace the physical
    machine? Did you have to replace the Drives? Do you have Oracle installed
    and if so, what version?

    Gregg

  3. #3
    Join Date
    Jul 2005
    Posts
    15
    I had to reinstall Windows and Oracle 9i. I'm working in the university and one virus deleted one file of windows booting, and the only one way to solve it was doing that. So, what can I do?

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You're going to have to rebuild the Service/Instance
    ... Oradim utililty (oracle_home\bin)
    Then, depending on whether or not you have all the redo logs and archive logs available and they are not corrupted, recover the database based on
    the controlfiles.

    You can run the Oracle Database config assistant and save to file (instead
    of creating a new database). Cut and paste the results into a command prompt window.

    Take the last good trace file from the controlfile and cut/paste the commands
    from it. Read thru this carefully, there are 2 ways to do the recovery depending on the availability of the redo logs.

    HTH
    Gregg

  5. #5
    Join Date
    Jul 2005
    Posts
    15
    Excuse me the files are .DBF,
    are DATOS01.DBF, DATOS02.DBF,DATOS03.DBF in these are the information
    I also have the control files CONTROL01.CTL,...
    also the users: USERS01.DBF
    and I have another file with the indexes of the db INDICES01.DBF
    Please help

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Was your backup done with the database up or down? was the database in archive log mode. For more information on performing a manual recovery, see

    http://download-west.oracle.com/docs...ov.htm#1004644

    You will need your control files, redo logs, and datafiles.
    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
  •