Re: Flashback Recovery

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 16 Apr 2007 22:23:19 +0200
Message-ID: <4623db30$0$13853$ba620e4c@news.skynet.be>

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:20h323lbs2ft3v7jk5me1uolvrqnudopea_at_4ax.com...
>2 questions
>
> a) can someone point to a source that descrives how the flashback area
> actually works
> b) did anyone ever had to 'flash back' a database in production? I
> really can't think of a scenario where it would be useful (since it
> forces you to lose
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> remove NSPAM to email

For example when you install a patch set and it fails ?

But for me, I never used it in a real production environment. I always managed to restore lost data by using recycle bin/flashback table/data pump import.

Matthias Received on Mon Apr 16 2007 - 15:23:19 CDT