Datafile is deleted, How to recover !!!!!!!!!!
Dear Friends ,
I m using Oracle 10g . suddenly , I have to delete one of my datafile(USERS01.DBF) in absent mind.
My database is in NOARCHIVE LOG mode and I have no export or cold backup . When I start my
database then it shows the following error :
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1296284 bytes
Variable Size 188745828 bytes
Database Buffers 88080384 bytes
Redo Buffers 7090176 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF'
I m running recover command and it also shows the following error :
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF'
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF'
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF'
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\USERS01.DBF'
In this moment , Is there any way to recover my datafile ? plz help .. ..