NetBackup™ for Oracle Administrator's Guide

To create a script-based Oracle policy

1. In the NetBackup Administration Console, in the left pane, expand NetBackup Management > Policies.
2. On the Actions menu, click New > New Policy.
3. Type a unique name for the new policy in the Add a New Policy dialog box and click OK.

   Do not use the Policy Configuration Wizard to configure a policy for Replication Director.

4. Select the Attributes tab. The following items are specific to creating an Oracle policy for snapshots with Replication Director:

   • Policy type

     For NetBackup to perform Oracle backups, select Oracle. An Oracle tab appears.

   • Policy storage

     Oracle combines snapshots (proxy) and stream-based backups as part of the same backup. The storage that is indicated here is used for the stream-based part of the Replication Director backup.

     Select the storage that is configured to contain the stream-based (non-snapshot) part of the database backup. The storage can be either a storage lifecycle policy that is configured for non-snapshot backups, or a disk or Media Manager unit.

   • Use Replication Director

     Enable Use Replication Director to automatically select other options that Replication Director requires:

     • Perform snapshot backups: Ensures that the policy creates snapshots of the disk array.

     • Retain snapshots for Instant Recovery or SLP management: Ensures that the policy retains the snapshot after the backup completes.

     • Options button

       Snapshot Type

       Auto (default): The OpenStorage partner uses the best snapshot technology available to that partner to create the snapshot. Differential: The OpenStorage partner creates a snapshot that is completely dependent on the source. This parameter is based on copy-on-write technology. The device creates a cache object to maintain the original blocks of the snapshot when the blocks are modified. Plex: The OpenStorage Partner creates a snapshot that is completely independent of the source snapshot. This option is based on mirror-break-off technology. When a mirror device is attached to the source, the contents of the mirror device is exactly the same as the source device. When the relationship is broken between the two, the mirror device is separated from the source. The mirror device acts as a point-in-time copy. Clone: The OpenStorage Partner creates an independent copy of the volume. The copy process can take some time as the entire copy must be complete. The snapshot that is created is independent of the source.

       Maximum Snapshots

       Sets the maximum number of snapshots to be retained at one time. The default setting is one. Choose the number of snapshots that is appropriate for your environment. Note that the maximum number of snapshots on a NetApp volume is 255. When the maximum is reached, snapshot rotation occurs: The next snapshot causes the oldest to be deleted. Managed by SLP retention is automatically selected if the Fixed or the Expire after Copy retention is currently selected in the SLP.

   
5. Select the Instances and Databases tab and specify the instances to back up. Select Clients for use with scripts. If either of the other two are selected, the Oracle Intelligent Policy is used and the scripts are created automatically.
   

   After you select the Clients for use with scripts option, a message appears that describes the effect of this choice:

   • Existing selections (if any) for this policy are erased.

   • The Oracle tab is removed from this policy.

   • Another effect is that the Selections tab turns into the Clients tab.

   Click Yes to continue Oracle policy configuration.

   
6. Click Yes to save and close the entire policy.
7. In the NetBackup Administration Console, select the policy and click the refresh button in the toolbar.
   
8. Re-open the policy and select the Schedules tab.

   Modify the Default-Application-Backup schedule:

   • Override policy storage selection: Enable and select a non-snapshot storage unit or a non-snapshot SLP. This option is most likely the storage unit that is specified on the Attributes tab. Indicating the option here, makes the selection explicit.

   • Retention: The policy or SLP indicates the retention for the backup:

     • When the storage is an SLP, the SLP determines the retention and no selection is possible here.

     • When the storage is not an SLP, the schedule determines the retention and a selection is possible here.

   Click OK to save the schedule.

   

   Create one Full Backup schedule:

   • Name the schedule.

   • Type of backup: Select Full Backup.

     Note:

     Unless creating Block Level Incremental (BLI) backups, always select Full Backup to create snapshots of the Oracle database.

   • Override policy storage selection: Enable and select the SLP that is configured for snapshot replication.

   • Retention: The SLP indicates the retention for the backup.

   
9. Configure the schedule in the Start Window tab and the Exclude Days tab.

   Click OK to save and close the schedule.

10. Select the Clients tab. By default, the Clients for use with scripts option is selected for this script-based Oracle policy.
11. Add the client names that contain the Oracle database and indicate the operating system of each.
12. Select the Backup Selections tab. Specify the script that NetBackup should use. Indicate only one script.
13. When the policy configuration is complete, click OK.