Re: Complete recovery
Date: Thu, 2 Jul 2009 11:26:33 +0100
or if you are lucky and still have the undo from the relevant period
create table temptab
as select * from user_table as of 'before the deletion';
then verify the contents of temptab before an insert select.
flashback query is a good thing!
On Thu, Jul 2, 2009 at 11:10 AM, Ingrid Voigt <giantpanda_at_gmx.net> wrote:
> a complete recovery will restore the state of your
> database to the current time - after the table
> You need to do tablespace point in time recovery,
> see the Backup and Recovery Advanced User's Guide.
> This is tricky, you might want to do a point in time
> recovery of your whole database instead.
> -------- 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
> > 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
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 02 2009 - 05:26:33 CDT