Oracle: Online tablespace/datafile recoveryΒΆ

Title:Oracle: Online tablespace/datafile recovery
Author:Douglas O’Leary <dkoleary@olearycomputers.com>
Description:Oracle: Online tablespace/datafile recovery
Date created:07/20/2010
Date updated:07/20/2010
Disclaimer:Standard: Use the information that follows at your own risk. If you screw up a system, don’t blame it on me...

Partial recovery, be it tablespace or datafile, requires archivelogmode. The process to follow is:

  1. Take the affected tablespace offline: alter tablespace ${tablespace} offline
  2. Restore all datafiles associated with the tablespace
  3. Recover the tablespace: recover tablespace
  4. Online the tablespace: alter tablespace ${tablespace} online