Hi Team,
System was partially restored and recovered due hardware failure.
We had 3 file systems that had to be restored and in one of them we has "/oracle/BWP/sapdata8/temp_2/temp.data2" data file.
After the restore and recovery , the system was up.When ran check DB , the get the below error message and when i checked in DB02 , everytime when trying to see the datafile inside PSAPTEMP , there is a short dump with the same error message listed below.
Database error text........: "ORA-01157: cannot identify/lock data file 256 -
see DBWR trace file#ORA-01110: data file 256:
'/oracle/BWP/sapdata8/temp_2/temp.data2'"
When checked the restore , looks like "oracle/BWP/sapdata8/temp_2/temp.data2'" was not restored.
Kindly help to check how to correct this error. Even my online backup's are failing.