RE: Recover from a dropped datafile

The database in also in NOARCHIVELOG mode..

-----Original Message-----

From: Ken Naim [mailto:kennaim_at_gmail.com] Sent: Monday, February 13, 2006 10:31 PM To: Ignizio, Richard
Subject: RE: Recover from a dropped datafile

Although I haven't worked on 7.3.4 in a long time you should be able to recover the data file, using the archive logs assuming the database is in archive log mode. Try issue the recover data file or tablespace command. You may have to offline the tablespace.

Ken Naim

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ignizio, Richard
Sent: Monday, February 13, 2006 9:26 PM
To: oracle-l_at_freelists.org
Subject: Recover from a dropped datafile

Hello,

I have a situation where a customer has "accidentally" dropped a datafile from a tablespace. The good news is that the datafile was empty since she just added it. The bad news is that there is no backup and it is a 7.3.4 database.

Is it possible to offline the datafile and open the database and some how move the data to a new tablespace?

Thanks,
Rich

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 13 2006 - 21:32:27 CST