Recovery Appliance View Reference

Summary of Recovery Appliance Views

Table 22-1 Recovery Appliance Views

Recovery Appliance View	Description
`RA_ACTIVE_SESSION`	This view lists information about active client sessions currently running in the Recovery Appliance.
`RA_API_HISTORY`	This view describes the history of user-issued API commands.
`RA_CONFIG`	This view lists the user configuration settings.
`RA_DATABASE`	This view lists the databases protected by this Recovery Appliance.
`RA_DATABASE_HISTORY`	This view has one row for each database for each day going back one year. There may be rows missing in case the `DB_STATS_REFRESH` task was delayed in its execution for over a day. There may also be phantom rows for deleted databases.
`RA_DATABASE_STORAGE_USAGE`	This view lists the storage usage for each protected database.
`RA_DATABASE_SYNONYM`	This view lists the protected databases and their equivalent names.
`RA_DB_ACCESS`	This view describes which Recovery Appliance user accounts have access to which protected databases.
`RA_DISK_RESTORE_RANGE`	The restore range of each protected database from disk backups on this Recovery Appliance.
`RA_EM_SBT_JOB_TEMPLATE`	This view lists defined SBT jobs and their statuses for Oracle Enterprise Manager.
`RA_ENCRYPTION_INFO`	This view describes the historical encryption key information.
`RA_INCIDENT_LOG`	This view describes the Recovery Appliance incidents.
`RA_INCOMING_BACKUP_PIECES`	This view describes the backup pieces being received by the Recovery Appliance.
`RA_POLLING_FILES`	This view lists the files backed up by Recovery Appliance from the polling location.
`RA_POLLING_POLICY`	This view lists the defined backup polling policies.
`RA_PROTECTION_POLICY`	This view lists the protection policies defined for this Recovery Appliance.
`RA_PURGING_QUEUE`	This view describes the order in which protected databases will have their oldest backups deleted when space is low.
`RA_RECOVERY_COMPLIANCE`	This view lists information about active compliance windows on the database in which backups may not be deleted.
`RA_REPLICATION_CONFIG`	This view lists the replication server configurations.
`RA_REPLICATION_DATABASE`	This view lists information on replication servers and protected databases.
`RA_REPLICATION_PAIR`	This view lists replication information for replicating protection policies.
`RA_REPLICATION_POLICY`	This view lists the association of replication servers to protection policy.
`RA_REQUEST BACKUP`	This view describes the list of requested backup pieces from a remote Recovery Appliance.
`RA_RESTORE_RANGE`	This view describes the restore range of each protected database from all backups on this Recovery Appliance.
`RA_SBT_ATTRIBUTE_SET`	This view describes the defined SBT attribute set.
`RA_SBT_JOB`	This view describes the defined SBT job templates.
`RA_SBT_LIBRARY`	This view lists the defined SBT libraries.
`RA_SBT_RESTORE_RANGE`	This view describes the restore range of each database from SBT backups on the Recovery Appliance.
`RA_SBT_TASK`	This view lists the queued background SBT tasks and their run statuses.
`RA_SBT_TEMPLATE_MDF`	This view lists missing level 0 data file backups for each SBT template.
`RA_SERVER`	This view describes the current settings for the Recovery Appliance.
`RA_STORAGE_HISTOGRAM`	This view describes the storage allocation history for recent time periods.
`RA_STORAGE_LOCATION`	This view lists defined Recovery Appliance storage locations and their allocations.
`RA_STORAGE_LOCATION_HISTORY`	This view contains a daily history of storage location for the for the previous year. It has one row for each storage location for each day going back a year. It may contain phantom rows for storage locations that were deleted.
`RA_TASK`	This view lists queued background tasks and their run statuses.
`RA_TIMER_TASK`	This view describes timer process tasks and their planned executions.
`RA_TIME_USAGE`	This view describes the Recovery Appliance elapsed and idle time for the last 30 days.

RA_ACTIVE_SESSION

This view lists information about active client sessions currently running in the Recovery Appliance.

Column	Data Type	Description
`INST_ID`	`NUMBER`	The Recovery Appliance instance number where this session is running.
`INSTANCE_NAME`	`VARCHAR2(16)`	The Recovery Appliance instance name where this session is running.
`HOST_NAME`	`VARCHAR2(64)`	The Recovery Appliance host name where this session is running.
`SID`	`NUMBER`	The session ID for the active session.
`SERIAL#`	`NUMBER`	The session serial number, which uniquely identifies the objects in a session.
`SPID`	`VARCHAR2(24)`	The operating system process identifier.
`DB_KEY`	`NUMBER`	The primary key for this database in the recovery catalog.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`	The unique database name.
`SBT_SID`	`VARCHAR2(64)`	The SBT session identifier.
`CLIENT_IDENTIFIER`	`VARCHAR2(64)`	The client Identifier of the session.
`MODULE`	`VARCHAR2(64)`	The name of the module that is currently executing.
`ACTION`	`VARCHAR2(64)`	The name of the action that is currently executing.
`SQL_ID`	`VARCHAR2(13)`	The SQL identifier of the SQL statement that is currently being executed.
`EVENT`	`VARCHAR2(64)`	The resource or event for which the session is waiting.
`P1`	`NUMBER`	First wait event parameter
`P2`	`NUMBER`	The second wait event parameter.
`P3`	`NUMBER`	The third wait event parameter.
`WAIT_TIME`	`NUMBER`	The wait time in hundredths of a second. See description of `V$SESSION.WAIT_TIME` for more information.
`SECONDS_IN_WAIT`	`NUMBER`	The wait time (in seconds). If the session is currently waiting, then the value is the amount of time waited for the current wait. If the session is not in a wait, then the value is the amount of time since the start of the most recent wait.
`STATE`	`VARCHAR2(19)`	The state of the wait event: `WAITING`, `WAITED UNKNOWN TIME`, `WAITED SHORT TIME`, `WAITED KNOWN TIME`. See description of `V$SESSION.STATE` for more information.
`TASK_ID`	`NUMBER`	The task identifier.
`TASK_TYPE`	`VARCHAR2(30)`	The task type.
`PRIORITY`	`NUMBER`	The task priority.
`TASK_STATE`	`VARCHAR2(13)`	The processing state for the task: `EXECUTABLE`, `RUNNING`, `COMPLETED`, `TASK_WAIT`, `FAILED`, and so on.
`JOB_NAME`	`VARCHAR2(128)`	The `DBMS_SCHEDULER` job name.
`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.

RA_API_HISTORY

This view describes the history of user-issued API commands.

