Recovery Manager Restore and Recovery Techniques - Oracle 10g/11g Data and Database Management Utilities - page 125

SCN

Media Recovery

3

Transactions Recovered

RECOVER

2

SCN

Missing Transactions

Online & archived
log files

1

I. Rollforward

RESTORE

Database
Backup

Undo Blocks

II. Rollback

Complete recovery
The following image depicts the complete recovery process. In a complete recovery
all pending changes are applied against the database files. The recovery goal is
determined after the information stored in the controlfile .

1. In a complete recovery scenario only the missing or corrupt datafiles need to
be restored.
2. The recovery process aims to recover the inconsistent datafiles.
3. Once the process is finished the database is open.