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. | |
PURGING_DB_KEY |
NUMBER |
The db_key for the database (if it exists) currently being purged in storage location. |
|
UNRESERVED_SPACE |
NUMBER |
The remaining space (in GB) that is available to be assigned to database disk space reservations. | |
AUTOTUNE_SPACE_LIMIT |
NUMBER |
The maximum database reserved_space size (In GB) for which autotuning will perform unlimited reserved_space growth. NULL implies no limit. |