ORA-01157 and ORA-01110 errors

[Former Member]

Dear all,

I was getting "ORA-00205: error in identifying controlfile" error while starting the database

This had happened during the investigation of the IMPORT_ABAP phase failure, during our system copy (Import)

I found out in alert_SID.log that control file was missing in 3 locations /oracle/SID/origlogA, /oracle/SID/origlogB and /oracle/SID/sapdata1

So I copied the control file from /oracle/GRD/saparch/cntrl to the above 3 locations. Now I am able to mount the database but not able to open it.

Getting the below mentioned error

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/oracle/SRD/sapdata1/system_1/system.data1'

Any suggestions?

[Former Member]

Dear all,

Thanks for your time and inputs

The relevant file systems somehow got un-mounted

Mounted the file systems

Problem resolved

Rgds,

[kishore_soma]

hi sandy,

Can u explain, how are you doing system copy

> using sapinst export/import of both CI and DB

> or sapinst export/import of CI and DB backup/restore

Regards,

Kishore Soma

[Former Member]

nvestigation of the IMPORT_ABAP phase failure,

can you post log ?

[Former Member]

System copy using Export / Import method using sapinst

[Former Member]

The control file from /oracle/SRD/saparch/cntrl was an old file so deleted it from the 3 locations as mentioned earlier

Now there is no control file in origlogA, origlobB and sadata1

Now I am getting the below mentioned error

ORA-00205: error in identifying control file, check alert log for more in

any suggestions?

[Former Member]

Can you explain what you do (system copy using what method ?)

Step by step.

Regards.