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: NO means that the Recovery Appliance does not allow deletion of these backups; YES means that the Recovery Appliance allows deletion of these backups.

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: YES means that the Recovery Appliance applies the Backup and Redo Failover strategy to backups from the databases associated with this protection policy; NO means that the Backup and Redo Failover feature is not enabled and the Recovery Appliance applies the normal incremental-forever backup strategy instead.

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)  

YES: Recovery Appliance automatically sets and updates disk_reserved_space as needed.

NO: The administrator of the Recovery Appliance must set and update disk_reserved_space manually.

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

YES: The Recovery Appliance will prevent the deletion of KEEP backups until their KEEP_UNTIL expires. The Recovery Appliance also prevents RMAN from changing the keep time for backups.

NO: The administrator of the Recovery Appliance is permitted to remove KEEP backups. RMAN can change the keep time for backups.