Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

Dell Avamar for Oracle 19.10 User Guide

PDF

Recovery modes and values

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

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\