Column	Data Type	Description
`RESULTS`	`VARCHAR2(1000)`	The results from running this command: `SUCCESS` or `FAIL`.
`EXECUTE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The time at which the command started.
`TASK_NAME`	`VARCHAR2(30)`	The name of the task.
`COMMAND_ISSUED`	`VARCHAR2(4000)`	The full command as submitted by the user.
`ELAPSED_SECONDS`	`NUMBER`	The elapsed run time (in seconds) for the task.
`API_USER`	`VARCHAR2(1000)`	The user who initiated the API .

RA_CONFIG

This view lists the Recovery Appliance configuration settings. The list includes public configuration settings as well as internal configuration settings that have been altered from the default value.

In software release 21.1, changes made to the config table are tracked, as well as default values, which are the "best values" that the Recovery Appliance is shipped with. The view shows all non-underscore config entries as well as those that have values different from the default values.

Column	Data Type	NULL	Description
`NAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the configuration variable. See "RA_CONFIG" for variable definitions and default values.
`VALUE`	`VARCHAR2(100)`		The value of the configuration variable.
`DEFAULT_VALUE`	`VARCHAR2(100)`		The default value of the configuration variable.
`CHANGE_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		The date this configuration variable was changed from the default value.
`COMMENTS`	`VARCHAR2(300)`		The comment given at the time the configuration variable was changed.

RA_DATABASE

This view lists the databases protected by this Recovery Appliance.

Column	Data Type	Description
`DB_UNIQUE_NAME`	`VARCHAR2(32)`	The unique name of this protected database.
`DB_KEY`	`NUMBER`	The primary key for this database in the Recovery Appliance metadata database.
`DELETING`	`VARCHAR2(7)`	`YES` if this database is currently being deleted.
`STATE`	`VARCHAR2(12)`	`ACTIVE` if this database is currently in active use. `DELETING` if this database is currently being deleted. `SUSPENDING` if this database is currently being suspended `SUSPENDED` if this database is currently suspended. `UNREGISTERED` if this database is currently unregistered. `PROVISIONAL` if a database is created under a `AUTOTUNE_RESERVED_SPACE` policy that cannot allocate its initial reserved space because there is no room in the storage locaiton.
`DBID`	`NUMBER`	The DBID for this protected 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.
`CREATION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The time when this database was added to the Recovery Appliance.
`POLICY_NAME`	`VARCHAR2(128)`	The name of the protection policy used by this database.
`STORAGE_LOCATION`	`VARCHAR2(128)`	The name of the Recovery Appliance storage location used by this protected database.
`RECOVERY_WINDOW_GOAL`	`INTERVAL DAY(9) TO SECOND(6)`	The recovery window goal for backups on disk, as specified in the protection policy.
`MAX_RETENTION_WINDOW`	`INTERVAL DAY(9) TO SECOND(6)`	The maximum amount of time to retain disk backups. The Recovery Appliance deletes disk backups when they are older than this window. However, backups may be retained longer if deleting them would negatively affect the `recovery_window_goal` requirement.
`RECOVERY_WINDOW_SBT`	`INTERVAL DAY(9) TO SECOND(6)`	The recovery window for backups on tape, as specified in the protection policy.
`TIMEZONE`	`VARCHAR2(64)`	The time zone offset of the protected database.
`SPACE_USAGE`	`NUMBER`	The amount of disk space (in GB) currently used by this protected database.
`KEEP_SPACE`	`NUMBER`	The amount of `KEEP` backup space (in GB) currently used by this database.
`DISK_RESERVED_SPACE`	`NUMBER`	The amount of disk space (in GB) reserved for the exclusive use of this database
`AUTOTUNE_DISK_RESERVED_SPACE`	`VARCHAR2(3)`	`YES`: The Recovery Appliance will automatically set and update `DISK_RESERVED_SPACE` as needed. `NO`: The administrator of the Recovery Appliance must set and update the `DISK_RESERVED_SPACE` manually. `INTERRUPTED`: Note: the `DISK_RESERVED_SPACE` has been manually altered.
`DISK_RESERVED_SPACE_SET`	`TIMESTAMP(6) WITH TIME ZONE`	The last time that `DISK_RESERVED_SPACE` was updated by the administrator of the Recovery Appliance.
`GUARANTEED_COPY`	`VARCHAR2(3)`	The status of the guaranteed copy setting: `YES` means that the Recovery Appliance replicates backups or copies them to tape before deleting them; `NO` means that the Recovery Appliance accepts new backups even if old backups must be purged because free space is low.
`CUMULATIVE_USAGE`	`NUMBER`	The cumulative amount of disk space (in GB) allocated for all backups received for this database.
`REPLICATION_USAGE`	`NUMBER`	The cumulative amount of disk space (in GB) replicated for this protected database.
`CLOUD_USAGE`	`NUMBER`	The cumulative amount of disk space (in GB) sent to cloud storage for this protected database.
`SBT_USAGE`	`NUMBER`	The cumulative amount of disk space (in GB) sent to SBT from this protected database.
`REPLICATION_SETUP_STATUS`	`VARCHAR2(7)`	The status of the setup for the downstream replication appliance for this database.
`LAST_OPTIMIZE`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the most recent data placement optimization was completed.
`LAST_VALIDATE`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the most recent validation of backup data was completed.
`LAST_METADATA_VALIDATE`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the most recent validation of metadata was completed.
`LAST_CROSSCHECK`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the most recent crosscheck of backup data was completed.
`STORAGE_LOCATION_COUNT`	`NUMBER`	The number of storage locations used by this database. If greater than one, then a storage location movement operation is in progress for this database.
`STORAGE_MOVEMENT_PHASE`	`VARCHAR2(18)`	The phase of the storage location movement operation for this protected database.
`SIZE_ESTIMATE`	`NUMBER`	The estimated size of the entire protected database (in GB). This does not refer to the space used by this database on the Recovery Appliance
`RECOVERY_WINDOW_SPACE`	`NUMBER`	The estimated space (in GB) that is needed to meet the recovery window goal.
`RESTORE_WINDOW`	`INTERVAL DAY(9) TO SECOND(9)`	The time range of backups used to compute the value of `RECOVERY_WINDOW_SPACE`.
`DEDUPLICATION_FACTOR`	`NUMBER`	The ratio of the total size of virtual full backups to the actual consumed space on the appliance for this protected database.
`MINIMUM_RECOVERY_NEEDED`	`INTERVAL DAY(9) TO SECOND(9)`	The minimum interval needed to restore any part of the protected database to the present if there are sufficient archive logs to perform the recovery.
`UNPROTECTED_WINDOW_THRESHOLD`	`INTERVAL DAY(9) TO SECOND(6)`	The user-specified maximum amount of data loss for protected databases that are subject to a protection policy. The Recovery Appliance generates an alert if the unprotected window of this database exceeds this value.
`UNPROTECTED_WINDOW`	`INTERVAL DAY(9) TO SECOND(9)`	The point beyond which recovery is impossible unless additional redo is available.
`NZDL_ACTIVE`	`VARCHAR2(3)`	`YES` if real-time redo transport is active. `NO` if redo has not recently been received.
`ALLOW_BACKUP_DELETION`	`VARCHAR2(3)`	The setting that controls whether RMAN backups for databases that use this protection policy can be deleted: `NO` means that the Recovery Appliance does not allow deletion of these backups; `YES` means that the Recovery Appliance allows deletion of these backups. Note that this parameter is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.7 and later.
`STORE_AND_FORWARD`	`VARCHAR2(3)`	The status of the Backup and Redo Failover setting: `YES` means that the Recovery Appliance applies the Backup and Redo Failover strategy to backups from the databases associated with this protection policy; `NO` means that the Backup and Redo Failover feature is not enabled and the Recovery Appliance applies the normal incremental-forever backup strategy instead. Note that this setting is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`AUTOTUNE_RESERVED_SPACE`	`VARCHAR2(3)`	`YES`: Recovery Appliance automatically sets and updates `disk_reserved_space` as needed. `NO`: The administrator of the Recovery Appliance must set and update `disk_reserved_space` manually.
`ENCRYPTION_TAG`	`VARCHAR2(128)`	Identifying tag for this database's encryption key. Defaults to `$<db_unique_name>_$<dbid>`
`ENCRYPTION_KEYID`	`VARCHAR2(78)`	The `keyid` for this encryption key. It may be used for lookup in the key vault.
`COMPLIANCE_HOLD`	`TIMESTAMP(6) WITH TIME ZONE`	Backups that are created after this time stamp may not be deleted.
`RECOVERY_WINDOW_COMPLIANCE`	`INTERVAL DAY(9) TO SECOND(6)`	Time interval during which backups may not be deleted after they are created.
`KEEP_COMPLIANCE`	`VARCHAR2(3)`	`YES`: The Recovery Appliance will prevent the deletion of `KEEP` backups. `NO`: The administrator of the Recovery Appliance is permitted to remove `KEEP` backups.
`LAST_PURGE`	`TIMESTAMP(6) WITH TIME ZONE`	Time of last purge attempt for database.
`COPYALL_STATE`		`NONE` This database is not receiving replication `COPYALL` backups. `IN PROGRESS` This database is in the process of receiving replicated `COPYALL` backups. `COPIED` This database has received all replicated `COPYALL` backups and is indexing them. `COMPLETE` This database has received and processed all replication `COPYALL` backups.
`COPYALL_SOURCE`		The name of the upstream Recovery Applicance replicating `COPYALL` backups.
`SECURE_MODE`		`YES` Backups must be encrypted. `NO` Backups may be stored unencrypted.
`LEVEL0_REFRESH`		The frequency at which new LEVEL 0 backups are taken automatically. If `NULL`, LEVEL 0 backups will not be taken automatically.

