recover datafile


My datafile has not been backed up physically..It is deleted accidently..
Is there any way to recover..
nobleitAsked:
Who is Participating?
 
manzoor_dbaCommented:


Ok, If you have all the archive log then you can use the below method, you can create a new datafile as the datafile which been corrupted and recover the new datafile.

Eg :-

datafile   E:\oradata\test01.dbf  is been corrupted , i dont have a phyiscal file backup of it but i have all the archivelog since it been created, create a new file as the corrupted one..

sql> alter database datafile 'E:\oradata\test01.dbf '  offline immediate;

sql> alter database create datafile 'E:\oradata\test01.dbf ' as 'E:\oradata\newtest01.dbf' ;

sql > recover datafile 'E:\oradata\newtest01.dbf' ;

sql > alter database datafile 'E:\oradata\newtest01.dbf'  online;

Hope the above helps..

Thanks..





0
 
gvsbnarayanaCommented:
Hi,
   Sorry to say, no backup means no way to recover. The only way is to build the data again.
Regards,
Badri.
0
 
gatorvipCommented:
I don't know if it's even possible and you'd most certainly need to contact a professional for this, but you can attempt a drive restore. Depending on how long it's been since the file was erased, they might be able to recover it.
0
 
manzoor_dbaCommented:
Hi,

Do you have all the archive log files since you db been put in archive log mode??
0
 
nobleitAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.