Hi, a complete recovery will restore the state of your database to the current time - after the table deletion. You need to do tablespace point in time recovery, see the Backup and Recovery Advanced User's Guide. http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtspit.htm This is tricky, you might want to do a point in time recovery of your whole database instead. Regards Ingrid -------- Original-Nachricht -------- > Datum: Thu, 2 Jul 2009 10:47:54 +0100 > Von: David Pintor <painterman@xxxxxxxxx> > An: oracle-l@xxxxxxxxxxxxx > Betreff: Complete recovery > Hi guys, > > ** Oracle 10.2 on Solaris 10 box. > > Someone removed a user table this morning. I have a cold backup from last > night. I want to restore just the USERS tablespace (where the table was) > and > perform a complete recovery. Is that possible? I've tried recovering the > datafile by stopping the database, copying the datafile manually, and then > doing a recover database. The recover is complete but my table is still > missing... what am I doing wrong? > > Thanks for your help. > > David -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 -- //www.freelists.org/webpage/oracle-l