Skip to Content
0
Former Member
Mar 26, 2009 at 08:03 AM

Error in Check DB after RESTORE and RECOVER

73 Views

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.