Case 3: lost data file and we have no backup (When database open)

Step 1 offline the datafile

SQL> alter database datafile ‘’ offline;

Step 2 Create datafile

SQL> Create database create datafile ‘’ as ‘’ size ;

Step 3 Recover the datafile

SQL> recover datafile ‘’;

Step 4 Online the datafile

SQL> alter database datafile ‘’ online;