Case 4: Lost datafile and No backup (When database abnormal terminated)
SQL> startup mount
Step 2 Recreate datafile
SQL> alter database create database datafile ‘
Step 3 Online the datafile
SQL> alter database datafile ‘
Step 4 Now Open the database
SQL> alter database open
Responses