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.