RA_DATABASE_HISTORY

This view lists the storage usage for each protected database.

This view has one row for each database for each day going back one year. There may be rows missing in case the DB_STATS_REFRESH task was delayed in its execution for over a day. There may also be phantom rows for deleted databases.

It is not expected that users will use this data as is. Instead, judicious "GROUP BY" clauses to the data should be applied to obtain data such as:

average space usage by database per month over the previous year.
changes in sum(recovery_window_space) across all databases per month over the previous year

Column	Data Type	NULL	Description
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of this protected database.
`DB_KEY`	`NUMBER`	`NOT NULL`	The primary key for this protected database in the Recovery Appliance.
`SAMPLE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The day when this database history record was created.
`DISK_RESERVED_SPACE`	`NUMBER`		The amount of disk space (in GB) reserved for the exclusive use of this database
`SIZE_ESTIMATE`	`NUMBER`		The estimated space (in GB) consumed by the entire protected database.
`SPACE_USAGE`	`NUMBER`		The amount of space (in GB) currently used by this protected database.
`CUMULATIVE_USAGE`	`NUMBER`		The cumulative amount of disk space (in GB) allocated for all backups received for this database.
`REPLICATION_USAGE`	`NUMBER`		The cumulative amount of disk space (in GB) replicated for this protected database.
`CLOUD_USAGE`	`NUMBER`		The cumulative amount of disk space (in GB) sent to cloud storage for this protected database.
`SBT_USAGE`	`NUMBER`		The cumulative amount of disk space (in GB) sent to SBT from this protected database.
`KEEP_SPACE`	`NUMBER`		Amount of `KEEP` backup space (in GB) currently used by this database.
`RECOVERY_WINDOW_SPACE`	`NUMBER`		The estimated space (in GB) that is needed to meet the recovery window goal.
`RESTORE_WINDOW`	`INTERVAL DAY(9) TO SECOND(9)`		Time range of backups used to estimate `recovery_window_space`.
`RECOVERY_WINDOW_GOAL`	`INTERVAL DAY(9) TO SECOND(9)`		The recovery window goal for backups on disk, as specified in the protection policy.
`MAX_RETENTION_WINDOW`	`INTERVAL DAY(9) TO SECOND(6)`		The maximum amount of time to retain disk backups.
`RECOVERY_WINDOW_SBT`	`INTERVAL DAY(9) TO SECOND(6)`		The recovery window for backups on tape, as specified in the protection policy.
`CREATION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The time when this database was added to the Recovery Appliance.
`AUTOTUNE_DISK_RESERVED_SPACE`	`VARCHAR2(16)`		If `YES`, the Recovery Appliance automatically sets and updates `disk_reserved_space` as needed. If `NO`, the administrator of the Recovery Appliance must set and update manually `disk_reserved_space`.
`DB_TIMEZONE`	`VARCHAR2(16)`		The time zone used to create the last backup.
`LOW_TIME`	`DATE`		The earliest time to which the protected database can be restored.
`HIGH_TIME`	`DATE`		The latest time to which the protected database can be restored.
`LAST_UPDATED_RR`	`DATE`		The time that the restore range for this protected database was updated.

RA_DATABASE_SYNONYM

This view lists the protected databases and their equivalent names.

Column	Data Type	Description
`DB_UNIQUE_NAME`	`VARCHAR2(512)`	The unique name of the protected database.
`DBID`	`NUMBER`	The DBID for all protected databases that are equivalent to this 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.

RA_DATABASE_STORAGE_USAGE

This view lists the storage usage for each protected database.

Column	Data Type	NULL	Description
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the protected database.
`DB_KEY`	`NUMBER`		The primary key for this protected database in the Recovery Appliance metadata database.
`STORAGE_LOCATION`	`VARCHAR2(128)`	`NOT NULL`	The name of the Recovery Appliance storage location used by this protected database.
`USED_SPACE`	`NUMBER`		The amount of space (in GB) used by this database in its Recovery Appliance storage locations. Backups for a protected database typically reside in only one storage location, but can reside in two locations when a movement operation is in progress.
`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.

RA_DB_ACCESS

This view describes which Recovery Appliance user accounts have access to which protected databases.

Column	Data Type	NULL	Description
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the Recovery Appliance user account.
`DB_UNIQUE_NAME`	`VARCHAR2(32)`		The unique name of the protected database accessed by the Recovery Appliance user account.
`DB_KEY`	`NUMBER`		The primary key for the protected database accessed by the Recovery Appliance user account.
`TENANT_KEY`	`NUMBER`		The tenant key for the protected database accessed by the Recovery Appliance user account.
`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.

RA_DISK_RESTORE_RANGE

The restore range of each protected database from disk backups on this Recovery Appliance.

