13 Recovery Appliance View Reference

Describes the available Recovery Appliance views.

13.1 Summary of Recovery Appliance Views

Table 13-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_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_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_REPLICATION_SERVER`	This view lists the replication server configurations.
`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_TASK`	This view lists queued background tasks and their run statuses.
`RA_TIME_USAGE`	This view describes the Recovery Appliance elapsed and idle time for the last 30 days.

13.2 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.

13.3 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.

13.4 RA_CONFIG

This view lists the user configuration settings.

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

13.5 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.
`DBID`	`NUMBER`	The DBID for this protected database.
`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 space used to hold `KEEP` backups for the database. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`DISK_RESERVED_SPACE`	`NUMBER`	The amount of disk space (in GB) reserved for the exclusive use of this database
`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.
`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_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 space (in GB) consumed by the entire protected 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)`	The time range used to compute the value of `RECOVERY_WINDOW_SPACE`. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`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 the protected database to the present.
`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.

13.6 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.

13.7 RA_DATABASE_SYNONYM

This view lists the protected databases and their equivalent names.

Column	Data Type	NULL	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.

13.8 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.

13.9 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.
`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.

13.10 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.

13.11 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.
`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.

13.12 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. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`LAST_UPDATE`	`TIMESTAMP(6) WITH TIME ZONE`	The time when the backup piece was completely received.

13.13 RA_POLLING_FILES

This view describes the set of files the Recovery Appliance backed up from the configured polling location.

Note that this view is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

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.

13.14 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. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.
`DELETE_INPUT`	`VARCHAR2(5)`		The deletion policy for the polling location: `TRUE` to delete files as they are accepted; `FALSE` to keep all files.

13.15 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.

13.16 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.

13.17 RA_REPLICATION_SERVER

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`, or null.
`PROTECTION_POLICY`	`VARCHAR2(128)`		The protection policy associated with this replication server configuration.
`REP_SERVER_CONNECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	The user name used to connect to the downstream 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 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`		The maximum number of simultaneous replication tasks. Each replication task processes a single backup piece. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

13.18 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.
`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.

13.19 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.

13.20 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.

13.21 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.
`STATUS`	`VARCHAR2(5)`		The SBT library status: `READY`, `PAUSE`, `ERROR`, or null.
`LAST_ERROR_TEXT`	`VARCHAR2(4000)`		The most recent error text of the task that failed.

13.22 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.
`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.

13.23 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.
`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.
`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). Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

13.24 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.

13.25 RA_SERVER

This view describes the current settings for the Recovery Appliance.

Column	Data Type	Description
`STATE`	`VARCHAR2(10)`	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.

13.26 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.

13.27 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.

13.28 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`.
`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`.

13.29 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.