|













| |
Complete Recovery of Oracle Database
 | Recovery: No
Archive Mode The entire database is restored to
the point of the last whole closed backup. |
 | Recovery: With Archive Mode Only
need to restore lost files and recovers all data to the time of failure. |
- Datafiles for restore must be offline.
- Restore only lost or damaged datafiles.
- Do NOT restore the control files, redo logs,
password, or parameter files!
- Recover the datafiles using the Recover command.
- svrmgr> Recover automatic database (Closed
database Recovery)
- svrmgr> Recover automatic tablespace
<number> | <name> (Open
database Recovery)
- svrmgr> Recover automatic datafile
<number> | <name> (Open or
Closed database Recovery)
|