Flashback
Flashback database and backup scenario: ------------------------------------------------ If you flashback a database to a GRP (Guaranteed Restore Point) that has been set in the database, all backups that were taken after the GRP was created can no longer be used. You can however restore the database to a point in time prior to the GRP creation. SQL> shutdown immediate startup mount flashback database to restore point TEST; Total System Global Area 384143360 bytes Fixed Size 2154016 bytes Variable Size 301990368 bytes Database Buffers 75497472 bytes Redo Buffers 4501504 bytes Database mounted. SQL> Flashback complete. SQL> alter database open resetlogs; Database altered. Now you can restore and recover the database from any backup taken BEFORE the GRP was created. See below: Recovery Manager: Release 11.1.0.7.0 - Production on Thu Dec 2 11:03:52 2010 Copyright (c) 1982, 2007, Oracle. All rig