Secondary Copy (Selective Copy)

Table of Contents

Overview

A selective copy allows you to copy specific full backup jobs from a source copy. The source copy can be either a primary or a synchronous copy. Selective copy facilitates better tape rotation.

You can define a selective copy as follows:

  • Automatically copy first or last full backup jobs based on automatic time-based selection such as all, weekly, monthly, quarterly, half-yearly, or yearly.

    Advanced options allows you to copy the jobs based on a frequency of number of cycles, days, weeks or months.

    For example, only the first or last full backup that occurs within the selected week, month, quarter, half-year, or year can be copied.

    During these selection criteria, the selective copy considers the Start Time of a backup job.

  • Manually select the jobs to be copied during an Auxiliary Copy operation.

    See Manually Select a Job to Copy for instructions.

Creating a Selective Copy

You can create selective copy to copy specific full backup jobs from a source copy.

Before You Begin

Procedure

  1. From the CommCell Browser, expand Policies | Storage Policies.
  2. Right-click the appropriate storage policy, point to All Tasks, and then click Create New Copy.
  3. In the Copy Properties dialog box, specify the appropriate settings.
    1. In the Copy Name box, type a name for the storage policy copy.
    2. Select the Selective Copy check box.

      The Selective Copy tab becomes available.

    3. From the Library list, select the name of Library.
    4. From the MediaAgent list, select the name of a MediaAgent.
    5. From the Drive Pool list, select the name of a Drive Pool.
    6. From the Scratch Pool list, select the name of the Scratch Pool.

      Drive Pool and Scratch Pool are applicable only for tape libraries.

    7. Click the Copy Policy tab, clear the All Backup check box, and then in the Backups On and After box, enter the start date.

      The start date is the date from which the backup jobs will be copied from the source to the selective copy. The backup jobs that ran prior to the start date are not available to the selective copy.

      The selection period for a selective copy is determined only by the copy creation time. The Backups on or After option does not affect the selection period for a given selective copy because Backups on or After option is only used to decide which backup job after specified date is qualified to be picked.

  4. Click OK.
  5. In the Auxiliary Copy Schedule dialog box, click OK to accept the default schedule.

    When an Auxiliary Copy job is run, by default all first full backup job in every week is copied. To modify the frequency for a selective copy, see Configuring the Frequency of Backups for the Selective Copy for more information.

Manually Select a Job to Copy

You can manually select jobs to be copied to selective copies during an Auxiliary Copy operations.

  1. Disable the automatic-time based selection criteria for a selective copy.
    1. From the CommCell Browser, expand Policies | Storage Policies.
    2. Right-click the appropriate selective copy, and click Properties.
    3. In the Copy Properties dialog box, click the Selective Copy tab, click Do not Automatically select jobs, and then click OK.
  2. Manually mark the job to copy during the Auxiliary Copy job.
    1. From the CommCell Browser, expand Policies | Storage Policies.
    2. Right-click the appropriate selective copy, point to View, and then click Jobs.
    3. In the Job Filter for Storage Policy dialog box, clear the Specify Time Range check box, click Advanced.
    4. In the Jobs in Storage Policy Advanced Filter Options dialog box, select the Jobs that will not be copied check box.
    5. Click OK and then click OK to close the Job Filter for Storage Policy dialog box.

      The list of jobs that are not copied to the storage policy copy are displayed with the Status as Not Selected in the Job for Storage Policy pane.

    6. Right-click the job that you want to copy to the storage policy copy, and then click Pick for Copy.
    7. In the Allow Copy dialog box, click Yes.

      When the job is selected, the job is displayed with a status of To be Copied. The job will now be copied to storage policy copy during the next Auxiliary Copy operation.

      Repeat above steps to selected other jobs.

  3. Run an Auxiliary Copy job.

Configuring the Frequency of Backups for the Selective Copy

You can configure the frequency of selecting backups for the copy.

  1. From the CommCell Browser, expand Policies | Storage Policies | <Storage Policy>.
  2. Right-click the appropriate selective copy, and click the Selective Copy tab.
  3. From the Automatically select Full Backups at frequency list, select the appropriate frequency and click OK.

 The following table describes various frequencies that can be configured on a selective copy:

Important:

  • When any job exists on the selective copy based on the previous frequency rule or manual selection, if a job qualifies based on the current selective copy rule in the current period, then that job will not be picked because only one job is picked per period.

    For example:

    • If first full backup with monthly option is enabled and a job is picked in the current period, and during halfway of the current period, if you modify the rule to last full, then the last full job from the current period will not get picked.

      The last full rule will be effective only from the next period.

    • If first full backup with monthly option is selected and there are no full backup jobs in the current period, if you modified the rule as last full, then the last full backup job from the current period will be selected for copy.
