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 |
---|---|---|---|
|
|
The unique name of this protected database. |
|
|
|
|
The primary key for this protected database in the Recovery Appliance. |
|
|
The day when this database history record was created. |
|
|
|
The amount of disk space (in GB) reserved for the exclusive use of this database |
|
|
|
The estimated space (in GB) consumed by the entire protected database. |
|
|
|
The amount of space (in GB) currently used by this protected database. |
|
|
|
The cumulative amount of disk space (in GB) allocated for all backups received for this database. |
|
|
|
The cumulative amount of disk space (in GB) replicated for this protected database. |
|
|
|
The cumulative amount of disk space (in GB) sent to cloud storage for this protected database. |
|
|
|
The cumulative amount of disk space (in GB) sent to SBT from this protected database. |
|
|
|
Amount of |
|
|
|
The estimated space (in GB) that is needed to meet the recovery window goal. |
|
|
|
Time range of backups used to estimate |
|
|
|
The recovery window goal for backups on disk, as specified in the protection policy. |
|
|
|
The maximum amount of time to retain disk backups. |
|
|
|
The recovery window for backups on tape, as specified in the protection policy. |
|
|
|
The time when this database was added to the Recovery Appliance. |
|
|
|
If If |
|
|
|
The time zone used to create the last backup. |
|
|
|
The earliest time to which the protected database can be restored. |
|
|
|
The latest time to which the protected database can be restored. |
|
|
|
The time that the restore range for this protected database was updated. |