Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004

    Unanswered: URGENT DataBase Recovery Problem

    Hi All

    There is a great problem in my office with the oracle online databases.
    The situation is...

    We are having online databases...
    The OS of the server got correpted. All the DBF files, Control Files, And redo logs are in the D:\ drive. where oracle software was installed in c:\ with OS.
    Our Database was in noarchiveLog mode. We formatted the C:\ drive and again loaded the OS. The OS was win2000 Server. And it is same now...

    We are having the hot back up of the database. And also an complete database export dump file. but these are 2-3 days old.

    Is it possible to get the database in the old possition? Can we use the files there in the d: drive.

    what is possible for us... Is hotBackUp is useless or the exported dump file is useless.

  2. #2
    Join Date
    May 2004

    If the OS got currupted, and that too all the database files are present in D:\ as u said there will not be any problem.
    you just install oracle as it was before and create the sid as the old database you can open the database


  3. #3
    Join Date
    Feb 2004

    How will it be done


    But somebody told me that as the old oracle sw is not there, all the data dictionary data is washed out. So will it happen that by just keeping the same sid it will pick up the old database.

  4. #4
    Join Date
    Apr 2003
    Minneapolis, MN
    The main point is you have to have a set of DBFs in consistent state. (in case of Cold backup). Then, ...
    install OS(Same version), install Oracle (The same version),
    create SID , start instance (in NOMOUNT state),
    CREATE controlfile, OPEN DATABASE using RESETLOGS option (which creates logfiles/groups).

    you will have the lod database ready to work.

    MS Computer Science
    OCP DBA 9i/8i

  5. #5
    Join Date
    Aug 2003
    How did you do a hot backup if your database was in noarchive log mode?

    If you truely did this (I'm assuming OS level copy, not RMAN), then it's worthless.

    Use your export file.

Posting Permissions

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