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