Skip to Content
avatar image
Former Member

Error in Check DB after RESTORE and RECOVER

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 26, 2009 at 09:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded