Q1: How do i find out which datafile i need to recover when doing a tablespace recovery?
Is it thru V$DATAFILE? Will oracle indicate this?
Q2: Under which circumstances shld i consider recovering a datafile / a tablespace?
It seems that i could recover a tablespace by just recovering a datafile (if only a datafile of that tablespace is corrupted)