CREATE_SBT_JOB

CREATE_SBT_JOB_TEMPLATE

This procedure creates an SBT job that describes how the Recovery Appliance chooses backups for copying to tape/cloud. This form of this overloaded procedure applies to backups for all protected databases assigned to the specified protection policy.

After you create an SBT backup job, you must schedule it with a scheduling facility such as Oracle Scheduler. See QUEUE_SBT_BACKUP_TASK.

Syntax

PROCEDURE create_sbt_job_template (
   template_name IN VARCHAR2,
   protection_policy_name IN VARCHAR2,
   attribute_set_name IN VARCHAR2,
   backup_type IN VARCHAR2,
   full_template_name IN VARCHAR2 DEFAULT NULL,
   from_tag IN VARCHAR2 DEFAULT NULL,
   priority IN NUMBER DEFAULT SBT_PRIORITY_MEDIUM,
   copies IN NUMBER DEFAULT 1,
   window IN DSINTERVAL_UNCONSTRAINED DEFAULT NULL,
   compression_algorithm IN VARCHAR2 DEFAULT NULL,
   encryption_algorithm IN VARCHAR2 DEFAULT NULL,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 22-15 CREATE_SBT_JOB_TEMPLATE Parameters

Parameter	Description
`template_name`	The user-assigned name of this SBT job template.
`protection_policy_name`	The name of the protection policy to which this SBT job applies. Backups for all protected databases assigned to this protection policy are eligible for copying.
`attribute_set_name`	The name of the SBT attribute set to use for this SBT job.
`backup_type`	The types of backups that this SBT job chooses for copying to tape. The string must be a comma-separated list of the following types: `ALL`: Shorthand for `FULL`, `INCR`, `ARCH` `INCR`: Copies all incremental logs that have not yet been copied to tape, since the most recent full backup. `ARCH`: Copies all archived redo log backups that have not yet been copied to tape, since the most recent full backup. `FULL`: Copies the most recent virtual level 0 backup, if it has not already been copied, to tape. The backup can either be a virtual level 0 backup that is based on the most recent level 0 backup received or a virtual level 0 backup that is based on the most recent level 1 backup received, whichever is more recent.
`full_template_name`	The full name of this SBT job template. This applies only to `INCR` and `ARCH` backup types. The full name links full backups with the incremental backups and archived redo log files needed to recover them. If only one full backup template exists for the specified tape library, then this parameter defaults to the name of this template, which means it does not need to be specified. If multiple full backup templates exist, then you must specify the full template name. The specified `FULL` template name must belong to the same SBT library as the `INCR` or `ARCH` job. If `backup_type` is set to `FULL` or `ALL`, then `full_template_name` is the same as `template_name`.
`from_tag`	The tag name. If specified, then the Recovery Appliance only considers backups using this tag for copying to tape. Refer to "Oracle Database Backup and Recovery Reference" for the correct format of the TAG string.
`priority`	The priority of this job for tape resource usage. Lower priority values take precedence over higher values. `0` is the highest possible priority. You can use any number that is greater than or equal to `0`. The pre-defined values are as follows: `SBT_PRIORITY_LOW` maps to 1000 `SBT_PRIORITY_MEDIUM` maps to 100 `SBT_PRIORITY_HIGH` maps to 10 `SBT_PRIORITY_CRITICAL` maps to 1 The default priority is `SBT_PRIORITY_MEDIUM`. Restore jobs by default have `SBT_PRIORITY_CRITICAL` priority.
`copies`	The number of distinct copies of each backup that this SBT job creates. Valid values range from `1` (default) to `4`.
`window`	The window of time in which this job can copy backups to tape. Copy tasks that are not able to start within the specified window must wait until the next scheduled job execution.
`compression_algorithm`	Specifies the compression algorithm. If `compression_algorithm` is specified, it will override the compression algorithm defined in `template_name` for this single operation. If `template_name` is NULL, it defines the compression algorithm for this operation. `BASIC`: Good compression ratios with potentially lower speed than `MEDIUM`. `LOW`: Optimized for speed with potentially lower compression raios than `BASIC`. `MEDIUM`: Recommended for most environments. Good combination of compression ratios and speed. `HIGH`: Best suited for operations over slower networks where the limiting factor is maximum network throughput. Provides the highest level of compression with the most negative impact on CPU performance. `OFF`: No compression. `NULL`: (default) indicates that the algorithm defined in the SBT job template should be used.
`encryption_algorithm`	Encryption algorithm to use for tape jobs. Valid value are 'AES128', 'AES192', 'AES256', 'OFF', or the constant equivalents ENC_OFF, ENC_AES128, ENC_AES192, ENC_AES256. Note: A value of `CLIENT` or `ENC_CLIENT` requires the client to generate encrypted backups. Failure to do so will result in cloud backup job failures on the Recovery Appliance.
`comments`	Optional user supplied comment describing reason for executing this command.