Skip to Content
avatar image
Former Member

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

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

IMG1.jpg (243.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 29, 2015 at 04:11 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded