Re: Recovering Dropped Tables with no Backup

Tom Hoffmann <trh411_at_earthlink.net> wrote in message news:Xyth9.1242$c87.121055_at_newsread2.prod.itd.earthlink.net...
> On Mon, 16 Sep 2002 10:29:43 -0400, Sybrand Bakker wrote:
>
> > tholden8_at_hotmail.com (Tom Holden) wrote in message
> > news:<13773e73.0209160219.2afcfbc5_at_posting.google.com>...
> >> In NOARCHIVELOG mode, Suppose you have no Backups (Cold or Hot) and a
> >> user drops a table. How can we recover the table? I would think not.
> >> Someone asked me this question and he said he had been told in an
> >> interview that it can be done.
> >>
> >> As far as i know, drop and truncate information is not stored in
> >> redolog files.... So Logminer should not help... Am i wrong?
> >>
> >> Also drop and truncate information is not stored in RBS, so even with
> >> 9i Flashback dropped tables cannot be recovered. Am i wrong?
> >>
> >> Is there some way a dropped table can be recovered?
> >>
> >>
> >> Thanks for any clarification,
> >> Tom
> >
> >
> > This is exactly why one should make recurring exports.
>
> Even for an instance with ARCHIVELOG mode on?

Yes, exports are fine until they take 3, 4, ... days to complete. Received on Tue Sep 17 2002 - 08:31:50 CDT