My Oracle Support Banner

Backup and Recovery Scenarios (Doc ID 94114.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 7.3.4 to 10.2]
Oracle Database - Personal Edition - Version to [Release 7.2.3 to 10.2]
Oracle Database - Standard Edition - Version to [Release 7.2.2 to 10.2]
Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


Describe various Backup and Recovery Scenarios.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 a) Consistent backups
 b) Inconsistent backups
 c) Database Archive mode
 d) Backup Methods
 e) Incremental backups
 f) Support scenarios
 1. Online Block Recovery.
 2. Thread Recovery.
 3. Media Recovery.
 Media Failure and Recovery in Noarchivelog Mode
 Media Failure and Recovery in Archivelog Mode
 a) Point in Time recovery:
 b) Recovery without control file
 c) Recovery of missing datafile with rollback segments
 d) Recovery of missing datafile without undo segments
 e) Recovery with missing online redo logs
 f) Recovery with missing archived redo logs
 g) Recovery with resetlogs option
 h) Recovery with corrupted undo segments.
 i) Recovery with System Clock change.
 j) Recovery with missing System tablespace.
 k) Media Recovery of offline tablespace
 l) Recovery of Read-Only tablespaces

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.