Skip to Content
0
Former Member
Jun 09, 2009 at 08:57 AM

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

6609 Views

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