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