Re: Complete recovery
Date: Thu, 02 Jul 2009 12:10:08 +0200
Message-ID: <20090702101008.11970_at_gmx.net>
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_at_gmail.com>
> An: oracle-l_at_freelists.org
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 02 2009 - 05:10:08 CDT