Removing ORA-01033 caused by SDE. DBF: Oracle initialization or shutdown in progress Error

In start-run, enter the command sqlplus/nolog.
Open sqlplus.exe
The following steps:
SQL> connect sys/user password as sysdba
SQL> shutdown normal
SQL> startup Mount

The Oracle routine has been started.

total system global area 293601280 bytes
fixed size 1248624 bytes
variable size 88081040 bytes
database buffers 201326592 bytes
redo buffers 2945024 bytes
the database has been loaded.

SQL> alter database open
2;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 11-see dbwr trace file
ORA-01110: Data File 11: 'd: "SDE. DBF'

From this we can see that it was caused by my data file deletion operation. What should I do?

The solution is as follows:
SQL> alter database create datafile 7;

The database has been changed.

SQL> conn Scott/Tiger
Error:
ORA-01033: Oracle initialization or shutdown in progress

Warning: you are no longer connected to Oracle.
SQL> alter database datafile 11 offline drop;
SP2-0640: not connected

SQL> conn sys/Oracle AS sysdba;
Connected.
SQL> alter database datafile 11 offline drop;(

Differences between datafile offline drop and datafile offline

There is no difference in archive mode, and offline drop must be used in non-archive mode.

)

The database has been changed.

If multiple files are deleted, the following error occurs:

SQL> conn Scott/Tiger
Error:
ORA-01033: Oracle initialization or shutdown in progres

Repeat the preceding steps. However, pay attention to the file number after datafile (for example, datafile 11, for example 10)

Then, continue with SQL> alter database create datafile 10;

I know that you have repeated the above steps and found that you have deleted several data files before using Scott to log on.

Restart the service and listen, and test the service on the net manager page.