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.