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