This content has been marked as final. Show 6 replies
In 11g ,you can take advantage of Data recovery advisor. You can just go to RMAN and write the following
RMAN> LIST FAILURE
RMAN> REPAIR FAILURE
RMAN will do everything for you provided your database is in archive log mode and you have all the archive logs available.
Read the following document for better understanding.
That is actually a feature that was available long before it was integrated into RMAN restore:
It works, because there is information in the controlfile about the datafile - everything you see in v$datafile.
Then under the covers, RMAN does
Afterwards, it can be recovered as after an ordinary restore, provided that you have all the archivelogs since original datafile creation.
alter database create datafile 'NameOfTheFile';
"Don't believe it, test it!"