Datafiles and Tablespaces Restores for Oracle

Recover a missing or corrupted datafile and tablespace when:

  • A datafile or tablespace is corrupted after you have restored the database
  • A datafile or tablespace is the only lost data that must be restored. You can restore the datafile or tablespace instead of the entire database.

By default, tablespaces and datafiles are restored to the original location from the latest online backup, but you can restore them to a new location.

You must place the datafiles and tablespaces that you want to restore offline, before you start the restore. The database can remain online, unless you restore Oracle SYSTEM tablespaces.