Help: restore accidental deleted data from cold backup

From: Ed Wong <ewong_at_mail.com>
Date: 11 Jun 2002 17:14:34 -0700
Message-ID: <a5ae1554.0206111614.586d1d2@posting.google.com>

Hi,

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 Tue Jun 11 2002 - 19:14:34 CDT