All Data Files for a Non-System Tablespace are Either Lost or Corrupted

Perform an Oracle restore. Select the tablespace on the Restore window, then run the restore. All data files are restored and a recovery is performed to bring the tablespace to the latest point-in-time.