An Unbacked up datafile is lost

Down Time Required: No

Data Loss: No

Archive Log Mode: Yes

1. Create a tablespace and user

2. Insert some records and delete the datafile

3. Perform recovery

SQL> alter database datafile '/u01/CHARAN/oracle/11gR1/oradata/bkpts.dbf' offline;

SQL> alter database create datafile '/u01/CHARAN/oracle/11gR1/oradata/bkpts.dbf';

SQL> alter database recover automatic datafile '/u01/CHARAN/oracle/11gR1/oradata/bkpts.dbf';

SQL> alter database datafile '/u01/CHARAN/oracle/11gR1/oradata/bkpts.dbf' online;

That's it!!!

Regards

Charan