Getting ORA-01157: cannot identify/lock data file 48 - see DBWR trace file
Hi All,
I am getting this error on starting the db.
---------------------------------------------------------------------------------------------------
SQL> startup;
ORACLE instance started.
Total System Global Area 369098752 bytes
Fixed Size 2083856 bytes
Variable Size 327156720 bytes
Database Buffers 33554432 bytes
Redo Buffers 6303744 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 48 - see DBWR trace file
ORA-01110: data file 48:
'/db/NFIN10111/DATA/NDB10111_data/CRM_SYSTEM_1_NDB10111.dbf'
----------------------------------------------------------------------------------------------------
I have some datafiles with one time stamp and some set of datafiles with another time stamp. I have no idea how it happened. This datafile 'CRM_SYSTEM_1_NDB10111.dbf'' has old time stamp where as 'system' datafile has current time stamp.
I did the following:
------------------------------------------------------------------------------------------------
SQL> ALTER SYSTEM CHECK DATAFILES;
System altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 48 - see DBWR trace file
ORA-01110: data file 48:
'/db/NFIN10111/DATA/NDB10111_data/CRM_SYSTEM_1_NDB10111.dbf'
----------------------------------------------------------------------------------------------------
Still I am not able to open my database. Please let me know how to resolve this. My db is not in archivelog mode and no backup was taken. Is there any way I can recover this db? Thanks in advance.