Solution after the dbf File of Oracle is deleted by mistake, oracledbf

Solution after the dbf File of Oracle is deleted by mistake, oracledbf

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.