Environment
WinXP
Oracle 10g (Installation path d:/oracle/product/10.1.0/)
Error phenomenon
Yesterday in using Oradim to remove an unused SID service, there was an error starting the database today,
ORA-01033: ORACLE initialization or shutdown in progress
Reason
A data file for a tablespace was deleted when the SID was deleted
Process Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:/Documents and Settings/xxxx>sql Plus System/yang@ora sql*plus:release 10.1.0.2.0-production on Fire January 12:19:18 2008 Copyright (c) 1982, Orac Le. All rights reserved. Error:ora-01033:oracle initialization or shutdown in progressNolog Login DatabaseC:/Documents and Settings/xxxx>sqlplus/nolog sql*plus:release 10.1.0.2.0-production on Fire January 12:35:54 2008 Co Pyright (c) 1982, Oracle. All rights reserved.connecting to a database using SYSDBASql> Connect Sys/yang as Sysdba Connected.Close Databasesql> shutdown normal ora-01109:database not open database dismounted. ORACLE instance shut down.reboot to Mount StateSql> Startup Mount ORACLE instance started. Total System Global area 171966464 bytes Fixed size 787988 bytes Variable Size 145488364 b Ytes database buffers 25165824 bytes Redo buffers 524288 Database bytes.ALTER Database Open Statesql> ALTER DATABASE open; ALTER DATABASE open * ERROR at line 1:ora-01147:system tablespace file 1 is offline Ora-01110:data file 1: ' d:/oracle/p Roduct/10.1.0/oradata/ora/system01. DBF ' shows datafile 1 errorModify the status of DataFile 1sql> ALTER DATABASE datafile 1 online; Database altered.Database Statesql> ALTER DATABASE open; Database altered. Database normal sql> conn System/yang@ora Connected. Sql> SELECT * from state; Cnt_c st_ st_name------------------1 123 1 123 sql> reference: http://jacked.blogchina.com/blog/5513999. HTML also has a less definite place is not oradim the loss of data files caused by the deletion of SIDS