This content has been marked as final. Show 6 replies
rman could recover the lost datafile with no backup provided your database in archive log mode, and you have all archive logs since the datafile created.
alter database offline datafile <id>
restore datafile <id>
recover datafile <id>
alter database online datafile <id>
If there is no backup there is only 1 way to recover the datafile , that is if you have all archives since the birth of the datafile, then alter database create datafile file_id as 'newname'
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!"
This is another link of Recovery from Loss of datafile for which No Backup is available.
Thanks a ton.