ORA-01157: cannot identify/lock data file 255

[#1]

Hi there,

I'm using SAP ECC6.0, Oracle 10G, HPUX B11.23.

Recently I had performed database restoration from my backup tape. However, during the process of bringing up the Oracle and SAP database, I observed that there could be some archive logs went missing. I had tried to check them from my backup tape, but could not find it.

In short, now my SAP database is up and running, but I'm having another problem when I executed a "CheckDB" job in DB13. The job is unable to complete successfully. Please refers to messages in my next post.

Please kindly advice on how to fix this issue.

Appreciate for any of your help and advice.

Thank you.

Regards,

Peter

[JPReyes]

Certainly seems like PSAPTEMP datafiles are missing.. check in DB02 if any datafiles exist.

Also read Note 659946 - FAQ: Temporary tablespaces

Regards

Juan

[Former Member]

Hi Juan,

Thanks for the response.

I've checked my QAS system and able to see the PSAPTEMP tablespace name from DB02. Please see below.

PSAPTEMP 5,440.00 5,440.00 0 YES 10,000.00 10,000.00 0 1 0 0 ONLINE TEMPORARY

Would appreciate if you could help to advice on how to fix this issue.

Thanks.

- Peter

[Former Member]

You need to create the PSAPTEMP tablespace as system is not able to identified the datafile with the file_id 255. For more info for TEMP tbs read the SAPnote

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'oracle/QAS/sapdata2/temp_1/temp.data1' SIZE 1048576000 REUSE AUTOEXTEND OFF;

All the best !

[Former Member]

Hi prateek_y,

Thanks for your help.

It seems to be working.

Will need to monitor it further should there be anymore issues.

- Peter

[Former Member]

Good... you can make this as answered if you feel its solved !