RA_PROTECTION

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.