Loading...

Managing Logs for an Oracle Backup Job

You can configure the following archive log options for a specific backup job.

  • The archive log deletion criteria (for example, delete logs older than a specified number of days). You must backup the archive logs before deleting them.
  • The archive log file backup location.

The archive log options listed above override the corresponding archive log options on the subclient for this job. For more information on managing archive logs on the subclient, see Managing Oracle Log Files for a Subclient.

When you choose any of the advanced backup options on the Delete Archive Logs tab on the Advanced Backup Options dialog box, the software will only delete the logs that have been backed up at least 1 time. To ensure this behavior, the software adds the following line to the RMAN script:

delete noprompt archivelog all backed up 1 times to sbt ;

Before You Begin

Configure a online or a log file subclient for Oracle.

Procedure

  1. From the CommCell Browser, expand Client Computers > client> Oracle > instance.
  2. Right-click the subclient configured for archive log backup, and then click Backup.
  3. On the Backup Options dialog box, click Advanced.

    The  Advanced Backup Options dialog box appears.

  4. On the Delete Archive Logs tab, select the Delete Archive Logs check box.
    1. Click Yes to close the warning message.
    2. In the Confirmation dialog box, type confirm, and then click OK.
  5. Choose which logs to delete.

    Choice

    Description

    All

    Deletes all logs

    Older than n Days

    Deletes logs older than the specified number of days.

    Not Older than n Days

    Deletes logs not older than the specified number of days

    By Log Time

    Deletes logs in the specified time range.

    Select the Start Time and End Time check boxes and enter the start and end times of the logs.

    If you only specify the start log time, all logs are backed up from the start time to the current time.

    By Log Seq Num

    Deletes logs in a specified sequence range.

    The Log Sequence Number uniquely identifies an archive log. For example, if you create a database with two online log files, then the first file is assigned log sequence number1. When the first file fills Oracle switches to the second file and assigns a log sequence number of 2.

    Select the Start Sequence Number and End Sequence Number check boxes and enter the beginning and ending sequence numbers.

    By Sys change Num

    Deletes logs in the specified System Change Number range.

    The SCN is a stamp that defines a committed version of a database at a point in time. Oracle assigns every committed transaction a unique SCN. For example, SCNs of two successive committed transactions could be 576601 and 576799.

    Select the Start Sys chg Num and End Sys chg Num check boxes and enter the beginning and ending SCNs:

    The end serial number must be greater than or equal to the start serial number.

    The start and the end SCN cannot be 0.

    If you provide only the start SCN, is the only one provided, only the logs starting that start from that sequence number are backed up.

    Like

    Deletes logs with a file name that starts with a specified string.

    Enter the string to match.

    Backed up

    Deletes logs that have been backed up the specified number of times.

    Enter the number of times the logs have failed to back up.

  6. Specify the location where the logs are deleted from. Select the Delete Archive Log Destinations check box.

    Note: This software makes this option unavailable you select the ALL option for deleting logs.

    • To add a destination, click Add, on the Select an Archive Log Destination dialog box, type the full path to the archive log directory, and then click OK.
    • To delete a destination, select the path in the box, and then click Delete.
  7. On the Backup Archive Logs tab, select the option to determine the logs to back up. Select the Backup Archive Logs check box, and then choose which logs to back up.

    Choice

    Description

    All

    Backs up all logs

    Older than n Days

    Backs up logs older than the specified number of days

    Not Older than n Days

    Backs up logs not older than the specified number of days

    By Log Time

    Backs up logs in the specified time range.

    Select the Start Time and End Time check boxes and enter the start and end times of the logs.

    If you only specify the start log time, all logs are backed up from the start time to the current time.

    By Log Seq Num

    Backs up logs in a specified sequence range.

    The Log Sequence Number uniquely identifies an archive log. For example, if you create a database with two online log files, then the first file is assigned log sequence number1. When the first file fills, Oracle switches to the second file and assigns a log sequence number of 2.

    Select the Start Sequence Number and End Sequence Number check boxes and enter the beginning and ending sequence numbers.

    By Sys change Num

    Backs up logs in the specified System Change Number range.

    The SCN is a stamp that defines a committed version of a database at a point in time. Oracle assigns every committed transaction a unique SCN. For example, SCNs of two successive committed transactions could be 576601 and 576799.

    Select the Start Sys chg Num and End Sys chg Num check boxes and enter the beginning and ending SCNs:

    The end serial number must be greater than or equal to the start serial number.

    The start and the end SCN cannot be 0.

    If you provide only the start SCN, is the only one provided, only the logs starting that start from that sequence number are backed up.

    Like

    Backs up or deletes logs with a file name that starts with a specified string.

    Enter the string to match.

    Not Backed up

    Backs up logs that have not been backed up a specified number of times.

    Enter the number of times a log must be backed up.

  8. Specify the location where the logs are stored. Select the Archive Log Destinations for Backup check box.

    Note: This software makes this option unavailable you select the ALL option for backing up logs.

    • To add a destination, click Add, on the Select an Archive Log Destination dialog box, type the full path to the archive log directory, and then click OK.
    • To delete a destination, select the path in the box, and then click Delete.
  9. Click OK to close the Advanced Backup Options dialog box.
  10. Click OK to close the Backup Options dialog box.

Last modified: 3/26/2018 6:21:25 PM