Complete Recovery

Up
Open Database Backup
Closed Database Backup
Complete Recovery
Incomplete Recovery
Loss Of Redo Logs
Loss of Control Files
Recovery Manager
Using Import - Export
Using SQL Loader
Oracle 8i Replication
Cloning / Moving DB
Commands
Search

 

 

Complete Recovery of Oracle Database

bulletRecovery: No Archive Mode The entire database is restored to the point of the last whole closed backup.

 

bulletRecovery: With Archive Mode Only need to restore lost files and recovers all data to the time of failure.
  1. Datafiles for restore must be offline.
  2. Restore only lost or damaged datafiles.
  3. Do NOT restore the control files, redo logs, password, or parameter files!
  4. Recover the datafiles using the Recover command.
    1. svrmgr> Recover automatic database (Closed database Recovery)
    2. svrmgr> Recover automatic tablespace <number> | <name> (Open database Recovery)
    3. svrmgr> Recover automatic datafile <number> | <name> (Open or Closed database Recovery)
 
bulletRecovery of a file in a "hot Backup" Mode. Failure during "Open Database Backup".
 

Home Open Database Backup Closed Database Backup Complete Recovery Incomplete Recovery Loss Of Redo Logs Loss of Control Files Recovery Manager Using Import - Export Using SQL Loader Oracle 8i Replication Cloning / Moving DB Commands Search

Send mail to mike@infomaxweb.com with questions or comments about this web site.
Copyright © 2003 Infomax
Last modified: 10/27/06