Re: back to the future

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 15 Mar 2005 20:59:11 -0000
Message-ID: <42374c76$0$10944$cc9e4d1f@news-text.dial.pipex.com>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message 
news:g-idncNHSJd2jarfRVn-jA_at_comcast.com...

> ok, help me understand this one...
>
> from EM, 'Configure Recovery Settings' page:
>
> "Specify how far back you wish to flash the database in the future"

Errm whilst I think GreyBeard's analysis is correct consider this.

The mythical junior dba carries out an unfortunate update at 2:30pm. At 3pm it is brought to your attention that things are up the proverbial creek.
You ask the junior guy when he carried out his update. He says 2pm. You flashback the database to 2pm.
You discover your error. How do you recover?

the answer, apparently, is by issuing a second flashback command. to a future time from the database timestamp of 2pm.

So you can travel into the future, but only after you've already been there.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com 

Received on Tue Mar 15 2005 - 14:59:11 CST