Scenario: It is a Testing Database while Testing Import Database Storage got falied and Import aborted.
Restarted the storage and while trying to bring the Database up we got ORA-01113

1. Database is on No Archive Log Mode
2. There is no Cold Backup of the Database

Solution:
Since there is no Backup and database is not in archive log mode. We will not be able to go for Restore or Reocovery process.
Only way is to drop the Datafile and bring the database up.

Example:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: ‘/u01/test/users02.dbf’

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

FILE# NAME STATUS
———- ————————————————- ———–
5 /u01/test/users02.dbf ONLINE

SQL>

SQL> alter database datafile ‘/u01/test/users02.dbf’ offline drop;

Database altered.

SQL> alter database open;

Database altered.

SQL>