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>

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: ‘D:\ORACLE\ORADATA\ASSETMGT\UNDOTBS01.DBF’

 It looks like UNDOTABLESPACE problem.

If you have deleted the file or then you need to recover  this file is used for undo space.

Possible solutions are

1. Mount the database.

2. Check the status of the datafile.

3. Recover the datafile. (Do not use alter database, just RECOVER DATAFILE ‘FILESPEC’;

4. Bring datafile online

5. Bring the db up.