Thanks for the info...noted that.
But my question derived from the EM Console (10g). Under Recover type of "Whole Database", there is two options which I get a little confused. The recovery type is selected as "Whole Database". And ontop of that, we can choose to select "Restore to current time or previous point in time" OR "Restore all datafiles" (which is also available as current time or prior point in time).
So back to my question earlier, what is the difference if i choose to "Restore to current time or previous point in time" OR "Restore all datafiles".
Anyhow, it will also restore all datafiles isn't it... since this is a "Whole Database" recovery.
You can restore the entire database to a particular point in time, either in the past or through the most recent redo log. And you can restore a single datafile to the most recent point in time as illustrated above.
If you want to restore a single datafile to a prior point in time, but you do not want to restore the rest of your database to that same point, then you'd have to use RMAN and TSPITR (Tablespace Point In Time Recovery).