RA_DATABASE

This view lists the databases protected by this Recovery Appliance.

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