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.