Frequency How To Configure Example
First Full Backup in every week (This is the default frequency for a selective copy)
  1. From the Automatically select Full Backups at frequency list, select Weekly Fulls.
  2. From the For Weekly Full rule, the week starts on list, select the starting day of the week.
If the week starts on Friday, the first full backup performed on or after Friday will be selected for the copy.
Last Full Backup in every week
  1. From the Automatically select Full Backups at frequency list, select Weekly Fulls.
  2. From the For Weekly Full rule, the week starts on list, select the starting day of the week.
  3. Click Last Full Backup.
  4. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
  5. Click OK.

    If you have enabled Select most recent job if there are no more full backup schedules in current time period option to select last full backups, but if you do not have any scheduled backup jobs then this option will select first full backup job. In this case, it is recommended to select Wait until the current period is over before selecting a backup for this time period option to avoid selection of first full backup.

The week starts on Friday and you are performing the auxiliary copy operation on Wednesday, the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on Thursday, no backup from the current week will be selected for the copy.

    For the full backup performed on Thursday, the backup job will be marked as To Be Copied when it completes. This selected backup job will be copied to media when you perform the Auxiliary Copy operation in the subsequent week.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup from the current week will be selected for the copy. For the last full backup in the week, the backup job will be marked To Be Copied.

    After the current week is over, if you perform the auxiliary copy operation, the last full backup from that week will be selected for the copy.

First Full Backup in every month
  1. From the Automatically select Full Backups at frequency list, select Monthly Fulls.
  2. From the For Monthly Full rule, the month starts on list, select the starting date for the month.
If the starting date of the month is 1, the first full backup performed on or after 1st will be selected for the copy.
Last Full Backup in every month
  1. From the Automatically select Full Backups at frequency list, select Monthly Fulls.
  2. From the For Monthly Full rule, the month starts on list, select the starting date for the month.
  3. Click Last Full Backup.
  4. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
  5. Click OK.

    If you have enabled Select most recent job if there are no more full backup schedules in current time period option to select last full backups, but if you do not have any scheduled backup jobs then this option will select first full backup job. In this case, it is recommended to select Wait until the current period is over before selecting a backup for this time period option to avoid selection of first full backup.

The starting day for a month is 1. You are performing the auxiliary copy operation on March 30 , the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on March 31, no backup from March will be selected for the copy.

    For the full backup performed on March 31, the backup job will be marked as To Be Copied. This backup will be included in the selective copy if you perform the Auxiliary Copy operation in April.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup from the current month will be selected for the copy. For the last full backup in March, the backup job will be marked To Be Copied.

    If you perform the auxiliary copy operation in April, the last full backup from March will be selected for the copy.

First Full Backup in every quarter From the Automatically select Full Backups at frequency list, select Quarterly Fulls. If the quarter starts on January 1, the first full backup on or after January 1 will be selected for the copy.

In the standard Georgian calendar, the year starts on January 1 and it has 12 months. This year is divided into 4 quarters as follows:

  • Quarter 1 (Q1) - January 1 to March 31
  • Quarter 2 (Q2)- April 1 to June 30
  • Quarter 3(Q3) - July 1 to September 30
  • Quarter 4(Q4) - October 1 to December 31

If you want to change the start day of the year, number of days in a month, or number of months in a year, you can create a custom calendar and associate it with the copy. Depending upon the settings in the custom calendar, the year is divided into four quarters. 

Last Full Backup in every quarter
  1. From the Automatically select Full Backups at frequency list, select Quarterly Fulls.
  2. Click Last Full Backup.
  3. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
  4. Click OK.

    If you have enabled Select most recent job if there are no more full backup schedules in current time period option to select last full backups, but if you do not have any scheduled backup jobs then this option will select first full backup job. In this case, it is recommended to select Wait until the current period is over before selecting a backup for this time period option to avoid selection of first full backup.

The Q1 starts on January 1. You are performing the auxiliary copy operation on March 30 , the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on March 31, no backup from the Q1 will be selected for the copy.

    For the full backup performed on March 31, the backup job will be marked as To Be Copied. This backup will be included in the selective copy if you perform the Auxiliary Copy operation in Q2.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup from the current quarter will be selected for the copy. For the last full backup in Q1, the backup job will be marked To Be Copied.

    If you perform the auxiliary copy operation in Q2, the last full backup from Q1 will be selected for the copy.

First Full Backup in every half year From the Automatically select Full Backups at frequency list, select Half Yearly Fulls. If the year starts on January 1, the first full backup on or after January 1 will be selected for the copy.

In the standard Georgian calendar, the year starts on January 1 and it has 12 months. This year is divided as follows:

First Half Year - January 1 to June 30

