[Translated from mos] monitors the progress of the flashback database,

[Translated from mos] monitors the progress of the flashback database,
Monitor the progress of the flashback database

Reference:
How to determine flashback database progress (Doc ID 1071391.1)

Applicable:
Oracle Server-Enterprise Edition-Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
* ** Checked for relevance on 26-Oct-2012 ***

Solution:
After the flashback database command is issued, the progress of flashback database cannot be seen from the v $ session_longops view, and the progress cannot be seen from alert.

Like media recovery, flashback database modifies the checkpoint_change # And checkpoint_time of the database file. Therefore, you can check these two columns in the v $ datafile_header view.

The first step of flashback database is to use the flashback log to approximate the specified scn or time.
The second step of flashback database is to use archivelog for fine-grained (fine_grained) close to precise scn or time.
This means that when flashback log is used, checkpoint_change # And checkpoint_time will be rolled back (go backwards ),
When fine-grained media recovery (step 2) is used, checkpoint_change # And checkpoint_time forward (go forward ).