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.
STATE VARCHAR2(12)  

ACTIVE if this database is currently in active use.

DELETING if this database is currently being deleted.

SUSPENDING if this database is currently being suspended

SUSPENDED if this database is currently suspended.

UNREGISTERED if this database is currently unregistered.

PROVISIONAL if a database is created under a AUTOTUNE_RESERVED_SPACE policy that cannot allocate its initial reserved space because there is no room in the storage locaiton.

DBID NUMBER   The DBID for this protected database.
TENANT_NAME VARCHAR2   The tenant name for this database in the Recovery Appliance.
TENANT_CSI NUMBER   The customer tenant identifier for this database in the Recovery Appliance.
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 amount of KEEP backup space (in GB) currently used by this database.
DISK_RESERVED_SPACE NUMBER   The amount of disk space (in GB) reserved for the exclusive use of this database
AUTOTUNE_DISK_RESERVED_SPACE VARCHAR2(3)  

YES: The Recovery Appliance will automatically set and update DISK_RESERVED_SPACE as needed.

NO: The administrator of the Recovery Appliance must set and update the DISK_RESERVED_SPACE manually.

INTERRUPTED: Note: the DISK_RESERVED_SPACE has been manually altered. This state remains until RECOVERY_WINDOW_GOAL days after the last time DISK_RESERVED_SPACE was explicitly set. During the INTERRUPTED state, autotune will never modify the reserved space to a value below what it was previously set at.

DISK_RESERVED_SPACE_SET TIMESTAMP(6) WITH TIME ZONE   The last time that DISK_RESERVED_SPACE was updated by the administrator of the Recovery Appliance.
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.
CLOUD_USAGE NUMBER   The cumulative amount of disk space (in GB) sent to cloud storage 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_METADATA_VALIDATE TIMESTAMP(6) WITH TIME ZONE   The time when the most recent validation of metadata 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 size of the entire protected database (in GB).

This does not refer to the space used by this database on the Recovery Appliance
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 of backups used to compute the value of RECOVERY_WINDOW_SPACE.
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 any part of the protected database to the present if there are sufficient archive logs to perform the recovery.
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.
AUTOTUNE_RESERVED_SPACE VARCHAR2(3)  

YES: Recovery Appliance automatically sets and updates disk_reserved_space as needed.

NO: The administrator of the Recovery Appliance must set and update disk_reserved_space manually.

ENCRYPTION_TAG VARCHAR2(128)   Identifying tag for this database’s encryption key. Defaults to $<db_unique_name>_$<dbid>
ENCRYPTION_KEYID VARCHAR2(78)   The keyid for this encryption key. It may be used for lookup in the key vault.
COMPLIANCE_HOLD TIMESTAMP(6) WITH TIME ZONE   Backups that are created after this time stamp may not be deleted.
RECOVERY_WINDOW_COMPLIANCE INTERVAL DAY(9) TO SECOND(6)   Time interval during which backups may not be deleted after they are created.
KEEP_COMPLIANCE VARCHAR2(3)  

YES: The Recovery Appliance will prevent the deletion of KEEP backups.

NO: The administrator of the Recovery Appliance is permitted to remove KEEP backups.

LAST_PURGE TIMESTAMP(6) WITH TIME ZONE   Time of last purge attempt for database.
COPYALL_STATE    

NONE This database is not receiving replication COPYALL backups.

IN PROGRESS This database is in the process of receiving replicated COPYALL backups.

COPIED This database has received all replicated COPYALL backups and is indexing them.

COMPLETE This database has received and processed all replication COPYALL backups.

COPYALL_SOURCE     The name of the upstream Recovery Applicance replicating COPYALL backups.
SECURE_MODE    

YES Backups must be encrypted.

NO Backups may be stored unencrypted.

LEVEL0_REFRESH     The frequency at which new LEVEL 0 backups are taken automatically. If NULL, LEVEL 0 backups will not be taken automatically.