Case 5: If all database lost and we have no backup of newly created data file.

Step 1 Restore database and mount the database

Step 2 Recover the database

SQL> recover database using backup controlfile;

Step 3 Check file status

SQL> select file#,name,status from v$datafile;

Step 4 Create datafile

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

Step 5 Recovery the database

SQL> recover automatic database using backup controlfile until cancel;