RA_DATABASE_HISTORY

This view lists the storage usage for each protected database.

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.

It is not expected that users will use this data as is. Instead, judicious "GROUP BY" clauses to the data should be applied to obtain data such as:

average space usage by database per month over the previous year.
changes in sum(recovery_window_space) across all databases per month over the previous year

Column	Data Type	NULL	Description
`DB_UNIQUE_NAME`	`VARCHAR2(30)`		The unique name of this protected database.
`DB_KEY`	`NUMBER`	`NOT NULL`	The primary key for this protected database in the Recovery Appliance.
`SAMPLE_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The day when this database history record was created.
`DISK_RESERVED_SPACE`	`NUMBER`		The amount of disk space (in GB) reserved for the exclusive use of this database
`SIZE_ESTIMATE`	`NUMBER`		The estimated space (in GB) consumed by the entire protected database.
`SPACE_USAGE`	`NUMBER`		The amount of space (in GB) currently used by this protected database.
`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.
`KEEP_SPACE`	`NUMBER`		Amount of `KEEP` backup space (in GB) currently used by this 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)`		Time range of backups used to estimate `recovery_window_space`.
`RECOVERY_WINDOW_GOAL`	`INTERVAL DAY(9) TO SECOND(9)`		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.
`RECOVERY_WINDOW_SBT`	`INTERVAL DAY(9) TO SECOND(6)`		The recovery window for backups on tape, as specified in the protection policy.
`CREATION_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The time when this database was added to the Recovery Appliance.
`AUTOTUNE_DISK_RESERVED_SPACE`	`VARCHAR2(16)`		If `YES`, the Recovery Appliance automatically sets and updates `disk_reserved_space` as needed. If `NO`, the administrator of the Recovery Appliance must set and update manually `disk_reserved_space`.
`DB_TIMEZONE`	`VARCHAR2(16)`		The time zone used to create the last backup.
`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.
`LAST_UPDATED_RR`	`DATE`		The time that the restore range for this protected database was updated.