cancel
Showing results for 
Search instead for 
Did you mean: 

Ora 01157 Cannot Identify Lock Data File 15 See Dbwr Trace File

Former Member
0 Kudos

HI Experts,

                Our Oracle database  is not starting up. This is our DR PRD System. Following are the error message while startup command is issued in >sql.

See the attachement. could anybody have solution for this error ? Thanks in Advance.

-Prasad

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182657
Active Contributor
0 Kudos

Hi,



This is our DR PRD System.

ORA-01157 cannot identify lock/file means issue relates with the datafile here (Incomplete or corrupted ).

A similar issue is answered at SCN thread ORA-01157: cannot identify/lock data file 201 -... | SCN

but CAUTION : In your case it's related with datafile & dropping of this datafile could make the situations worse for you.

Suggest you to restore the complete database from the successful backup or try to recover the specified file.

Regards,