Case 4: Lost datafile and No backup (When database abnormal terminated)

Step 1 Startup the database with mount option

SQL> startup mount


Step 2 Recreate datafile

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

Step 3 Online the datafile

SQL> alter database datafile ‘’ online;

Step 4 Now Open the database

SQL> alter database open