Re: flash it back then roll it forward(pitr)

From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
To: po04541@xxxxxxxxx
Date: Thu, 04 Mar 2010 10:21:16 -0500

Patrick,

If you open the database with RESETLOGS after you flashback thedatabase, you can still do PITR (recover database until time).You just need to flashback the database again using FLASHBACK DATABASETO BEFORE RESETLOGS.

1. Flashback the database;
2. Open it with "RESETLOGS";
3. Test it;
4. Flashback the database with "TO BEFORE RESETLOGS";
5. Recover the database with "UNTIL TIME";

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr005.htm#BABHGDDE

--
Alisher Yuldashev
Senior Oracle DBA
www.pythian.com

    On 3 March 2010 15:29, Patrick O'Brien
    <pobrien@xxxxxxxxxxxxxxxxxxxxxx
    </mc/compose?to=pobrien@xxxxxxxxxxxxxxxxxxxxxx>> wrote:
    > Hello Oracle users,
    >
    > is it possible to flashback a database then turn around and roll
    it forward
    > using a pitr process?
    >
    > thank you!

--
//www.freelists.org/webpage/oracle-l

References:
- RE: flash it back then roll it forward(pitr)
  - From: patrick obrien

Re: flash it back then roll it forward(pitr)

Other related posts: