Creating an Attribute Set

An SBT attribute set is referenced by an SBT job and is a collection of attributes that controls a tape backup operation. The attribute set specifies the SBT library to use for the copy operation. It also specifies SBT channel parameters and parameters to pass to the media management software library. These parameters are merged with the parameters specified in the SBT library object.

A SBT attribute set helps you to further customize and categorize your backups while copying them to tape. An attribute set is created for each tape drive associated with its media manager library. It helps classify backups while storing them on tape by specifying parameters such as the media pool number, streams, and media manager commands needed to perform the tape backup operation.

Note:

If all SBT attribute sets share the same parameter value, then you can specify that parameter in the SBT library object instead of in each SBT attribute set.

Recovery Appliance comes with Oracle Secure Backup pre-configured as its media manager. Oracle Secure Backup components which include a media manager library and attribute sets for each of its tape drives, are also preconfigured. The preconfigured attribute sets are typically named DRIVE_COUNT_1, DRIVE_COUNT_2, and so on for the number of existing tape drives.

This section describes how to create additional attribute sets for third-party media managers using either Cloud Control or DBMS_RA.

• Cloud_Control
• Command_Line

To create an SBT attribute set with Cloud Control:

You create the initial attribute set for a media manager library while creating the media manager library itself. If you leave the initial attribute set fields empty while configuring the media manager library, the default values are used.

You can also use the following steps to create additional attribute sets for a third-party media manager library.

1. Complete the steps in "Accessing Recovery Appliance in Cloud Control".

   From the Recovery Appliance menu, select Media Managers.

2. Under the Attribute Sets section, click Create.

   The Create Attribute Set box appears.

3. In the Name field, enter a name for this attribute set.

4. Optionally, in the Pool ID field, enter the media pool number that will be used to store backup copies.

5. Optionally, in the Streams field, specify the maximum number of streams that will be used to perform the tape backup operation.

   If you do not enter any value, then all available streams will be used.

6. Optionally, use the Media Management Vendor Parameters field to specify additional parameters to define your tape backup job. The Recovery Appliance uses a combination of these parameters and the media manager library parameters to complete the tape backup job.

7. Optionally, in the Media Management Vendor Commands field, enter vendor-specific commands for your media manager software to control your tape backup job.

8. Click OK.

To create an SBT attribute set with DBMS_RA:

1. With SQL*Plus or SQL Developer, connect to the Recovery Appliance database as an administrator of the Recovery Appliance.

2. Run the DBMS_RA.CREATE_SBT_ATTRIBUTE_SET procedure for each SBT attribute set that you want to create.

   BEGIN
     DBMS_RA.CREATE_SBT_ATTRIBUTE_SET(
       lib_name             => 'osbsbt',
       attribute_set_name   => 'wholedb',
       streams              => 10,
       parms                => 'ENV=(OB_MEDIA_FAMILY=wholedb_mf)');
   END;
   

   Again in this example, the media management software is Oracle Secure Backup (OSB). The streams argument sets the maximum number of concurrent streams that can be used for automated backups. The parms argument has the same purpose and format as the PARMS clause of an RMAN ALLOCATE CHANNEL command. In this case it designates the wholedb_mf Oracle Secure Backup media family as the destination of the copy operation.

See Also:

• "CREATE_SBT_ATTRIBUTE_SET" for descriptions of procedure arguments

• "Backup Retention on Tape" for a discussion of the sbt_retention_policy argument