2 Replies Latest reply: Nov 28, 2012 2:11 AM by moreajays RSS

    unable to recover database

    974375
      our hard disk got damaged and the OS was lost. i was having a drive image of c partition taken in 2009. i restored the image. later i realised that some of the files for oracle are present at E:

      this way, E: is having following files
      'E:\ORACLE9I\ORCL\SYSTEM01.DBF',
      'E:\ORACLE9I\ORCL\INDX01.DBF',
      'E:\ORACLE9I\ORCL\TOOLS01.DBF',
      these files are latest (13-Nov-2012).

      The files on the c: drive are very old, they are from year 2009
      C: is having following files

      C:\ORACLE9I\ORCL\REDO01.LOG
      C:\ORACLE9I\ORCL\REDO02.LOG
      C:\ORACLE9I\ORCL\REDO03.LOG

      C:\ORACLE9I\ORCL\UNDOTBS01.DBF
      C:\ORACLE9I\ORCL\DRSYS01.DBF
      C:\ORACLE9I\ORCL\USERS01.DBF
      C:\ORACLE9I\ORCL\XDB01.DBF
      C:\ORACLE9I\ORCL\USER02.DBF

      i have latest data in exported file(created on 12-Nov-2012). i can import the data after the database starts working.

      now how to make the database up and running again. can anyone help me by showing the steps. thanks in advance