Oracle Data File accidentally deleted (DBF), recovery oralce library solution-Oracle error code: ORA-01033

System Environment:
1. Operating System: Windows 2000 server,
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3. installation path: C: \ oracle

Error:
A data file in the database was accidentally deleted due to misoperations,
The Oracle-related services on the control panel are displayed as started, but cannot be connected using SQL * Plus,
The following error is displayed:
ORA-01033: Oracle initialization or shutdown in progress

Simulated phenomenon:

Create tablespace test datafile
'C: \ test. ora 'size 5 m
Autoextend on next 1 m maxsize Unlimited
Default storage (initial 128 K next 1 m pctincrease 0)
/

Disable stop. BAT for all services

Net stop "oraclewebassistant0"
Net stop "oracleorahome81tnslistener"
Net stop "oracleserviceoradb"

Shutdown

Delete the test. ora file in the operating system

Restart service start. bat

Net start "oraclewebassistant0"
Net start "oracleorahome81tnslistener"
Net start "oracleserviceoradb"

In the service, oracleserviceoradb indicates that it has been started, but cannot be connected with SQL * Plus,
Show ORA-01033: Oracle initialization or shutdown in progress

Solution:

Let the data file go offline to open the database.
C: \> svrmgrl
Svrmgrl> connect internal/Oracle
Svrmgrl> Shutdown
Svrmgrl> startup Mount

-- Command in archivelog mode. The file name must be in uppercase.
Svrmgrl> alter database datafile 'C: \ test. ora 'offline;

-- Noarchivelog MODE Command
Svrmgrl> alter database datafile 'C: \ test. ora 'offline drop;

Svrmgrl> alter database open;

-- Query the data file association and offline status
SQL> SELECT FILE #, name, status from V $ datafile;

SQL> drop tablespace test;

The tablespace is discarded.