Re: Complete recovery
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: giantpanda@xxxxxxx
- 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!
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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
