Creating an Automatic Schedule for Database Log Backups

Applies to: Microsoft SQL Server, MongoDB, Oracle, Oracle RAC, SAP for Oracle, Notes Database traditional log backups

Create an automatic schedule to automatically run a database log backup when specific criteria are met. For example, run a backup when the archive log destination fills up to a specified capacity.

Automatic backups of database log files use the data protection resources more efficiently because they only run backup jobs when there is enough data to back up. A non-automatic schedule runs the backup at the specified date and time, even if there is not enough data to back up.

Take the following into consideration when plan your log backup schedule:

  • The number of transactions that the database generates

  • The disk size for the log file destination

The Detect file or log activity every parameter ensures that the software does not frequently run the job. The software does not check the database threshold options during this interval.

The Run the backup every parameter ensures that the software backs up the logs even when the database threshold options have not been met. For example, if the parameter is set to 24 hours and the software has not run an automatic log backup in that time, the software will start a backup without checking the database options.

When the Detect file or log activity every interval expires, the software checks to see if the database qualifies for a backup based on the log disk usage.

When the Run the backup every interval expires, the software checks to see if the database has been backed up. The software looks at the finish time and if it happened during the Detect file or log activity every interval.

If you assign this schedule type to a subclient that has no backups prior to the assignment, the first backup runs irrespective of the database threshold options.

The following best practices apply to all the agents:

  • Set a low Detect file or log activity every interval. For example, set a minimum interval of 15 minutes.

  • Set a Run the backup every interval that is less than the time interval between running two backup

  • Set the option to perform a back up when the log destination fills up to 50%-80%. The actual value depends on your storage size.

You can also configure a schedule policy for automatic database log backups. For information on how to configure a schedule policy, see Adding an Automatic Database Log Backup Schedule to a Schedule Policy.

Best Practice: For some agents, the Commvault software creates a default archive log subclient, such as Oracle. Do not modify the properties of the default archive log subclient.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > agent > instance.

  2. Right-click the subclient configured for the archive log backup and then click Backup.

    The Backup Options for Subclient dialog box appears.

  3. On the Backup Options tab, select a backup type depending on the type of database. For example, for Oracle, Oracle RAC, and SAP for Oracle select a backup type of Full. For SQL Server, select a backup type of Transaction Log.

  4. On the Backup Options tab, select Schedule, and then click Configure.

    The Schedule Details dialog box appears.

  5. In the Schedule Name box, enter a unique name for the schedule.

  6. Select Automatic.

  7. In the Detect file or log activity every box, enter the interval that the software detects if the database qualifies for a backup.

    Note

    When this time expires, the Commvault software checks the criteria and automatically starts a backup if any of the criteria are met.

  8. In the Run the backup every box, enter the interval when the software checks to see if the database has been backed up.

    Note

    If this value is met, the job starts regardless of whether the database criteria are met.

  9. Select the criteria to use to run backup jobs:

  10. Database

    Option

    Oracle

    Oracle RAC

    SAP for Oracle

    MongoDB

    Notes

    To run backup jobs when the number of log files on the disk use a specified amount of the storage space, select the Start backup when disk at log destination is option.

    To run backup jobs when the number of log files on the disk reach a specified number, select the Number of Archived Logs in Destination option.

    SQL

    To run backup jobs when the used space of log files reach a specified percentage, select the Start backup when the log file is option.

    Note: Only databases that use the full recovery model are eligible for automatic log backups.

  11. Click OK to close the Schedule Details dialog box.

  12. Click OK to close the Backup Options for Subclient dialog box.

Loading...