Steps for Complete Recovery[Open Database]

SiteMap

Recovery with Archiving «Prev Next»

Database Backup
Physical Backups Archiving
Database Backup Concepts
OS Backup Options
Closed Database Backups
Performing Closed DB Backup
Open Database Backups
Open DB Backup Options
Fuzzy Backup Problem
Performing Open DB Backup
Backingup Control File
Monitoring Open DB Backup
Logging nologging Modes
Read Only Backups
Physical Backups Conclusion
Data Dictionary Views
Noarchivelog Mode Recovery
Identify Required Structures
Restoring Noarchivelog
DB Recovery Implications
Recovering NoArchivelog Database
Restoring Files
Noarchivelog Recovery
Recovery with Archiving
Closed Database Recovery
Recovering Initially Open
Recovering Initially Closed
Archiving Incomplete Recovery
Different Incomplete DB Recovery
Incomplete DB Recovery Steps
Monitoring Oracle Recovery Progress
Cancel Based Recovery
Recovering without current RedoLog
Performing Recovery through Resetlogs
Point-in-time Recovery Concepts
Infrequent Recovery Situations
Clearing Corrupt Online Redo log Files
Recovering Database with Inactive redoLogs
Clearing Corrupt Online Redo log Files
Recreate Redo Log Files
Monitoring Recovery Status
DB Downtime Prevention
Parallel Recovery Operations
ReadOnly Tablespace Recovery

Steps for complete recovery of open database, initially open

The correct order is as follows:

Take the desired datafile offline.
Restore the datafile.
Recover the datafile (or tablespace).
Take the datafile (or tablespace) online.

Note to Reader: The concept of "open database, initially open" was a technique that was used for Oracle 8i and is no longer in use for Oracle Database Backup.