Incomplete recovery, or point-in-time recovery, uses a backup to produce a noncurrent
version of the database. In other words, you do not apply all of the redo records
generated after the most recent backup. You usually perform incomplete recovery of
the whole database in the following situations:
■ Media failure destroys some or all of the online redo logs.
■ A user error causes data loss, for example, a user inadvertently drops a table.
Page 296 of 542 shows:
When to Use Oracle Flashback
Flashback Table is a push button solution to restore the contents of a table to a given
point in time.
Page 297 of 542 continues:
Flashback Database and Flashback Table differ in granularity, performance, and
restrictions. For a primary database, consider using Flashback Database rather than
Flashback Table in the following situations:
■ There is a logical data corruption, particularly undo corruption.
■ A user error affected the whole database.
综上可看出,若table的一部分错误updated,应用Flashback,若整个table被错误drop掉,可用point_in_time recover来恢复。
|