Solution to fail to start database after Oracle data files are mistakenly deleted

Cause: I installed the Oracle database on the Windows system and deleted the Oracle tablespace file without starting Oracle, and the next time I started it, I would have an error, as follows: Ora-01033:oracle Initializationg or Shutdown in progress. Start with the DBA user will be an error: So-and-so file can not find, the file is not found is deleted table space files.
Analysis issues because the data file was deleted without being offline, causing Oracle's data to be inconsistent, the startup failed. Workaround lsnrctl Stop (cmd below) sqlplus conn as SYSDBA SQL shutdown abort SQL startup mount SQL ALTER DATABASE datafile ' file 1 path ' Offline drop; The database has changed. SQL ALTER DATABASE datafile ' file 2 path ' offline drop; The database has changed. SQL ALTER DATABASE open; SQL drop tablespace table space name;