Column	Data Type	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 protected database can be restored.
`HIGH_TIME`	`DATE`	The latest time to which the protected database can be restored.
`LOW_SCN`	`NUMBER`	The lowest SCN to which the protected database can be restored.
`HIGH_SCN`	`NUMBER`	The highest SCN to which the protected database can be restored.
`LOW_DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database to which `LOW_SCN` belongs.
`HIGH_DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database to which `HIGH_SCN` belongs.
`LAST_UPDATED`	`DATE`	The time that the restore range for this protected database was 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. `NULL` means the restore range consists of a `KEEP FOREVER` backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TAG`	`NUMBER`	Contains the tag value for the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_RSPNAME`	`VARCHAR2`	Contains the restore point name of the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_SCN`	`NUMBER`	Contains the recovery SCN for which the archival backups were creaed. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_TIME`	`DATE`	Contains the recovery time for which the archival backups were created. Valid only for rows with `KEEP_OPTIONS > 0`.
`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 `*'''`.

RA_EM_SBT_JOB_TEMPLATE

This view lists defined SBT jobs and their statuses for Oracle Enterprise Manager.

Column	Data Type	NULL	Description
`TEMPLATE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT job template.
`FULL_TEMPLATE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The full name of the SBT job template.
`POLICY_NAME`	`VARCHAR2(128)`		The protection policy specifying the protected databases whose backups the Recovery Appliance considers eligible for copying.
`DB_UNIQUE_NAME`	`VARCHAR2(512)`		The unique name of the protected database whose backups the Recovery Appliance considers eligible for copying.
`ATTRIBUTE_SET_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT attribute set.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT library.
`BACKUP_TYPE`	`VARCHAR2(16)`		The types of backups to be copied to tape by this job: `ALL`, `FULL`, `INCR`, `ARCH`, or `TAPE_RESERVE`.
`PRIORITY`	`NUMBER`		The priority for scheduling this job.
`COPIES`	`NUMBER`	`NOT NULL`	The number of copies to be created on tape.
`WINDOW`	`INTERVAL DAY(2) TO SECOND(6)`		The time allotted for copy tasks to start for this job.
`FROM_TAG`	`VARCHAR2(32)`		The tag for the backup to be copied to tape by this job.
`ERROR_TEXT`	`VARCHAR2(4000)`		The error text for the task that failed.
`ERROR_LAST_SEEN`	`TIMESTAMP(6) WITH TIME ZONE`		The timestamp when the Recovery Appliance most recently detected the error.
`EXECUTABLE`	`NUMBER`		The number of tasks in an executable state.
`RUNNING`	`NUMBER`		The number of tasks that are running or retrying.
`COMPLETED`	`NUMBER`		The number of completed tasks.
`COMPLETION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The time of the most recent completed task.
`STATUS`	`VARCHAR2(5)`		The status of the SBT library: `READY`, `PAUSE`, or `ERROR`.
`BYTES`	`NUMBER`		The number of bytes read or written so far.
`COMPRESSION_ALGORITHM`	`VARCHAR2(6)`		The compression algorithm used by this job: `NONE`, `BASIC`, `LOW`, `MEDIUM`, or `HIGH`. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

RA_ENCRYPTION_INFO

This view describes the historical encryption key information.

Column	Data Type	NULL	Description
`ENCINFO_KEY`	`NUMBER`	`NOT NULL`	The key of this encryption info record in the Recovery Appliance metadata database.
`DB_UNIQUE_NAME`	`VARCHAR2(32)`	`NOT NULL`	The unique name of the database for this encryption info record..
`DBID`	`NUMBER`	`NOT NULL`
`CREATE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The time at which the key was created..
`ENCRYPTION_TAG`	`VARCHAR2(128)`	`NOT NULL`	The tag associated with this encryption key..
`ENCRYPTION_KEYID`	`VARCHAR2(78)`	`NOT NULL`	The encryption id associated with this encryption key.
`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.

RA_INCIDENT_LOG

This view describes the Recovery Appliance incidents.

Column	Data Type	NULL	Description
`INCIDENT_ID`	`NUMBER`		The unique ID for the incident.
`ERROR_CODE`	`NUMBER`		The Oracle error code for the message describing the incident.
`PARAMETER`	`VARCHAR2(1000)`		The parameter qualifying the scope of the error code.
`ERROR_TEXT`	`VARCHAR2(4000)`		The text of the message for the last detection of this error condition.
`SL_KEY`	`NUMBER`		Primary key of the storage location (if any) involved in this incident
`SL_NAME`	`VARCHAR2(128)`		The primary key of the Recovery Appliance storage location (if any) involved in this incident.
`DB_KEY`	`NUMBER`		The primary key of the protected database (if any) involved in this incident.
`TENANT_KEY`	`NUMBER`		The tenant key for the protected database accessed by the Recovery Appliance user account.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the protected database (if any) involved in this incident.
`TASK_ID`	`NUMBER`		The ID for the task (if any) in which this incident was detected.
`STATUS`	`VARCHAR2(6)`		The status of this incident: `ACTIVE`, `FIXED`, or `RESET`.
`COMPONENT`	`VARCHAR2(30)`		The component of the Recovery Appliance detecting this incident.
`SEVERITY`	`VARCHAR2(47)`		The importance of this incident to the smooth operation of the Recovery Appliance.
`FIRST_SEEN`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	The timestamp when the Recovery Appliance first detected the incident.
`LAST_SEEN`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	The timestamp when the Recovery Appliance most recently detected the incident.
`SEEN_COUNT`	`NUMBER`	`NOT NULL`	The number of times that the Recovery Appliance detected the incident.
`CALL_STACK`	`VARCHAR2(4000)`		The call stack at the time of the incident.

RA_INCOMING_BACKUP_PIECES

This view describes the backup pieces being received by the Recovery Appliance.

Column	Data Type	Description
`SL_KEY`	`NUMBER`	The primary key of the Recovery Appliance storage location storing this backup piece.
`SL_NAME`	`VARCHAR2(128)`	The name of the Recovery Appliance storage location storing this backup piece.
`DB_KEY`	`NUMBER`	The primary key of the protected database creating this backup piece.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`	The unique name of the protected database creating this backup piece.
`HANDLE`	`VARCHAR2(1024)`	The handle assigned to this backup piece.
`CURRENT_SIZE`	`NUMBER`	The size (in GB) currently allocated for this backup piece.
`START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the backup piece was first seen by the Recovery Appliance.
`LAST_UPDATE`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the backup piece was completely received.
`REP_PAIR_KEY`	`NUMBER`	Join with `RA_REPLICATION_CONFIG` to determine sending upstream Recovery Appliance.
`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.

Column	Data Type	NULL	Description
`POLL_NAME`	`VARCHAR2(128)`		The name of the polling policy.
`POLL_KEY`	`NUMBER`	`NOT NULL`	The unique identifier of the polling policy.
`FILE_NAME`	`VARCHAR2(512)`		The name of the file discovered in the configured polling location.
`FILE_SIZE`	`NUMBER`		The size of the file the last time it was scanned in the polling location.
`STATUS`	`VARCHAR2(24)`		The current state of processing of the file. `PROCESSING`: file has just been recognized by Recovery Appliance as a candidate file. `COMPLETED`: file was accepted by the Recovery Appliance. `DBID NOT IN POLICY` database that created this file is not associate with the polling policy that is processing the file. `UNKNOWN FILE TYPE` file type of file is not supported by the Recovery Appliance. `ERROR IN PROCESSING FILE` an error was detected in processing the file. Check `ra_incident_log` for details. `INCOMPLETE FILE`: file was never completed written by source database. `FILE DELETED BY ZDLRA`: processing was completed and file was removed per polling policy.

RA_POLLING_POLICY

This view lists the defined backup polling policies.

Column	Data Type	NULL	Description
`POLLING_NAME`	`VARCHAR2(128)`		The name of this backup polling policy.
`POLLING_KEY`	`NUMBER`	`NOT NULL`	The primary key for this backup polling policy in the recovery catalog.
`DEST`	`VARCHAR2(4000)`	`NOT NULL`	The file system directory corresponding to the backup polling location.
`FREQUENCY`	`INTERVAL DAY(9) TO SECOND(6)`		The interval at which the Recovery Appliance scans the backup polling location for new files.
`NEXT_EXECUTE`	`TIMESTAMP(6) WITH TIME ZONE`		The next time when the polling location will be scanned.
`DELETE_INPUT`	`VARCHAR2(5)`		The deletion policy for the polling location: `TRUE` to delete files as they are accepted; `FALSE` to keep all files.

RA_PROTECTION_POLICY

This view lists the protection policies defined for this Recovery Appliance.

Column	Data Type	NULL	Description
`POLICY_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user-created name of the protection policy.
`DESCRIPTION`	`VARCHAR2(128)`		The protection policy description.
`PROT_KEY`	`NUMBER`	`NOT NULL`	The primary key for this protection policy in the Recovery Appliance metadata database.
`SL_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the Recovery Appliance storage location used by this protection policy.
`SL_KEY`	`NUMBER`	`NOT NULL`	The primary key of the Recovery Appliance storage location used by this protection policy.
`POLLING_NAME`	`VARCHAR2(128)`		The name of the backup polling policy assigned to this protection policy.
`RECOVERY_WINDOW_GOAL`	`INTERVAL DAY(9) TO SECOND(6)`		The recovery window goal for restoring backups stored on disk.
`MAX_RETENTION_WINDOW`	`INTERVAL DAY(9) TO SECOND(6)`		The maximum amount of time that the Recovery Appliance must retain disk backups.
`RECOVERY_WINDOW_SBT`	`INTERVAL DAY(9) TO SECOND(6)`		The recovery window for restoring backups stored on tape.
`UNPROTECTED_WINDOW`	`INTERVAL DAY(9) TO SECOND(6)`		The point beyond which recovery is not possible unless additional redo is available.
`GUARANTEED_COPY`	`VARCHAR2(3)`		The status of the guaranteed copy setting: `YES` means that the Recovery Appliance replicates backups or copies them to tape before deleting them; `NO` means that the Recovery Appliance accepts new backups even if old backups must be purged because free space is low.
`REPLICATION_SERVER_LIST`	`VARCHAR2(4000)`		The list of replication server configurations associated with this protection policy.
`ALLOW_BACKUP_DELETION`	`VARCHAR2(3)`		The setting that controls whether RMAN backups for databases that use this protection policy can be deleted: `NO` means that the Recovery Appliance does not allow deletion of these backups; `YES` means that the Recovery Appliance allows deletion of these backups. Note that this parameter is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.7 and later.
`STORE_AND_FORWARD`	`VARCHAR2(3)`		The status of the Backup and Redo Failover setting: `YES` means that the Recovery Appliance applies the Backup and Redo Failover strategy to backups from the databases associated with this protection policy; `NO` means that the Backup and Redo Failover feature is not enabled and the Recovery Appliance applies the normal incremental-forever backup strategy instead. Note that this setting is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`AUTOTUNE_RESERVED_SPACE`	`VARCHAR2(3)`		`YES`: Recovery Appliance automatically sets and updates `disk_reserved_space` as needed. `NO`: The administrator of the Recovery Appliance must set and update `disk_reserved_space` manually.
`LOG_COMPRESSION_ALGORITHM`	`VARCHAR2(6)`	`NOT NULL`	The status of the log compression algorithm setting: `HIGH` means that the Recovery Appliance uses RMAN `HIGH` compression for compressing archive logs; `BASIC` means that the Recovery Appliance uses RMAN `BASIC` compression for compressing archive logs; `LOW` means that the Recovery Appliance uses RMAN `LOW` compression for compressing archive logs; `MEDIUM` means that the Recovery Appliance uses RMAN `MEDIUM` compression for compressing archive logs; `OFF` means that the Recovery Appliance does not compress the archive logs.
`RECOVERY_WINDOW_COMPLIANCE`	`INTERVAL DAY(9) TO SECOND(6)`		Time interval during which backups may not be deleted after they are created.
`KEEP_COMPLIANCE`	`VARCHAR2(3)`	`NOT NULL`	`YES`: The Recovery Appliance will prevent the deletion of `KEEP` backups until their `KEEP_UNTIL` expires. The Recovery Appliance also prevents RMAN from changing the keep time for backups. `NO`: The administrator of the Recovery Appliance is permitted to remove `KEEP` backups. RMAN can change the keep time for backups.

RA_PURGING_QUEUE

This view describes the order in which protected databases will have their oldest backups deleted when space is low.

Column	Data Type	NULL	Description
`SL_NAME`	`VARCHAR2(128)`	`NOT NULL`	The Recovery Appliance storage location name.
`SL_KEY`	`NUMBER`		The primary key for this Recovery Appliance storage location in the recovery catalog.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the protected database whose backups the Recovery Appliance will purge.
`DB_KEY`	`NUMBER`	`NOT NULL`	The primary key for the protected database whose backups the Recovery Appliance will purge.
`PURGE_ORDER`	`NUMBER`		The order in which this protected database is eligible for purging.
`NEW_RECOVERY_WINDOW`	`INTERVAL DAY(9) TO SECOND(6)`		The recovery window goal for this protected database after a purge.
`NEW_PCT_RECOVERY`	`NUMBER`		The percentage of the recovery window goal remaining for this protected database after a purge.
`PCT_STORAGE`	`NUMBER`		The percentage of reserved space being consumed by this protected 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.

RA_RECOVERY_COMPLIANCE

This view lists information about active compliance windows on the database in which backups may not be deleted..

Column	Data Type	NULL	Description
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique database name.
`DB_KEY`	`NUMBER`	`NOT NULL`	The primary key for this database in the recovery catalog.
`DURATION`	`INTERVAL DAY(9) TO SECOND(9)`	`NOT NULL`	Required retention period for backups created while this compliance policy is active.
`START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	Starting time when this compliance policy goes into effect.
`END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Ending time when this compliance policy expires. `NULL` means that this compliance policy is still active.
`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.

RA_REPLICATION_CONFIG

This view lists the replication server configurations.

Column	Data Type	NULL	Description
`REPLICATION_SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user-assigned name of the replication server configuration.
`REPLICATION_SERVER_STATE`	`VARCHAR2(21)`		The replication status of the downstream Recovery Appliance: `AVAILABLE`, `CREATING`, `DELETING`, `TESTING COMMUNICATION`, `RUNNING`, `PAUSED`, `ERROR STATE` or null.
`REPLICATION_SERVER_ROLE`	`VARCHAR2(10)`		The user-assigned name of the replication server configuration.
`CATALOG_OWNER`	`VARCHAR2(128)`	`NOT NULL`	The owner of the Recovery Catalog schema that will be connecting to the DS Recovery Appliance.
`PROXY_HTTP_ADDRESS`	`VARCHAR2(519)`		The address of the proxy server in the form `proxy_server_http_address:port_of_proxy_server`.
`PROXY_TIMEOUT`	`NUMBER`		The timeout period (in seconds) for the proxy server connection.
`SBT_LIBRARY_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT library with which this replication server configuration is associated.
`SBT_LIBRARY_PARMS`	`VARCHAR2(1024)`		The SBT library parameters.
`ATTRIBUTE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT attribute set name.
`ATTRIBUTE_PARMS`	`VARCHAR2(1024)`		The SBT parameters passed while allocating the RMAN channel.
`WALLET_PATH`	`VARCHAR2(512)`		The path to the local Oracle wallet (excluding the wallet file name).
`WALLET_ALIAS`	`VARCHAR2(512)`	`NOT NULL`	The alias that identifies the Oracle wallet credentials that this Recovery Appliance uses to log in to the downstream Recovery Appliance.
`SERVER_HOST`	`CLOB`	`NOT NULL`	The server name or address of the downstream Recovery Appliance.
`MAX_STREAMS`	`NUMBER`	`NOT NULL`	The maximum number of simultaneous replication tasks. Each replication task processes a single backup piece.
`PAIRED_REPLICATION_SERVER`	`VARCHAR2(3)`		`YES` if this replication server is paired with another replication server. Examine `RA_REPLICATION_PAIR` for additional information.
`REP_PAIR_KEY`	`NUMBER`		Cross reference to `RA_REPLICATION_PAIR` view
`REPLICATION_SERVER_KEY`	`NUMBER`		Cross reference to associated `RA_REPLICATION_PAIR_*` views

RA_REPLICATION_DATABASE

This view lists information on replication servers and protected databases.

Column	Data Type	NULL	Description
`DB_UNIQUE_NAME`	`VARCHAR2(128)`		The unique name of the protected database.
`DB_KEY`	`NUMBER`	`NOT NULL`	The primary key for this protected database in the Recovery Appliance metadata database.
`REPLICATION_SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user-assigned name of the replication server.
`REPLICATION_SERVER_KEY`	`NUMBER`	`NOT NULL`	Cross reference to other `RA_*` views and `server.server_key`.
`REPLICATION_SERVER_STATE`	`VARCHAR2(18)`		The possible replication server status are: AVAILABLE CREATING DELETING TESTING CONNECTION RUNNING PAUSED ERROR STATE
`REPLICATION_DATABASE_STATE`	`VARCHAR2(7)`	`NOT NULL`	The possible database replication status are: AVAILABLE CREATING DELETING TESTING CONNECTION RUNNING PAUSED ERROR STATE null
`POLICY_NAME`	`VARCHAR2(128)`	`NOT NULL`	The protection policy that is associated with this replication server and database.
`FAILURE_CNT`	`NUMBER`	`NOT NULL`	The number of conseceutive failures this database has had replicating to this replication server.
`LAST_RECONCILE`	`TIMESTAMP(6) WITH TIME ZONE`		The time of the last successful reconcile for this database and replication server.
`NEXT_RECONCILE`	`TIMESTAMP(6) WITH TIME ZONE`		The time of the next reconcile for this database and replication server.
`LAST_REPLICATION`	`TIMESTAMP(6) WITH TIME ZONE`		The time of the last successful replication for this database and replication server.
`PENDING_REPLICATION_SETUP`	`VARCHAR2(3)`		If `YES`, an initial connection, reconcile and replication is still pending. If `NO`, initial replication setup is complete.
`FIXED_SECTION_UPDATE`	`TIMESTAMP(6) WITH TIME ZONE`		The time of the most recent fixed section update from the client database that has not yet been reconciled to this replication server.
`REP_RSDB_KEY`	`NUMBER`	`NOT NULL`	Cross reference to other `RA_*` views
`REP_SERVER_KEY`	`NUMBER`	`NOT NULL`	Cross reference to other `RA_*` views

RA_REPLICATION_PAIR

This view lists replication information for replicating protection policies.

Column	Data Type	NULL	Description
`REPLICATION_SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user-assigned name of the replication server configuration. If we are an upstream to this remote Recovery Appliance, the user-assigned name of the replication server.
`REPLICATION_SERVER_STATE`	`VARCHAR2(21)`		The replication status of the downstream Recovery Appliance: `AVAILABLE`, `CREATING`, `DELETING`, `TESTING COMMUNICATION`, `RUNNING`, `PAUSED`, `ERROR STATE` or null.
`REPLICATION_SERVER_ROLE`	`VARCHAR2(10)`		shows the role of this Recovery Appliance with associated with another Recovery Appliance: `UPSTREAM`, `DOWNSTREAM`, or `PAIRED`.
`REMOTE_RA_DBID`	`NUMBER`		Information from the downstream Recovery Appliance. The `v$database.dbid` of the downstream Recovery Appliance.
`REMOTE_RA_DBUNAME`	`VARCHAR2(30)`		Information from the downstream Recovery Appliance. The `v$database.name` of the downstream Recovery Appliance.
`REMOTE_CONNECTING_USERNAME`	`VARCHAR2(128)`		Incoming replication user from the downstream Recovery Appliance.
`REMOTE_CONNECTING_USER_ID`	`NUMBER`		Incoming replication `user_id` from the downstream Recovery Appliance.
`REMOTE_VERSION`	`VARCHAR2(256)`		Information from the downstream Recovery Appliance. ZDLRA software version string from `sys.raa_versions.release_version`.
`REMOTE_CVERSION`	`VARCHAR2(256)`		Information from the downstream Recovery Appliance. Comparable ZDLRA software version string from `sys.raa_versions.release_version`.
`REMOTE_BUILD_STRING`	`VARCHAR2(100)`		Information from the downstream Recovery Appliance `config._build` string.
`REMOTE_VERSION_RECONCILE`	`NUMBER`	`NOT NULL`	Cross reference to associated `RA_REPLICATION_*` views.
`REPLICATION_SERVER_KEY`	`NUMBER`		Cross reference to associated `RA_REPLICATION_*` views

RA_REPLICATION_POLICY

This view lists the association of replication servers to protection policy.

Column	Data Type	NULL	Description
`REPLICATION_SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user-assigned name of the replication server configuration.
`REPLICATION_SERVER_STATE`	`VARCHAR2(21)`		The replication status of the downstream Recovery Appliance: `AVAILABLE`, `CREATING`, `DELETING`, `TESTING CONNECTION`, `RUNNING`, `PAUSED`, `ERROR STATE` or null.
`POLICY_NAME`	`VARCHAR2(128)`		The protection policy associated with this replication server configuration.
`READ_ONLY`	`VARCHAR2(3)`		`YES`: The downstream Recovery Appliance is treated as a read-only device. Backups can be retrieved from the downstream but are not replicated.
`REQUEST_ONLY`	`VARCHAR2(3)`		`YES`: The downstream Recovery Appliance is treated as a request-only device. `REQUEST_ONLY` implies `READ_ONLY`, but only the requested backups are sent from the downstream.
`REPLICATION_SERVER_KEY`	`NUMBER`	`NOT NULL`	Cross reference to other `RA_REPLICATION_*` views
`STORE_AND_FORWARD`	`VARCHAR2(3)`		`YES` when Recovery Appliance is being used to store backups temporarily until they can be moved downstream. `NO` for normal disaster recovery support.

RA_RESTORE_RANGE

This view describes the restore range of each protected database from all backups on this Recovery Appliance.

Column	Data Type	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 protected database can be restored.
`HIGH_TIME`	`DATE`	The latest time to which the protected 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 protected 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 database was 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. `NULL` means the restore range consists of a `KEEP FOREVER` backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TAG`	`NUMBER`	Contains the tag value for the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_RSPNAME`	`VARCHAR2`	Contains the restore point name of the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_SCN`	`NUMBER`	Contains the recovery SCN for which the archival backups were creaed. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_TIME`	`DATE`	Contains the recovery time for which the archival backups were created. Valid only for rows with `KEEP_OPTIONS > 0`.
`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 `*'''`.

RA_REQUEST_BACKUP

This view describes the list of requested backup pieces from a remote Recovery Appliance.

Column	Data Type	NULL	Description
`RRA_REQUEST_BACKUP_KEY`	`NUMBER`	`NOT NULL`	The key of this request record.
`GROUP#`	`NUMBER`		All backups with this group# are part of a single request group.
`BATCH_ID`	`NUMBER`		All backups with this batch_id were requested at the same time.
`REP_PAIR_KEY`	`NUMBER`		The key to the replication pair record.
`BP_KEY`	`NUMBER`		The local `bp_key` of the bp record being requested.
`DB_KEY`	`NUMBER`		The local `db_key` of the owner of the backup piece being requested.
`HANDLE`	`VARCHAR2(1024)`		The handle of the backup piece being requested.
`SET_STAMP`	`NUMBER`		The set_stamp of the backup piece being requested.
`SET_COUNT`	`NUMBER`		The set_count of the backup piece being requested.
`PIECE#`	`NUMBER`		The piece# of the backup piece being requested.
`CREATE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The time at which the backup request record was created.
`LAST_STATUS_UPDATE`	`TIMESTAMP(6) WITH TIME ZONE`		The most recent time at which the backup request record was updated.
`STATUS`	`VARCHAR2(13)`		The most recent status of the backup request record.
`DB_UNIQUE_NAME`	`VARCHAR2(32)`	`NOT NULL`	The unique name of the database for this encryption info record..
`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.

