recover datafile


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

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.