Oracle: Archivelog mode full recoveryΒΆ

Title:Oracle: Archivelog mode full recovery
Author:Douglas O’Leary <dkoleary@olearycomputers.com>
Description:Oracle: Archivelog mode full 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...

The process for a full database recovery when in archivelog mode is as follows:

  1. Restore all database datafiles from backup
  2. Restore all archived redo logs
  3. Mount the database: startup mount
  4. Recover the database: recover database
  5. Enter aut when oracle prompts you to apply the redo logs.
  6. Open the database: alter database open