Oracle Database. How to recover a lost Oracle database data file (ORA-01157, ORA-01110, ORA-27041, OSD-04002)

Restore Oracle database data files in the event of loss
If you find such an error in the console or alert.log your database:
Errors in file D: \ APP \ ASUS \ diag \ rdbms \ orcl \ orcl \ trace \ orcl_dbw0_8104.trc:
ORA-01157: can not identify / lock data file 10 - see DBWR trace file
ORA-01110: data file 10: 'D: \ APP \ ASUS \ ORADATA \ ORCL \ DEV_OIM.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O / S-Error: (OS 2) The system can not find the file specified.
Errors in file D: \ APP \ ASUS \ diag \ rdbms \ orcl \ orcl \ trace \ orcl_ora_6572.trc:
ORA-01157: can not identify / lock data file 10 - see DBWR trace file
ORA-01110: data file 10: 'D: \ APP \ ASUS \ ORADATA \ ORCL \ DEV_OIM.DBF'
ORA-1157 signalled during: alter database open ...
it means that the Oracle database is unable to open one of these files, for example, with number 10.

To restore, follow these steps:

1. Connect to your database using the RMAN utility

$ Rman target / catalog ORCL / ***** @ rcat

2. Choose File recovery

RMAN> restore datafile 10;

3. coasting to a data file redo-information to the current state:

RMAN> recover datafile 10;

4. Open the database, if it is not already open:

$ $ ORACLE_HOME / bin / srvctl start database -d ORCLdb