Restoration of Oracle tablespace data file loss

If you cannot create an Oracle table, log on to the server and check it. I tried to create a table, prompting you That the tablespace is insufficient. If you want to expand the tablespace, you will be OK, the following two errors are reported:

ORA-01157: cannot identify/lock data file 10-see DBWR trace file

ORA-01110: data file 10: '/home/oracle/oradata/ora10/xxt_mt_ms1_9.ora'

Depressed, an error occurred. I read the current directory and did not know Who deleted the file. I went crazy and found a solution through great efforts:

SQL> startup mount;
SQL> alter database create datafile '/home/oracle/oradata/ora10/xxt_mt_ms1_9.ora ';
SQL> set autorecovery on;
SQL> recover datafile '/home/oracle/oradata/ora10/xxt_mt_ms1_9.ora ';
SQL> alter database datafile '/home/oracle/oradata/ora10/xxt_mt_ms1_9.ora' online;

SQL> alter tablespace XXT_mt_as_msg online;

SQL> alter database open;

Now, go to the current database file directory and find that xxt_mt_ms1_9.ora has been restored. Then, the tablespace is expanded again, and the table can be created again.