RA_SBT_ATTRIBUTE_SET

This view describes the defined SBT attribute set.

Column	Data Type	NULL	Description
`ATTRIBUTE_SET_KEY`	`NUMBER`	`NOT NULL`	The key of this SBT attribute set in the Recovery Appliance metadata database.
`ATTRIBUTE_SET_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT attribute set name.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT library object with which this attribute set is associated.
`STREAMS`	`NUMBER`		The number of parallel streams available for jobs that run with this attribute set.
`POOLID`	`NUMBER`		The media pool identifier.
`PARMS`	`VARCHAR2(1024)`		The SBT parameters passed while allocating the RMAN channel.
`SEND`	`VARCHAR2(1024)`		The `SEND` command string passed to the allocated channel.

RA_SBT_JOB

This view describes the defined SBT job templates.

Column	Data Type	NULL	Description
`TEMPLATE_KEY`	`NUMBER`	`NOT NULL`	The key of this SBT job template in the Recovery Appliance metadata database.
`TEMPLATE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT job template name.
`ATTRIBUTE_SET_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT attribute set name.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT library name.
`POLICY_NAME`	`VARCHAR2(128)`		The protection policy specifying databases whose backups the Recovery Appliance considers eligible for copying to tape.
`DB_KEY`	`NUMBER`		The primary key of the protected database whose backups the Recovery Appliance considers eligible for copying to tape.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the protected database whose backups the Recovery Appliance considers eligible for copying to tape.
`BACKUP_TYPE`	`VARCHAR2(16)`		The types of backups to be copied to tape by this job: `ALL`, `FULL`, `INCR`, `ARCH`, or `TAPE_RESERVE`.
`FROM_TAG`	`VARCHAR2(32)`		The backups with the specified tag to be copied to tape by this job.
`PRIORITY`	`NUMBER`		The priority for scheduling this job.
`COPIES`	`NUMBER`	`NOT NULL`	The number of copies to be created on tape.
`LAST_SCHEDULE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The last time at which this SBT job was scheduled to run.
`WINDOW`	`INTERVAL DAY(2) TO SECOND(6)`		The time allotted for copy tasks to start for this job.
`COMPRESSION_ALGORITHM`	`VARCHAR2(6)`		The compression algorithm used by this job: `NONE`, `BASIC`, `LOW`, `MEDIUM`, `HIGH`, or `OFF`. `OFF` indicates that compression was explicitly turned off for this job (the compression setting in the SBT job template was ignored). Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`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.

RA_SBT_LIBRARY

This view lists the defined SBT libraries.

Column	Data Type	NULL	Description
`LIB_KEY`	`NUMBER`	`NOT NULL`	The key of this SBT library in the Recovery Appliance metadata database.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The SBT library name.
`DRIVES`	`NUMBER`	`NOT NULL`	The number of drives available for use by this SBT library.
`RESTORE_DRIVES`	`NUMBER`	`NOT NULL`	The number of drives reserved for restore operations.
`PARMS`	`VARCHAR2(1024)`		The SBT parameters passed while allocating an RMAN channel.
`SEND`	`VARCHAR2(1024)`		The `SEND` command string passed to the allocated channel.
`REQUIRES_ENCRYPTION`	`VARCHAR2(3)`	`NOT NULL`	This library requires backups to be sent out encrypted.
`STATUS`	`VARCHAR2(5)`		The SBT library status: `READY`, `PAUSE`, `ERROR`, or null.
`LIBTYPE`	`VARCHAR2(11)`		Specifies the type of the library. Values are: `CLOUD`, `TAPE`, and `REPLICATION`
`GUARANTEED`	`VARCHAR2(3)`	`NOT NULL`	`YES`: Library may be used as a backing store for `GUARANTEED COPY`. `NO` Library may not be used as a backing store for the `GUARANTEED COPY`.
`IMMUTABLE`	`VARCHAR2(3)`	`NOT NULL`	`YES`: Library may be used as a backing store for `KEEP_COMPLIANCE`. `NO`: Library may not be used as a backing store for the `KEEP_COMPLIANCE`.
`LAST_ERROR_TEXT`	`VARCHAR2(4000)`		The most recent error text of the task that failed.

RA_SBT_RESTORE_RANGE

This view describes the restore range of each database from SBT backups on the Recovery Appliance.

Column	Data Type	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. `NULL` means the restore range consists of a `KEEP FOREVER` backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TAG`	`NUMBER`	Contains the tag value for the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_RSPNAME`	`VARCHAR2`	Contains the restore point name of the archival backup. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_SCN`	`NUMBER`	Contains the recovery SCN for which the archival backups were creaed. Valid only for rows with `KEEP_OPTIONS > 0`.
`KEEPBKP_TO_TIME`	`DATE`	Contains the recovery time for which the archival backups were created. Valid only for rows with `KEEP_OPTIONS > 0`.
`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 `*'''`.

RA_SBT_TASK

This view lists the queued background SBT tasks and their run statuses.

Column	Data Type	NULL	Description
`TASK_ID`	`NUMBER`		The ID for the task.
`STATE`	`VARCHAR2(47)`		The processing state for the task: `EXECUTABLE`, `RUNNING`, `COMPLETED`, `TASK_WAIT`, `FAILED`, and so on.
`COMPLETION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The timestamp for task completion. The column is null if the task is not complete.
`ELAPSED_SECONDS`	`NUMBER`		The elapsed run time (in seconds) for the task.
`EXECUTE_INSTANCE_ID`	`NUMBER`		The ID of the database instance ID on which the task must run. The column is null if the task can run on any instance.
`ERROR_COUNT`	`NUMBER`		The number of times that the task had errors.
`ERROR_TEXT`	`VARCHAR2(4000)`		The error text for the task that failed.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the protected database for which the task is running.
`DB_KEY`	`NUMBER`		The primary key of the protected database for which the task is running.
`RESTORE_TASK`	`VARCHAR2(3)`		The type of task: `YES` if this is a restore task; `NO` if this is a backup task.
`BS_KEY`	`NUMBER`		The key of the backup set that is accessed by this task.
`PIECE#`	`NUMBER`		The number of the backup piece that is accessed by this task.
`COPIES`	`NUMBER`		The number of copies created by this task.
`TEMPLATE_NAME`	`VARCHAR2(128)`		The SBT job template to which this task belongs.
`ATTRIBUTE_SET_NAME`	`VARCHAR2(128)`		The name of the SBT attribute set to which this task belongs.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT library used by this task.
`COMPRESSION_ALGORITHM`	`VARCHAR2(6)`		The compression algorithm used by this task: `NONE`, `BASIC`, `LOW`, `MEDIUM`, `HIGH`, or `OFF`. `OFF` indicates that compression was explicitly turned off for this task (the compression setting in the SBT job template was ignored).
`ENCRYPTION_ALGORITHM`	`VARCHAR2(6)`		Encryption algorithm used by this task.
`REPLICATION`	`VARCHAR2(3)`		The type of task: `YES` if this is a replication task; `NO` if this is an SBT task.
`FILENAME`	`VARCHAR2(513)`		The name of the backup file being read or written.
`START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The start time of this task.
`BYTES`	`NUMBER`		The number of bytes read or written so far.
`TOTAL`	`NUMBER`		The total number of bytes to be read or written.
`IS_GROUP_BACKUP`	`VARCHAR2(3)`		`YES` means that the backup was created by assembling a set of individual archive logs into a bigger piece to improve tape performance. `NO` means that the backup was created by individual archive logs.
`LIB_KEY`	`NUMBER`	`NOT NULL`	Key for tape/replication library used by task.
`STATUS`	`VARCHAR2(5)`		The SBT library status: `READY`, `PAUSE`, `ERROR`, or null.
`LIB_TYPE`	`VARCHAR2(11)`		Specifies the type of library.
`ARCHIVED`	`CHAR(1)`		`N` if this is a current task, `Y` if this is a completed task.
`KEEP_OPTIONS`	`NUMBER`		The keep options of the backup set that is accessed by this task
`KEEP_UNTIL`	`TIMESTAMP(6) WITH TIME ZONE`		The retention time of the backup set that is accessed by this task.
`TAG`	`VARCHAR2(128)`		The user specified tag for copied piece that is accessed by this task.

RA_SBT_TEMPLATE_MDF

This view lists missing level 0 data file backups for each SBT template.

Column	Data Type	NULL	Description
`TEMPLATE_KEY`	`NUMBER`	`NOT NULL`	The key identifying the SBT template.
`DB_KEY`	`NUMBER`	`NOT NULL`	The key for the protected database that contains the missing file.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of the database that contains the missing data file.
`DF_FILE#`	`NUMBER`		The number of the missing data file.
`DF_TS#`	`NUMBER`		The tablespace number of the missing data file.
`DF_PLUGIN_CHANGE#`	`NUMBER`		The plugin SCN for the missing data file.
`DF_FOREIGN_DBID`	`NUMBER`		The foreign DBID for the database that contains the missing data file.
`DF_TABLESPACE`	`VARCHAR2(30)`		The tablespace that contains the missing data file.
`DF_CREATION_CHANGE#`	`NUMBER`		The creation SCN for the missing data file.
`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.

RA_SERVER

This view describes the current settings for the Recovery Appliance.

Column	Data Type	Description
`STATE`	`VARCHAR2(13)`	The state of the Recovery Appliance: `ON` if the Recovery Appliance is running; `OFF` if it is not active.
`NETWORK_CHUNKSIZE`	`NUMBER`	The size (in MB) of network messages used by the Recovery Appliance client module to communicate with the Recovery Appliance.
`SCHEDULERS`	`NUMBER`	The number of normal schedulers currently running on the Recovery Appliance. This number excludes special purpose schedulers used for tape, replication, purge_immediate, or restore operations. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`RESOURCE_WAIT_TASK_LIMIT`	`VARCHAR2(48)`	The limitations on task concurrency caused by resource waits.
`CURRENT_RUN_TIME`	`INTERVAL DAY(9) TO SECOND(9)`	Interval for which the Recovery Appliance has been continuously operating.

RA_STORAGE_HISTOGRAM

This view describes the storage allocation history for recent time periods.

Column	Data Type	NULL	Description
`NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the Recovery Appliance storage location.
`SL_KEY`	`NUMBER`	`NOT NULL`	The primary key for this Recovery Appliance storage location in the recovery catalog.
`SLOT`	`NUMBER`		The slot (ordered by sampling time period) in the histogram.
`USAGE`	`NUMBER`		The amount of space (in GB) that was allocated during the histogram slot.

RA_STORAGE_LOCATION

This view lists defined Recovery Appliance storage locations and their allocations.

Column	Data Type	NULL	Description
`NAME`	`VARCHAR2(128)`	`NOT NULL`	The Recovery Appliance storage location name.
`SL_KEY`	`NUMBER`	`NOT NULL`	The primary key for this Recovery Appliance storage location in the recovery catalog.
`DISK_GROUPS`	`VARCHAR2(4000)`		The list of names of Oracle ASM disk groups used for storage.
`MIN_ALLOC`	`NUMBER`		The minimum amount of storage (in GB) that may be allocated.
`TOTAL_SPACE`	`NUMBER`		The maximum amount of storage (in GB) that the Recovery Appliance storage location can use for backup data.
`USED_SPACE`	`NUMBER`		The amount of space (in GB) currently used in the Recovery Appliance storage location.
`FREESPACE`	`NUMBER`		The amount of space (in GB) available for immediate use.
`FREESPACE_GOAL`	`NUMBER`		The expected free space requirement (in GB) based on usage history. Purges may occur to meet this goal.
`LAST_CHECK_FILES`	`TIMESTAMP(6) WITH TIME ZONE`		The most recent time that files were checked for consistency.
`SYSTEM_PURGING_SPACE`	`NUMBER`		The amount of space (in GB) reserved for purging operations.
`PURGING_DB_KEY`	`NUMBER`		The `db_key` for the database (if it exists) currently being purged in storage location.
`UNRESERVED_SPACE`	`NUMBER`		The remaining space (in GB) that is available to be assigned to database disk space reservations.
`AUTOTUNE_SPACE_LIMIT`	`NUMBER`		The maximum database `reserved_space` size (In GB) for which autotuning will perform unlimited `reserved_space` growth. `NULL` implies no limit.

RA_STORAGE_LOCATION_HISTORY

This view contains a daily history of storage location for the for the previous year. It has one row for each storage location for each day going back a year. It may contain phantom rows for storage locations that were deleted.

This data is not expected to be used as-is, but rather as part of GROUP BY classes in order to obtain data such as:

Average space usage in the storage location per month over the year.
Minimum or maximum free space goal in the previous year.

Column	Data Type	NULL	Description
`SAMPLE_TIME`	`NUMBER`		The day when this storage location history record was created.
`NAME`	`VARCHAR2(128)`	`NOT NULL`	The Recovery Appliance storage location name.
`SL_KEY`	`NUMBER`	`NOT NULL`	The primary key for this Recovery Appliance storage location in the recovery catalog.
`TOTAL_SPACE`	`NUMBER`		The maximum amount of storage (in GB) that the Recovery Appliance storage location can use for backup data.
`USED_SPACE`	`NUMBER`		The amount of space (in GB) currently used in the Recovery Appliance storage location.
`FREESPACE`	`NUMBER`		The amount of space (in GB) available for immediate use.
`FREESPACE_GOAL`	`NUMBER`		The expected free space requirement (in GB) based on usage history. Purges may occur to meet this goal.
`UNRESERVED_SPACE`	`NUMBER`		The remaining space (in GB) that is available to be assigned to the database disk space reservation.

RA_TASK

This view lists queued background tasks and their run statuses.

Column	Data Type	Description
`TASK_ID`	`NUMBER`	The ID for the task.
`TASK_TYPE`	`VARCHAR2(30)`	The type of processing performed by the task.
`PRIORITY`	`NUMBER`	The run priority for the task.
`STATE`	`VARCHAR2(47)`	The processing state for the task: `EXECUTABLE`, `RUNNING`, `COMPLETED`, `TASK_WAIT`, `FAILED`, and so on.
`WAITING_ON`	`NUMBER`	The ID of the task that is blocking this task when its state is `TASK_WAIT`.
`WAITING_ON_TASK_TYPE`	`VARCHAR2(30)`	The `task_type` of the `WAITING_ON` task.
`WAITING_ON_STATE`	`VARCHAR2(21)`	The task state of the `WAITING_ON` task.
`CREATION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The time of task creation.
`COMPLETION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The timestamp for task completion. The column is null if the task is not complete.
`ELAPSED_SECONDS`	`NUMBER`	The elapsed run time (in seconds) for the task.
`ERROR_COUNT`	`NUMBER`	Number of times that the task had errors
`INTERRUPT_COUNT`	`NUMBER`	The number of times that the task was interrupted.
`LAST_INTERRUPT_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The most recent time that the task was interrupted.
`EXECUTE_INSTANCE_ID`	`NUMBER`	The ID of the database instance on which the task must run. The column is null if the task can run on any instance.
`LAST_EXECUTE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	The most recent time that the task was restarted.
`DB_UNIQUE_NAME`	`VARCHAR2(30)`	The unique name of the protected database for which the task is running.
`DB_KEY`	`NUMBER`	The primary key of the protected database for which the task is running.
`SL_NAME`	`VARCHAR2(128)`	The name of the Recovery Appliance storage location used by the task.
`SL_KEY`	`NUMBER`	The primary key of the Recovery Appliance storage location used by the task.
`OSPID`	`VARCHAR2(128)`	The platform-specific ID of the process in which the task is current running.
`INSTANCE_ID`	`NUMBER`	The ID of the database instance on which the task is currently running.
`LAST_INCIDENT_ID`	`NUMBER`	The ID of the last incident reported by the task that is currently running. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`BP_KEY`	`NUMBER`	The key of the backup piece that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`BS_KEY`	`NUMBER`	The key of the backup set that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`DF_KEY`	`NUMBER`	The key of the data file that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`VB_KEY`	`NUMBER`	The key of the virtual backup that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`HANDLE`	`VARCHAR2(1000)`	The media manager handle that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`FILENAME`	`VARCHAR2(4000)`	The name of the backup file that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`LIB_KEY`	`NUMBER`	The unique identifier of the SBT library that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`ARCHIVED`	`CHAR(1)`	The archive status of the task: `Y` if it has moved to the archive; otherwise, `N`.
`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.

RA_TIMER_TASK

Timer process tasks and their planned executions.

Column	Data Type	Description
`TIMER_TYPE`	`VARCHAR2(54)`	Purpose for running this timer task.
`NEXT_EXECUTE`	`TIMESTAMP(6) WITH TIME ZONE`	Next planned execution for this timer task.
`TIMER_INTERVAL`	`INTERVAL DAY(9) TO SECOND(6)`	Frequency for repeating this timer task.
`KEY`	`NUMBER`	The poll_key, db_key, or lib_key operated referenced by this timer task.

RA_TIME_USAGE

This view describes the Recovery Appliance elapsed and idle time for the last 30 days.

Column	Data Type	NULL	Description
`TOTAL_TIME`	`NUMBER`		The sum of the elapsed times (in seconds) across all sessions.
`IDLE_TIME`	`NUMBER`		The sum of the idle times (in seconds) across all sessions.