Recover Database

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?

shanthiavari
Profile Answers by shanthiavari Questions by shanthiavari
Jun 10th, 2008
3
2457

Questions by shanthiavari

Database Administration

Answer

Showing Answers 1 - 3 of 3 Answers

vijaykaushik
Profile Answers by vijaykaushik

Dec 31st, 2008

This can be easily done but you will loose the data if you don't restore from backup.

If you have a backup of datafiles and controlfile then restore them.

If you don't have the backup then you need to use
alter database create datafile 'new_filename.dbf' as 'original_lost_filename.dbf';

Regards,
Vijay Kaushik