Help: restore accidental deleted data from cold backup

[Quoted] One of the developers accidentally deleted some data two weeks ago and we need to restore it. We do cold backup(w/archive) once a week. So basically we can restore a two-week old copy to a different server and retreive the data back. We can't restore to the existing database since we will lose 2 weeks data and we don't want any downtime.

The database is 300GB and there is one big table 250Gb located in four partition tablespaces. I DON'T NEED to restore data from this big table. My question is: Can I simply restore the remaining 50GB datafiles? I understand that Oracle won't open if some files are missing. But can I have Oracle logically drop the 250GB tablespace/datafiles after "startup mount" and before "database open"?  Anyone has experience?

Thanks,
ewong Received on Wed Jun 12 2002 - 02:14:34 CEST