Loss of user datafile

Down Time Required : No

Data Loss : No

Archive Log Mode : Yes

1. Insert data into a test table before deleting user datafile

2. Delete the user data file and perform restore and recovery

This is similar to undo datafile recovery but here we do the recovery online.

3. Check if all the records exist

That's it!!!

Regards

Charan