UPDATE_PROTECTION_POLICY

This procedure modifies the parameters for an existing protection policy.

If a parameter is NULL, its value remains unchanged, except as noted below.

Syntax

PROCEDURE update_protection_policy (
   protection_policy_name IN VARCHAR2,
   description IN VARCHAR2 DEFAULT NULL,
   storage_location_name IN VARCHAR2 DEFAULT NULL,
   polling_policy_name IN VARCHAR2 DEFAULT dbms_ra_misc.varchar2null('p1'),
   recovery_window_goal IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL,
   max_retention_window IN DSINTERVAL_UNCONSTRAINED DEFAULT dbms_ra_misc.intervalnull('p3'),
   recovery_window_sbt IN DSINTERVAL_UNCONSTRAINED DEFAULT dbms_ra_misc.intervalnull('p2'),
   unprotected_window IN DSINTERVAL_UNCONSTRAINED DEFAULT dbms_ra_misc.intervalnull('p4'),
   guaranteed_copy IN VARCHAR2 DEFAULT NULL,
   allow_backup_deletion IN VARCHAR2 DEFAULT NULL,
   store_and_forward IN VARCHAR2 DEFAULT NULL,
   log_compression_algorithm IN VARCHAR2 DEFAULT NULL,
   autotune_reserved_space IN VARCHAR2 DEFAULT 'NO',
   recovery_window_compliance IN DSINTERVAL_UNCONSTRAINED DEFAULT dbms_ra_misc.intervalnull('p5'),
   keep_compliance IN VARCHAR2 'NO',
   comments IN VARCHAR2 DEFAULT NULL,
   max_reserved_space IN VARCHAR2 DEFAULT dbms_ra_misc.varchar2nul('p6'),
   secure_mode IN VARCHAR2 DEFAULT 'NULL',
   level0_refresh IN DSINTERVAL_UNCONSTRAINED DEFAULT dbms_ra_misc.varchar2nul('p6')
);

Parameters

Table 21-55 UPDATE_PROTECTION_POLICY Parameters

Parameter	Description
protection_policy_name	The name of the protection policy to update.
description	See CREATE_PROTECTION_POLICY.
storage_location_name	See CREATE_PROTECTION_POLICY. If you change the storage location for this protection policy, then the Recovery Appliance starts background jobs to move data from the old storage location to the new storage location.
polling_policy_name	See CREATE_PROTECTION_POLICY. If you do not specify this parameter, then the policy retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value.
recovery_window_goal	See CREATE_PROTECTION_POLICY.
max_retention_window	See CREATE_PROTECTION_POLICY. If this parameter is not specified, its old value is retained. If specified, including being specified as NULL, the new value is set.
recovery_window_sbt	See CREATE_PROTECTION_POLICY. If you do not specify this parameter, then the policy retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value.
unprotected_window	If you do not specify this parameter, then the policy retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value. See CREATE_PROTECTION_POLICY.
guaranteed_copy	See CREATE_PROTECTION_POLICY.
allow_backup_deletion	See CREATE_PROTECTION_POLICY.
store_and_forward	See CREATE_PROTECTION_POLICY.
log_compression_algorithm	See CREATE_PROTECTION_POLICY.
autotune_reserved_space	See CREATE_PROTECTION_POLICY.
recovery_window_compliance	See CREATE_PROTECTION_POLICY. This setting specifies for each database a range of backups that will not be deleted. These backups must not use more than disk_reserved_space bytes of storage, and if they do, new backups will be rejected until those backups age out of the range. Specify the window as any valid INTERVAL DAY TO SECOND expression, such as INTERVAL '4' HOUR (4 hours).
keep_compliance	See CREATE_PROTECTION_POLICY. YES means the "keep until time" for an archival backup may not be modified by the RMAN CHANGE command. NO means the "keep until time" for an archival backup may be modified by the RMAN CHANGE command. NO is the default.
comments	Optional user supplied comment describing reason for executing this command.
max_reserved_space	This parameter is the maximum disk_reserved_space permitted for each database individually that is supported by the protection policy The format of this value is a character string that must contain a number consisting only of the characters 0-9, followed optionally by one of the following unit specifiers: K: Kilobytes M: Megabytes G: Gigabytes T: Terabytes P: Petabytes If no unit is specified, then Recovery Appliance interprets the value as a number of bytes. If max_reserved_space is specified as NULL, the disk_reserved_space setting for databases will not be constrained except by the restriction that the sum of the reserved spaces for all databases must fit within the storage location.
secure_mode	Determines whether backups stored on the Recovery Appliance must be encrypted. YES means that only encrypted backup and redo are accepted by the Recovery Appliance. NO means unencrypted backups are allowed to be stored on the Recovery Appliance. NO is the default.
level0_refresh	If specified, the Recovery Appliance chooses some number of data files from each backup to be level 0 backups. This spreads the creation of new level 0 backup data across the level0_refresh interval. Its purpose is to limit the number of encryption keys needed to maintain virtual level 0 backups. Specify the refresh cycle as any valid INTERVAL DAY TO SECOND expression, such as INTERVAL '20' DAY (20 days).