how to recover a datafile without backup.

how to recover a datafile without backup

Your database must be in archivelog mode.

Scenario:

The datafile was created at 9 am.

The datafile was corrupted or dropped at 5 pm.

SQL> select count(*) from event;

ERROR at line 1:

ORA-01116: error in opening database file 6

ORA-01110: data file 6: '/opt/oracle/oradata/pindb/god.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

Solution for the issue:

Sql> alter database datafile 6 offline;

Database altered.

Sql> alter database create datafile ‘/opt/oracle/oradata/pindb/god.dbf';

Database altered.

sql> recover datafile 6;

Media recovery complete.

sql> alter database datafile 6 online;

Database altered.

SQL> select count(*) from event;