ORA-01124: cannot recover data file 1 - file is in use or recovery

[Former Member]

Dear all

I have refresh quality server with production serevr , database started , but plroblem shows in sm21

:00:15 DIA 004 000 SAPSYS BY0 > ORA-00376: file 411 cannot be read at this ti

:00:15 DIA 004 000 SAPSYS BY0 > name for data file 411 is unknown - rename to

:00:15 DIA 004 000 SAPSYS BY0 > file#ORA-01110: data file 411:

:00:15 DIA 004 000 SAPSYS BY0 > 'C:\ORACLE\QAS\102\DATABASE\MISSING00411'

:00:15 DIA 000 000 SAPSYS BY4 Database error 376 at SEL access to table TBTCO

:00:15 DIA 000 000 SAPSYS BY0 > ORA-00376: file 411 cannot be read at this ti

:00:15 DIA 000 000 SAPSYS BY0 > name for data file 411 is unknown - rename to

:00:15 DIA 000 000 SAPSYS BY0 > file#ORA-01110: data file 411:

:00:15 DIA 000 000 SAPSYS BY0 > 'C:\ORACLE\QAS\102\DATABASE\MISSING00411'

:00:15 DIA 004 000 SAPSYS AB0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

:00:15 DIA 000 000 SAPSYS AB0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

database working properly but when i goes to recover commond show the error

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 931135488 bytes

Fixed Size 2057928 bytes

Variable Size 473958712 bytes

Database Buffers 448790528 bytes

Redo Buffers 6328320 bytes

Database mounted.

Database opened.

SQL> recover

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: 'I:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

please advise how can we resolve this problem

thanks

with best regrads

jainnedra prajapati

[former_member204746 · Accepted solution]

you did not manipulate your backup controlfile properly.

you added or deleted an entry that was not supposed to be there.

My call? you probably got your backup controlfile from your sourcfe system, but you probably added a datafile from the time you made your backup. so, this file does not exist on your refreshed ssytem.

check all datafile mentioned in your backup controlfile and make sure they all exist. then, correct your backup controlfile and run it.

good luck.

[Former Member · Accepted solution]

thanks eric my problem has been resolved ,as per your guidence ,

with regards

jainendra

[Former Member]

Hi,

File# -411not accessable check file permission .if permissons are okey then check

datafile status .

SQL>select name,status from v$datafile;

o/p 'Recover' then media recovery required.

give output of below query

select d.file# f#, d.name, d.status, h.status

from v$datafile d, v$datafile_header h

where d.file# = h.file#

and (d.status not in ('SYSTEM','ONLINE') or h.status != 'ONLINE' );

Surendrajain

[Former Member]

Hi,

Check below link. It may help you.

Thanks

Sushil