Track Progress of Database Restore

Find out the name of the restore point
1* select name,time from v$restore_point
SQL> /

NAME TIME
------------------------------ ----------------------------------------
JULY_01_2013 01-JUL-13 08.30.29.000000000 AM

SQL>

Startup the database in mount state
SQL> Shutdown immediate
SQL> startup mount

SQL> flashback database to restore point JULY_01_2013 ;


NOW, Track the Progress of the restore using

SQL> select sid,message from v$session_longops where sofar <> totalwork ;

SID
----------
MESSAGE
--------------------------------------------------------------------------------
1173
Flashback Database: Flashback Data Applied : 43160 out of 52292 Megabytes done


SQL>