RA_SBT_RESTORE_RANGE
This view describes the restore range of each database from SBT backups on the Recovery Appliance.
| Column | Data Type | NULL | Description |
|---|---|---|---|
DB_KEY |
NUMBER |
The primary key of the protected database. | |
DB_UNIQUE_NAME |
VARCHAR2(30) |
The unique name assigned to the database. | |
TENANT_NAME |
VARCHAR2 |
The tenant name for this database in the Recovery Appliance. | |
TENANT_IDENTIFIER |
NUMBER |
The customer tenant identifier for this database in the Recovery Appliance. | |
LOW_TIME |
DATE |
The earliest time to which the database can be restored. | |
HIGH_TIME |
DATE |
The latest time to which the database can be restored. | |
LOW_SCN |
NUMBER |
The lowest SCN to which the database can be restored. | |
HIGH_SCN |
NUMBER |
The highest SCN to which the database can be restored. | |
LOW_DBINC_KEY |
NUMBER |
The primary key for the incarnation of the target database to which the low SCN belongs. | |
HIGH_DBINC_KEY |
NUMBER |
The primary key for the incarnation of the target database to which the high SCN belongs. | |
LAST_UPDATED |
DATE |
The time that the restore range for this protected database was last updated. | |
KEEP_OPTIONS |
NUMBER |
If 0, then this is a row with non-keep backups. If >0, this row has keep backups. |
|
KEEP_UNTIL |
DATE |
Contains the retention time for keep backups. Valid only for rows with |
|
KEEPBKP_TAG |
NUMBER |
Contains the tag value for the archival backup. Valid only for rows with |
|
KEEPBKP_RSPNAME |
VARCHAR2 |
Contains the restore point name of the archival backup. Valid only for rows with |
|
KEEPBKP_TO_SCN |
NUMBER |
Contains the recovery SCN for which the archival backups were creaed. Valid only for rows with |
|
KEEPBKP_TO_TIME |
DATE |
Contains the recovery time for which the archival backups were created. Valid only for rows with |
|
BACKUP_TAG |
NUMBER |
Contains the tag value of backups for the range. If the tag value of all backups is not the same, it contains *'''. |