RESTORE DATAFILE WITHOUT BACKUP - ARCHIVELOG MODE ON
Datafile restoration without backup is only possible when archivelog
is enabled during the time of datafile dropped. By using archivelog and redo logs
we can restore datafile.
SQL> select log_mode from v$database;
insert into emp select * from emp
ERROR at line 1:
ORA-01116: error in opening database file 8
ORA-01110: data file 6: '/d02/app/oracle/oradata/testdb/emp.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3