Re: Help with recovery

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 29 Apr 2004 05:32:33 GMT
Message-ID: <Rr0kc.126875$e17.55077@twister.nyroc.rr.com>

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0404281547.6729a3d0_at_posting.google.com...
> kevinmmcgowan_at_yahoo.com (Kevin) wrote in message news:<288965ad.0404280845.37533c29_at_posting.google.com>...
> > I need to restore a table to its state this morning. Unfortunately,
> > don't have any exports recently and would essentially like to rollback
> > everything previous to 945 this morning. It looks like I can
> > accomplish this using the RECOVER command (yes, I understand I'm going
> > to have to recover the whole database, I can deal with that). I just
> > want to make sure there's nothing else I need to do besides RECOVER
> > DATABASE UNTIL TIME '2004-04-28:09:00:00'
> >
> > Thanks in advance
>
> Don't forget to post platform and version info. 10g has flashback
> table command, but requires some configuration and thought to be able
> to go back more than 15 minutes. It's kind of the opposite of archive
> logging.
>
> jg
> --
> @home.com is bogus.
> "How many people here are using RAC?"
> 2 people raise hands, out of ~70 DBA's.

Even in 9i you can recover table contents if you have set your flashback.

The following is from 9.2.0.3.:
SQL> select oid from xmltest;

OID

9 rows selected.

SQL> delete from xmltest;

9 rows deleted.

SQL> commit;

Commit complete.

SQL> create table recover_xmltest as select * from xmltest where rownum < 1;

Table created.

SQL> insert into recover_xmltest select * from xmltest as of timestamp (systimestamp - interval '30' minute);

9 rows created.

SQL> commit;

Commit complete.

SQL> select oid from recover_xmltest;

OID

9 rows selected.

Anurag Received on Thu Apr 29 2004 - 00:32:33 CDT