14 Recovery Appliance View Reference

Describes the available Recovery Appliance views.

Summary of Recovery Appliance Views

Table 14-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.

RA_ACTIVE_SESSION

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

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

RA_API_HISTORY

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

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

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

RA_DATABASE

This view lists the databases protected by this Recovery Appliance.

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

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.

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.

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.

RA_DISK_RESTORE_RANGE

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

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

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.

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.

RA_INCOMING_BACKUP_PIECES

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

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

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.

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.

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.

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.

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.

RA_RESTORE_RANGE

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

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

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.

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.

RA_SBT_RESTORE_RANGE

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

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

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.

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.

RA_SERVER

This view describes the current settings for the Recovery Appliance.

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

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.

RA_TASK

This view lists queued background tasks and their run statuses.

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

RA_TIMER_TASK

Timer process tasks and their planned executions.

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