Error in Check DB after RESTORE and RECOVER

[Former Member]

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.

[stefan_koehler]

Hello Priyanka,

how did you restore your database?

The temporary files are not included in a backup, because they are not needed for a recovery - that works as designed.

After the recovery you have to add these files again.

If you would have used brrecover for restoring/recovering your database the temporary files would be added automatically.

Check the documentation here:

http://help.sap.com/saphelp_nw70/helpdata/EN/6e/4c37b85dc7f24d88f177396dc45645/content.htm

Now you have to do this manually like this:

shell> sqlplus / as sysdba
SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/BWP/sapdata8/temp_2/temp.data2' REUSE;

Regards

Stefan