1. Flashback and Database Point-in-Time Recovery (Comming Soon)

Point-in-Time Recovery (DBPITR)

To reverse unwanted database changes you can use point-in-time recovery, in which you restore the database from backup and then apply redo logs to recreate all changes up to a point in time before the unwanted change.

• Can return selected objects or entire database to their earlier state.
• Entire database is unavailable during point-in-time recovery process.
• Point-in-time recovery can be time-consuming, because all datafiles must be restored, and redo logs and incremental backups must be restored from backup and used to recover the datafiles.

If you know the name of tablespace, tablespace point-in-time recovery (TSPITR) can return tablespaces to an earlier SCN while the unaffected tablespaces continue to be available.

Related Articles

1. FlashBack Database Technology [Part-1] [Introduction]
2. FlashBack Database Technology [Part-2] [Set up and Maintain flashback database]
3. FlashBack Database Technology [Part-3] [Set up and Maintain Restore points]
4. FlashBack Database Technology [Part-4] [Flashback Database]
5. FlashBack Database Technology [Part-5] [Flashback and Database Point-in-Time Recovery (Coming Soon)]