Chapter 27 – Incomplete Database Recovery

Complete Recovery Assuming backups of the datafiles, copies of all necessary archive logs, online redo logs and the controlfile are available; the db can suffer any damage to the datafiles without losing any data: Complete Recovery: Take damaged datafiles offline Restore damaged datafiles Recover damaged datafiles Bring recovered datafiles online Syntax: alter tablespace users offline [...]