Creating an Oracle Database Backup Job
Backing up Oracle databases is essential for ensuring the availability and integrity of critical business data within an organization. Catalogic DPX offers a streamlined approach to backing up Oracle databases, leveraging its application-aware capabilities to facilitate the process.
In the main web interface view, go to Job Manager in the sidebar. Then select the New Backup Job button in the upper right corner.
Specify the Job Name (this field may contain up to 16 characters). Add an optional, brief description (this field may contain up to 48 characters).
Select Job Type – Block and the Job Folder to store the job in. By default, all jobs are stored in the SS_DEFAULT folder.
Click Add Source in the SOURCES pane to specify which volumes you want to back up. DPX detects Oracle DB installations through registry settings and the VSS (Volume Shadow Copy Service) framework. You will see a separate virtual object for the Oracle DB application, indicating that DPX can perform application-consistent backups. Select your database and click Select.
Attention! When backing up an Oracle DB object with DPX, all local volumes referenced by the object will also be included in the backup. This may result in a larger backup size than initially anticipated.
Tip. You may view your current selection at any moment, using the Selected Items button next to the search field.
Click Set Destination in the DESTINATION pane to choose the destination for the backup.
You can also add a schedule in the SCHEDULES pane for the backup to be run regularly.
See also. For more details on scheduling options, see Scheduling a Block Backup Job.
If you want to add an Archive to your backup job, click Add Archive in the ARCHIVE pane.
Destination
Select the Archive destination.
Options
Mark Original Offsite
Determines whether a backup tape is stored offsite. DPX adds the Offsite status to the tape.
Toggle on | Indicates in the Catalog that the tape is stored offsite. |
Toggle off | Indicates in the Catalog that the tape is stored onsite. |
Append Offsite
Determines if a backup tape with status Offsite can be appended.
Toggle on | Tapes in the library with status Offsite can be appended to. The Append Offsite field in the Edit Media Pool dialog must also be set to Yes. |
Toggle off | Tapes in the library with status Offsite cannot be appended to. |
The Offsite status of a tape can be viewed through the Operate Tape Library function, the Configure Media function, or in the media volume report. Note that when you use the Operate Tape Library function to import a tape with status Offsite, the Offsite status is cleared and the tape becomes available for use.
Max Devices (Devices)
Limits the number of storage devices valid for use with this job. Use this option if you want to stop DPX from using all the drives in the selected device cluster so that some drives will be available for other purposes.
The Alternate Secondary toggle
This is an alternate location where backup data resides. This alternate location could be a replica of the original data using NetApp SnapMirror, copied through Data ONTAP commands, or restored from a tape backup. Data can be restored from an alternate secondary data source directly from the management console.
If the toggle is on, two additional drop-down selection fields are shown, requiring to specify the Alternate Secondary Node and Volume.
Schedule
Add schedules for Base, Incremental, and Differential Archive backups according to your requirements.
Click Add to save the current schedule.
Multiple schedules may be added using the Add Another Schedule button which will be displayed upon adding the first schedule.
Specify Advanced Options. There is 1 Oracle DB-specific option:
Oracle RMAN Cataloging Control
This option determines whether to synchronize the RMAN Catalog after the job completes. You have access to the following options:
Toggle on | Synchronize the RMAN Catalog after the job completes. |
Toggle off | Do not synchronize the RMAN Catalog after the job completes. If you choose this option, the job is not cataloged in RMAN. |
See also. To learn more about other available options, see Job Options for Block Backup.
Click Save.
Enter the retention period and choose whether to run the job immediately. Your job will be now available in the Job Manager section.
Last updated