Hi,
I have installed Oracle 11g in my laptop for practice purpose. (Operating system is windows7).
Accidentally I've deleted one DBF file (which was created by me - file name is VIJI.DBF ). Now when I was logging to database, I'm getting error like
ORA-01033: ORACLE initialization or shutdown in progress
Process ID :0
Session ID: 0 Serial number:0
After that I executed below commands from SQl*Plus
conn SYS as SYSDBA
Password : *******
SQL> SHUTDOWN IMMEDIATE;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
-- After that I've excuted STARTUP command
SQL> STARTUP;
ORACLE instance started.
Total System Global Area---
----------------------
---------------------
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\VIJI.DBF'
Please help me to resolve this issue.
Many thanks for the help. Kindly let me know if you need any further information.
Cheers,
Suri