This discussion is archived
2 Replies Latest reply: Nov 28, 2012 12:11 AM by moreajays RSS

unable to recover database

974375 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points