Re: Complete recovery

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!

Niall

On Thu, Jul 2, 2009 at 11:10 AM, Ingrid Voigt <giantpanda@xxxxxxx> wrote:

> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: