The
Point-in-Time (PIT) and
Flashback Database (FRA) recovery types share recovery mode options.
The following table describes the recovery mode options and shows the relation that each option has to each recovery type.
Table 1. Recovery mode optionsThe following table contains the recovery mode options.
Recovery mode options
Recovery value
Point-in-Time (PIT)
Flashback Database (FRA)
Backup Time (PIT only)
Recovers the database to the most recent SCN. The Avamar Plug-in for Oracle automatically determines the SCN from the control file.
X
-
SCN
Recovers the database to the specified SCN:
To recover an archive log backup, type the next SCN for the archive log.
To recover only from a database backup, type the SCN for the database.
Type the SCN in the
Recovery value field.
X
X
Log Sequence
Recovers the database to the specified log sequence number. Specify the log sequence number in the
Recovery value field.
X
X
Time Stamp
Recovers the database to the specified timestamp. The timestamp format must conform to the localization settings on the target host and locale configuration setting for the Oracle server.
X
X
Restore Point
Recovers the database to the SCN associated with the specified restore point. The restore point can be an ordinary restore point or a guaranteed restore point.
X
X
Before SCN (FRA only)
Recovers the database to its state just before the specified SCN. Any changes at an SCN lower than the specified SCN are applied. If there is a change that is associated with the specified SCN, it is not applied.
-
X
Before Log Sequence (FRA only)
Specifies a redo log sequence number and thread as an upper limit. RMAN applies changes up to (but not including) the last change in the log with the specified sequence and thread number.
-
X
Before Resetlogs (FRA only)
Recovers the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS.
-
X
Before Time Stamp (FRA only)
Recovers the database to its state including all changes up to but not including changes at the specified time.
-
X
Data is not available for the Topic
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please select whether the article was helpful or not.
Comments cannot contain these special characters: <>()\