Solution to the accidental deletion of dbf Files in the Oracle database

Problem description:

If you accidentally delete the dbf file of the Oracle database, an error is prompted when you start or close the database.

When startup starts the database, the following message is displayed:

ORA-01157: unable to identify/lock data files

ORA-01110: Data File: '.../x1000_1.dbf' not found

Solution:

1. SQL> alter system set "_ allow_resetlogs_uption" = true scope = spfile;

System altered.

2. SQL> shutdown immediate

ORA-01109: the database is not open

Database uninstalled

ORACLE routine disabled

3. SQL> startup mount

ORACLE routine started

....

....

Database loaded

4. alter database datafile '.../X1000_1.dbf' offline drop;

Database changed

5. alter database open;

Database changed

6. Connect to the database

SQL> conn scada/scada

Connected

Solve the problem.