Re: flash it back then roll it forward(pitr)
From: jason arneil <jason.arneil_at_gmail.com>
Date: Wed, 3 Mar 2010 16:02:43 +0000
Message-ID: <fda4898f1003030802l3b9be0bdv9fa75edc269cbf12_at_mail.gmail.com>
Hello Patrick,
Date: Wed, 3 Mar 2010 16:02:43 +0000
Message-ID: <fda4898f1003030802l3b9be0bdv9fa75edc269cbf12_at_mail.gmail.com>
Hello Patrick,
Been testing flashback a bit recently so when I saw your email thought I would test. Tested this with 10.2.0.4 on linux, and yep you definitely can flashback and then roll forward, I did a recover database until change to roll forwards again.
As Freek pointed to open read-write a flashed back database you need a resetlogs, but of course you can open read-only without this.
Once you have flashed back you can even use flashback database to "flash forward" and undo your flashback.
jason.
-- http://jarneil.wordpress.com On 3 March 2010 15:29, Patrick O'Brien <pobrien_at_controller.state.nv.us> wrote:Received on Wed Mar 03 2010 - 10:02:43 CST
> Hello Oracle users,
>
> is it possible to flashback a database then turn around and roll it forward
> using a pitr process?
>
> thank you!
>
>
-- http://www.freelists.org/webpage/oracle-l