Monitor the progress of flashback database
Reference from:
How to determine FLASHBACK DATABASE PROGRESS (document ID 1071391.1)
Suitable for:
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:
when the Flashback Database command is issued, the progress of the flashback database is not visible from the V$session_longops view, and the progress is not visible from the alert.
like media recovery, flashback database modifies the checkpoint_change# and checkpoint_time of the database file, so you can get from V$datafile_ Check out these two columns in the header view.
The first step in flashback database is to use flashback log to approximate the specified SCN or time.
The second step of flashback database is to use Archivelog to fine-grained (fine_grained) close to the exact SCN or time.
This means that when using flashback log, checkpoint_change# and Checkpoint_time will be back (go backwards),
when using fine-grained media recovery (the second step), checkpoint_change# and checkpoint_time advance (go forward).
"Translated from MOS article" Monitoring the progress of flashback database
