RA_PROTECTION_POLICY
This view lists the protection policies defined for this Recovery Appliance.
| Column | Data Type | NULL | Description |
|---|---|---|---|
POLICY_NAME |
VARCHAR2(128) |
NOT NULL |
The user-created name of the protection policy. |
DESCRIPTION |
VARCHAR2(128) |
The protection policy description. | |
PROT_KEY |
NUMBER |
NOT NULL |
The primary key for this protection policy in the Recovery Appliance metadata database. |
SL_NAME |
VARCHAR2(128) |
NOT NULL |
The name of the Recovery Appliance storage location used by this protection policy. |
SL_KEY |
NUMBER |
NOT NULL |
The primary key of the Recovery Appliance storage location used by this protection policy. |
POLLING_NAME |
VARCHAR2(128) |
The name of the backup polling policy assigned to this protection policy. | |
RECOVERY_WINDOW_GOAL |
INTERVAL DAY(9) TO SECOND(6) |
The recovery window goal for restoring backups stored on disk. | |
MAX_RETENTION_WINDOW |
INTERVAL DAY(9) TO SECOND(6) |
The maximum amount of time that the Recovery Appliance must retain disk backups. | |
RECOVERY_WINDOW_SBT |
INTERVAL DAY(9) TO SECOND(6) |
The recovery window for restoring backups stored on tape. | |
UNPROTECTED_WINDOW |
INTERVAL DAY(9) TO SECOND(6) |
The point beyond which recovery is not possible unless additional redo is available. | |
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. |
|
REPLICATION_SERVER_LIST |
VARCHAR2(4000) |
The list of replication server configurations associated with this protection policy. | |
ALLOW_BACKUP_DELETION |
VARCHAR2(3) |
The setting that controls whether RMAN backups for databases that use this protection policy can be deleted: 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: 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) |
|
|
LOG_COMPRESSION_ALGORITHM |
VARCHAR2(6) |
NOT NULL |
The status of the log compression algorithm setting: HIGH means that the Recovery Appliance uses RMAN HIGH compression for compressing archive logs; BASIC means that the Recovery Appliance uses RMAN BASIC compression for compressing archive logs; LOW means that the Recovery Appliance uses RMAN LOW compression for compressing archive logs; MEDIUM means that the Recovery Appliance uses RMAN MEDIUM compression for compressing archive logs; OFF means that the Recovery Appliance does not compress the archive logs. |
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) |
NOT NULL |
|