CREATE_PROTECTION_POLICY
This procedure creates a protection policy.
Syntax
PROCEDURE create_protection_policy ( protection_policy_name IN VARCHAR2, description IN VARCHAR2 DEFAULT NULL, storage_location_name IN VARCHAR2, polling_policy_name IN VARCHAR2 DEFAULT NULL, recovery_window_goal IN DSINTERVAL_UNCONSTRAINED, max_retention_window IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL, recovery_window_sbt IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL, unprotected_window IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL, guaranteed_copy IN VARCHAR2 DEFAULT 'NO', allow_backup_deletion IN VARCHAR2 DEFAULT 'YES', store_and_forward IN VARCHAR2 DEFAULT 'NO', log_compression_algorithm IN VARCHAR2 DEFAULT 'BASIC', autotune_reserved_space IN VARCHAR2 DEFAULT 'NO', recovery_window_compliance IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL, keep_compliance IN VARCHAR2 'NO', comments IN VARCHAR2 DEFAULT NULL, max_reserved_space IN VARCHAR2 DEFAULT NULL, secure_mode IN VARCHAR2 DEFAULT 'NO', level0_refresh IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL );
Parameters
Table 21-11 CREATE_PROTECTION_POLICY Parameters
Parameter | Description |
---|---|
|
The user-assigned name of the protection policy. |
|
An optional description of the usage for the policy. |
|
The name of the storage location. The Recovery Appliance uses this location for actively received incoming backups, and for newly created backup files for all databases sharing this protection policy. |
|
The name of the backup polling policy. The polling policy specifies the rules for how the Recovery Appliance polls for backups of protected databases that use this protection policy. If null, then no backup polling occurs for databases that use this protection policy. |
|
The recovery window goal for databases that use this protection policy. For each protected database, the Recovery Appliance attempts to ensure that the oldest backup on disk can support a point-in-time recovery to any time within the specified interval, counting backward from the current time. Specify the goal as any valid |
|
The maximum length of time that the Recovery Appliance must retain backups for databases that use this protection policy. Recovery Appliance only holds backups longer than the specified period when they are required to preserve the recovery window goal for a database. If null, |
|
The recovery window for SBT backups of databases that use this protection policy. For each protected database, the Recovery Appliance keeps backups long enough on tape to guarantee that a recovery is possible to any time within the specified interval, counting backward from the current time. If this parameter is not null, then you must also create an
SBT job for this protection policy, and then schedule it using a
scheduling facility such as Oracle Scheduler.
See If this parameter is null, the purge backup automatically is never run and backups are kept beyond their expiration date. Specify the window as any valid |
|
The maximum amount of data loss that is tolerable
for databases using this protection policy.
When a protected database exceeds the specified amount of data loss,
the Recovery Appliance posts a warning to Specify the window as any valid The For this calculation, the data in |
|
The setting of the guaranteed copy feature. Specifying
Specifying If set to |
|
Setting this to
|
|
The setting for the Backup and Redo Failover feature. This setting is used only in a protection policy defined on the alternate Recovery Appliance where the protected databases associated with this policy will redirect backups and redo in the event of an outage on the primary Recovery Appliance.
Refer to Managing Temporary Outages with a Backup and Redo Failover Strategy for more information. |
|
The setting for the archive log compression feature. This setting is used to adjust the compression level of NZDL/polled archive log backups.
Advanced Compression Option (ACO) license is not required on the protected database for use of LOW, MEDIUM, and HIGH log compression settings. For more details on log compression usage, see ZDLRA: Changes in the Protection Policy Compression Algorithms (Doc ID 2654539.1). |
|
This setting is used to control whether the Recovery Appliance will automatically define and update the
|
|
This setting specifies for each database a range of backups that will not be deleted. These backups must not use more than "filling disk_reserved_space" should be "filling disk_reserved_space with compliance protected backups" Specify the window as any valid |
|
This setting prevents someone from using
|
|
Optional user supplied comment describing reason for executing this command. |
|
This parameter is the maximum The format of this value is a character string that must contain a number consisting only of the characters
If no unit is specified, then Recovery Appliance interprets the value as a number of bytes. If |
|
Determines whether backups stored on the Recovery Appliance must be encrypted.
|
|
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 Specify the refresh cycle as any valid |