Second Half Year - July 1 to December 31

If you want to change the start day of the year, number of days in a month, or number of months in a year, you can create a custom calendar and associate it with the copy. Depending upon the settings in the custom calendar, the half year period is calculated.

Last Full Backup in every half year
  1. From the Automatically select Full Backups at frequency list, select Half Yearly Fulls.
  2. Click Last Full Backup.
  3. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
  4. Click OK.

    If you have enabled Select most recent job if there are no more full backup schedules in current time period option to select last full backups, but if you do not have any scheduled backup jobs then this option will select first full backup job. In this case, it is recommended to select Wait until the current period is over before selecting a backup for this time period option to avoid selection of first full backup.

The year starts on January 1. You are performing the auxiliary copy operation on June 25 , the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on June 30, no backup from the first half year will be selected for the copy.

    For the full backup performed on June 30, the backup job will be marked as To Be Copied. This backup will be included in the selective copy if you perform the Auxiliary Copy operation in the second half year.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup from the first half year will be selected for the copy. For the last full backup in the first half year, the backup job will be marked To Be Copied.

    If you perform the auxiliary copy operation in the second half year, the last full backup from the first half year will be selected for the copy.

First Full Backup in every year From the Automatically select Full Backups at frequency list, select Yearly Fulls. If the year starts on January 1, the first full backup on or after January 1 will be selected for the copy.

In the standard Georgian calendar, the year starts on January 1 and it has 12 months.

If you want to change the start day of the year, number of days in a month, or number of months in a year, you can create a custom calendar and associate it with the copy.

Last Full Backup in every year
  1. From the Automatically select Full Backups at frequency list, select Yearly Fulls.
  2. Click Last Full Backup.
  3. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
  4. Click OK.

    If you have enabled Select most recent job if there are no more full backup schedules in current time period option to select last full backups, but if you do not have any scheduled backup jobs then this option will select first full backup job. In this case, it is recommended to select Wait until the current period is over before selecting a backup for this time period option to avoid selection of first full backup.

The year starts on January 1. You are performing the auxiliary copy operation on December 30, the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on December 31, no backup from the year will be selected for the copy.

    For the full backup performed on December 31, the backup job will be marked as To Be Copied. This backup will be included in the selective copy if you perform the Auxiliary Copy operation in the subsequent year.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup from the current year will be selected for the copy. For the last full backup in the first half year, the backup job will be marked To Be Copied.

    If you perform the auxiliary copy operation in the subsequent year, the last full backup from the first half year will be selected for the copy.

First full Backups performed after a specific time period

The Time period can be specified in cycles/days/weeks/months

  1. From the Automatically select Full Backups at frequency list, select Advanced.
  2. Click Advanced.
  3. Select one of the following options in the Advanced Options dialog box:
    • Every <n> Cycle(s) - Select this option and enter the number of backup cycles. A backup cycle is a group of backup operations, starting with a full backup.
    • Every <n> Days - Select this option and enter the number of days.
    • Every <n> Weeks - Select this option and enter the number of weeks.
    • Every <n> Months - Select this option and enter the number of months.
  4. In the Advanced Options dialog box, click OK.
  5. In the Copy Properties dialog box, click OK.
If you have specified time period as 3 days then the first full backup after every 3 days will be selected for the copy.
Last full Backups performed after a specific time period

The Time period can be specified in cycles/days/weeks/months

  1. From the Automatically select Full Backups at frequency list, select Advanced.
  2. Click Advanced.
  3. Select one of the following options in the Advanced Options dialog box:
    • Every <n> Cycle(s) - Select this option and enter the number of backup cycles. A backup cycle is a group of backup operations, starting with a full backup.
    • Every <n> Days - Select this option and enter the number of days.
    • Every <n> Weeks - Select this option and enter the number of weeks.
    • Every <n> Months - Select this option and enter the number of months.
  4. In the Advanced Options dialog box, click OK.
  5. Click Last Full Backup.
  6. Select one of the following options:
    • Select most recent job if there are no more full backup schedules in current time period
    • Wait until the current period is over before selecting a backup for this time period
If you have specified time period as 3 days and you are performing auxiliary copy on the second day, the backup will be selected as follows:
  • If you select the Select most recent job if there are no more full backup schedules in current time period option, the most recent backup will be selected for the copy. However, if a full backup is scheduled on the third day, no backup will be selected for the copy.

    For the full backup performed on the third day, the backup job will be marked as To Be Copied. This backup will be included in the selective copy if you perform the Auxiliary Copy operation on or after the fourth day.

  • If you select the Wait until the current period is over before selecting a backup for this time period, no backup will be selected for the copy. For the last full backup in the 3 days time period,  the backup job will be marked To Be Copied.

