Oracle data file corruption, how to open a database

oracle| Data | database


A data file corruption, how to open the database?






System environment:
1, operating system: Windows Server, machine memory 128M
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, Installation path: C:\ORACLE


Error behavior:
By mistake, a data file in the database has been mistakenly deleted,
Oracle related services for Control Panel display started, but cannot connect with Sql*plus.
Display the following error
Ora-01033:oracle initialization or shutdown in progress


Simulation phenomenon:

Create Tablespace Test datafile
' C:\test.ora ' size 5M
Autoextend on NEXT 1M MAXSIZE Unlimited
Default storage (initial 128K next 1M pctincrease 0)
/

Turn off all services Stop.bat

net stop "OracleWebAssistant0"
net stop "Oracleorahome81tnslistener"
net stop "ORACLESERVICEORADB"

Shutdown

Remove Test.ora files from the operating system

Restart Service Start.bat

net start "OracleWebAssistant0"
net start "Oracleorahome81tnslistener"
net start "oracleserviceoradb"

Service ORACLESERVICEORADB display is started but cannot be connected with Sql*plus.
Displays ora-01033:oracle initialization or shutdown in progress


Workaround:

Let the data file go offline, you can open the database
C:\>svrmgrl
Svrmgrl>connect Internal
Svrmgrl>shutdown
Svrmgrl>startup Mount

--archivelog mode command, file name to 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;


--Querying data file union, offline status
Sql> select File#,name,status from V$datafile;

sql> Drop tablespace test;

Table space has been discarded.