Results 1 to 3 of 3

Thread: Recovery

  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: Recovery

    Is it possible to recover the oracle databases with just the main oracle folder and all the data in it in hand?
    The laptop on which oracle server was installed, crashed. so now we have in hand the base oracle installation folder with the data. Is it possible to get the databases working?
    No, there were no backups taken whatsoever.

    I am a sql server guy so have no idea how oracle works. Any input would be helpfull.
    Thanks a bunch.

    Harshal.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As long as you are waiting for a true Oracle DBA to appear, and if you have some time to spare, you might try this:
    - save Oracle database files to a safe place (another folder, DVD or similar); they should be in a folder like "C:\oracle\product\10.2.0\oradata\ora10g". Those are data files, redo log and control files.
    Also, you might want to save INIT.ORA file (in order to substitute newly created one if necessary).
    - create another Oracle database at the same place where the previous one existed (into the same folder).
    - overwrite newly created database files with the saved ones
    - restart the database

    Now, this *might* work ... if it won't, come back and explain what happened. I guess we'll somehow find the solution.

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Thanks a lot for the help littlefoot. It was taken care of by DBA.. THanks a lot for the reply.

Posting Permissions

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