Copy Alternate Cycle Jobs to Two Different Selective Copies

If you want to copy alternate cycle jobs (that is one odd and one even) to different copies, configure two selective copies as follows.
  • Configure the first selective copy with First Full Backup.
    1. From the CommCell Browser, expand Policies | Storage Policy | storage policy.
    2. Right-click the selective copy, and then click the Properties.
    3. Click the Selective Copy tab, from the Automatically select Full Backups at frequency list, select Advanced, and then click Advanced.
    4. In the Advanced dialog box, select Every <x> Cycles, specify the value as 2, and then click OK.
    5. Select First Full Backup, and then click OK.
  • Configure the second selective copy with Last Full Backup.
    1. From the CommCell Browser, expand Policies | Storage Policy | storage policy.
    2. Right-click the selective copy, and then click the Properties.
    3. Click the Selective Copy tab, from the Automatically select Full Backups at frequency list, select Advanced, and then click Advanced.
    4. In the Advanced dialog box, select Every <x> Cycles, specify the value as 2, and then click OK.
    5. Select Last Full Backup, and then click OK.

This allows you to copy the alternate cycles jobs to two different selective copies by implementing the mod logic explained in the How does the job selection work with advanced cycle-based criteria?.

Copy Alternate Full Backup Jobs to Two Different Selective Copies

If you created two selective copies with same advanced frequency criteria (daily/weekly/monthly), for example:

  • Selective copy01 and copy02 was created on Jan 01 with following options on Copy Properties dialog box:
    • In the Automatically select Full Backups at frequency list, Advanced.
    • In the Advanced Options dialog box, Every 2 months.
    • Under For each time period copy the section, Last Full backup option and Wait until the current period is over before selecting a backup for this time period option.

The above selective copy criteria copies last full back up on both the selective copies for every two months, that is the period for both copies starts from Jan 01 to Feb 28.

If you want full backup jobs to be copied to two different selective copies alternatively, for example:

  • For copy01, you want to copy the last full backup job that ran between Jan 01 to Feb 28, Mar 01 to  Apr 30, and so on.
  • For copy02, you want to copy the last full backup job that ran between Feb 28 to Mar 31, Apr 01 to May 31, and so on.

Then do the following:

  1. On the ribbon of the CommCell Console, click the Storage tab, and then click Media Management.
  2. On the Media Management Configuration dialog box, click the Auxiliary Copy Configuration tab.
  3. In the Allow user to modify selective copy job selection period start time box, enter 1 to enable.

    Re-open the CommCell Console to view the advanced frequency options on the selective copy properties.

  4. From the CommCell Browser, expand Policies | Storage Policies | storage policy.
  5. Right-click selective copy (copy02) and then click Properties.
  6. On the Copy Properties dialog box, click the Selective Copy tab.
  7. Click Advanced.
  8. On the Advanced Options dialog box, select Move Job Selection Period Start Time by n Month(s) check box and then enter 1.
  9. Click OK.
  10. Click OK.

When enabled and an Auxiliary Copy operation is run, the last full backup jobs between:

  • Jan 01 to Feb 28, Mar 01 to Apr 30 and so on is copied to copy01
  • Feb 28 to Mar 31, Apr 01 to May 31, and so on is copied to copy02

Effect of Jobs That Completed with Errors

For File System and File System like Agents, the selective copy will copy backup jobs that completed with errors (CWE). However, if these jobs are associated with Database Agents, the selective copy will not copy them.

The following table lists the Agents by type and displays if Agents with jobs that completed with errors are valid for selective copy.

Agent Type Agents CWE Jobs are copied?
File System Agents
  • Macintosh File System
  • Microsoft Windows File Systems (excluding ASR backups)
  • OES File System
  • Unix File Systems
Yes
File System Like Agents
  • Active Directory
  • Exchange Compliance Archiver
  • External Data Connector
  • Image Level
  • Lotus Notes Database (DB files only)
  • Lotus Notes Document
  • Microsoft Exchange Mailbox
  • Microsoft Exchange Public Folder
  • Microsoft SharePoint Server
  • Migration Archiver Agents
    • Domino Mailbox Archiver
    • Exchange Mailbox/Public Folder Archiver
    • File Archiver for Windows and Unix
    • SharePoint Archiver
  • NAS
  • Virtual Server
Yes
Database Agents
  • DB2
  • DB2 MultiNode
  • Documentum
  • Informix
  • Microsoft Exchange Database
  • Microsoft SQL Server
  • MySQL
  • Lotus Notes Database (Log files only)
  • Oracle
  • Oracle RAC
  • PostgreSQL
  • SAP for Oracle
  • Sybase
No
Other Agents ContinuousDataReplicator Not Applicable