Re: Recovering Dropped Tables with no Backup

"David Van Zandt" <dvanzandt_at_iquest.net> wrote in message news:<5%Rh9.156$Cz2.24346_at_news.iquest.net>...
> Quick! Find and hire that candidate -- after he or she has demonstrated such
> an amazing technique. No archive logs, no backups WHATSOEVER; what ITNOATH
> are you going to recover from?
>

When i said 'he had been told in an interview', i meant the friend was interviewed by someone who asked if it can be done. When my friend said it cant be done (as any normal person would), he was assured by the interviewer that it can be done! Now that interviewer could been looking for the reaction he would get by his statement or he may have been an idiot....

Thanks to everyone for assuring me i was right.

Tom.

> And for the sake of a smile, has your site tested its DR plan lately?
>
> Lots of luck, Tom. I don't envy you in this....
>
>
> "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?
Received on Thu Sep 19 2002 - 03:28:37 CDT