=======================================================
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:

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