Recovery Appliance View Reference

Table 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_MIRROR`	This view lists the SBT libraries that are being mirrored with remote Recovery Appliances.
`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.