Hi Gurus
I have a datafile that needs recovery and this datafile I dont have any idea, where it comes from or what is exactly inside that file. The main issues is it makes Rman to fail.
Here is the details of the file: When I select the v$datafile I get this file:
$ORACLE_HOME/MISSING00006
I get this error from rman:
RMAN-06056: could not access datafile 6
How do I deal with this problem. I have been advised to rename the datafile, using
alter database rename file '$ORACLE_HOME/dbs/MISSING00006' to '<actual path/name of the file>'; My challenge is I don't know where is the path of the datafile or how do I check the actual path/name of the file?
Please help.
Thanks