My Oracle Support Banner

Backup and Recovery Scenarios (Doc ID 94114.1)

Last updated on JULY 31, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.5 to 10.2.0.4 [Release 7.3.4 to 10.2]
Oracle Database - Personal Edition - Version 7.2.3.0 to 10.2.0.4 [Release 7.2.3 to 10.2]
Oracle Database - Standard Edition - Version 7.2.2.0 to 10.2.0.4 [Release 7.2.2 to 10.2]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 08-Jan-2014***



Purpose

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
Purpose
Troubleshooting Steps
 BACKUP SCENARIOS
 a) Consistent backups
 b) Inconsistent backups
 c) Database Archive mode
 d) Backup Methods
 e) Incremental backups
 f) Support scenarios
 RECOVERY 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
References

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