Subclients - Oracle - How To

From the CommCell Browser, right-click the subclient whose associated storage policy you want to change, then click Properties from the shortcut menu.
Click the Storage Device tab of the Subclient Properties dialog box.
From the Storage Policy list of the Data Storage Policy tab, select a data storage policy to associate with this subclient. If necessary, click the Create Storage Policy button to create a new storage policy to which the subclient can then be associated.
From the Changing a Storage Policy window select the next type of backup operation. Click OK.
If applicable for your agent, you can change the number of data streams from the Number of Data/Database Backup Streams field.
If applicable for your agent, click the Log Storage Policy tab and select a storage policy to associate with this transaction log subclient from the Transaction Log Storage Policy list. Also, you can set the Number of Transaction Log Backup Streams from this tab.
Click OK to save your changes and close the Subclient Properties Storage Device tab.

Change Account for Executing Pre/Post Commands (Data Protection)

Required Capability: See Capabilities and Permitted Actions

To change a user account for executing pre/post commands for Data Protection jobs:

From the CommCell Browser, expand the tree to view the appropriate level icon for the affected agent.
- From the agent, instance/partition, or backup set/archive set level, right-click the appropriate icon, click All Tasks, and click New Subclient from the short-cut menu.
- From the subclient level, right-click the subclient icon and click Properties from the short-cut menu.
From the Subclient Properties dialog box, create and/or configure the subclient as appropriate. Then click the Pre/Post Process tab.
From the Pre/Post Process tab, click Change.
From the User Account dialog box, select one of the account options. If you select Impersonate User, type the appropriate user name and password.
Click OK to save the settings.

Configure a Subclient for Pre/Post Processing of Data Protection/Archive Operations

Before You Begin

We recommend not configuring a pre/post process for a subclient that is currently running a data protection or archive operation.
Verify that there are no pre/post processes already assigned for the subclient.
Review the Overview and Agent-Specific Guidelines for your agent before configuring pre/post processes for data protection/archive operations.
Pre-process commands for the iDataAgents will be executed only when the necessary resources (e.g., media, library, drive, etc.) are available.

Required Capability: Capabilities and Permitted Actions

To configure a subclient for Pre/Post processing of data protection/archive operations:

From the CommCell Browser, right-click the subclient for which you want to configure a pre/post process, and then click Properties from the shortcut menu.
Click the Pre/Post Process tab of the Properties dialog box.
For an agent other than the Oracle RAC iDataAgent, click inside the space that corresponds to one of the following phases and type the full path of the process that you want executed during that phase. Alternatively, click Browse to locate the process (applicable only for paths that do not contain any spaces). For the Oracle RAC iDataAgent, click Browse for the corresponding process, click the name of the control node client in the Select Client for Browse dialog box, and click OK. Then browse for and click the process.
- PreBackup
- PreScan
- PreArchive
- PreCopy
- PreSnap
- PostBackup
- PostScan
- PostArchive
- PostCopy
- PostSnap
Click OK.
If you want to run a Post Process for all attempts to run that job phase, then select the corresponding checkbox.
For subclients on Windows platforms, if Run As displays Not Selected, or if you want to change the account that has permission to run these commands, click Change.
1. In the User Account dialog box, select Use Local System Account, or select Impersonate User and enter a user name and password. Click OK.
2. If you selected Local System Account, click OK to the message advising you that commands using this account have rights to access all data on the client computer.
Click OK to save your changes and close the Pre/Post Process tab of the Properties dialog box.

Configure Backup Arguments

Related Topics

Before You Begin

Do not change the backup arguments of a subclient that is being backed up.
For the DB2 and DB2 DPF iDataAgents, you will need to indicate whether the database should be online or offline during backups.
Review Performance Tuning - Oracle or Performance Tuning - Oracle RAC for details on setting configuration parameters to optimize backup and restore operations for your site.

Required Capability: See Capabilities and Permitted Actions

To configure backup arguments for a subclient:

From the CommCell Browser, right-click the subclient whose backup arguments you want to configure, then click Properties from the shortcut menu.
Click the appropriate tab of the Subclient Properties dialog box for your iDataAgent:
Select the desired backup argument settings that you want configured for this subclient.
Click OK to save your changes.

Configure Subclient Content

Before You Begin

Review Subclients.
Do not configure the content of a subclient while the parent node or any sibling subclient has a data protection or archive operation currently running on it.
Exchange Mailbox iDataAgents and Exchange Mailbox/Public Folder Archiver Agents: If you change the contents of the default backup set or archive set then the auto-discover feature will be disabled. If you disable the auto-discovery feature, newly created mailboxes will not be backed up/archived unless they are manually discovered and assigned to a subclient.
NAS NDMP iDataAgents: You must ensure there is no overlap in content between all subclients. Overlap in subclient content will result in loss of data. An existing subclient's contents are not automatically changed when another subclient is added with overlapping contents.
SharePoint Server iDataAgent: The Site Content Database, the Site Collection Database, the Site Database, and the Site Index for the virtual server must all be assigned to the same subclient.
Lotus Notes Document iDataAgent: Review Assigning Restore View Names to Newly-discovered Databases
QR Agent: Follow these guidelines when adding a volume to a QR Agent subclient:
- The volume must correspond to a physical disk or RAID array.
- A volume created by volume management software other than VxVM is not valid subclient content.
- Subclients may have overlapping content; however, if two or more subclients overlap, they all must use the same snapshot engine. If the QR policies associated with the subclients are configured to use different snap engines, they must be reconfigured to use the same snap engine in this scenario.
Caution Against Re-configuring Default Subclient Content
We recommend that you do not re-configure the content of a default subclient because this would disable its capability to serve as "catch-all" entity for client data. As a result, the likelihood that some data will not get backed up or scanned for archiving would increase.

Required Capability: See Capabilities and Permitted Actions

To configure subclient content:

From the CommCell Browser, right-click the subclient for which you want to configure content, click All Tasks (if applicable) and then click Properties.
Follow the procedure below that is applicable for your agent:
- For File System, Active Directory, File Archiver, Exchange Public/Web Folder iDataAgents, NDS, and SharePoint Server iDataAgents click the Subclient Properties (Content) tab and configure content for the subclient as described below for your agent:
  - For File System, Active Directory, File Archiver, NDS, and SharePoint Server iDataAgents: Type the full path of the data that you want to include as subclient content in the Enter New Content field, then click Add. Optionally, click Browse to enter the content. When browsing content while configuring SharePoint subclients, you can add content via multiple selections with the CTRL or SHIFT keys. For Windows, when specifying a UNC Path, click As User, and enter the user account information for the domain user with permissions for that path. For NetWare/DNS, see the Notes section below for content path examples. For Unix File Systems, you can enter the mount point of an NFS-mounted file system, see the Notes section below for examples.
  - For Exchange Public/Web Folder iDataAgents: Click Browse, select folders to include as content, then click Add.
- For NAS NDMP iDataAgents, configure the Backup Content Path field(s) as described below, then click Add:
  - Click the drop-down list arrow to display the root volumes on the file server. To change the root volume, click one in the list. If you want to refine the content path further, use the space to the right of (or below) the root volume list to enter additional path information. Note the following:
    - For NetApp, the root volume is the mount path of each volume.
      Example: for volume FS1 the root volume will be /vol/FS1.
    - For EMC Celerra, the root volume is the mount point created for a volume.
      Example: for volume FS1 with mount point /FS1 the root volume will be /FS1.
    - For Hitachi, no root volumes are shown in the drop down list. Type the full path of the root volume.
      Example: for volume FS1 with mount point /mnt/FS1 the root volume will be /mnt/FS1.
    - For BlueArc, the root volume is a combination of a descriptor of the path and the volume name.
      Example: for volume FS1 with a mount point of / the root volume will be /__VOLUME__/FS1.
  - Optionally, for NetApp NAS NDMP, click Browse to enter the content.
- For Exchange Mailbox and Exchange Mailbox/Public Folder Archiver Agents follow the procedure to Discover and Assign New Mailboxes or Assign Mailboxes to Another Subclient.
- For DataArchiver for Exchange Agents follow the procedure to Discover and Assign New Journal Mailboxes or Assign Journal Mailboxes to Another Subclient.
- For Lotus Notes Database and Document iDataAgents follow the procedure to Discover and Assign New Databases or Assign Databases to a Subclient.
- For DB2, DB2 DPF, Exchange Database, Novell GroupWise, SharePoint Server, SQL Server 2000 Database, Sybase, and MySQL iDataAgents, click the Subclient Properties (Content) tab and configure content for the subclient as described below for your agent:
  - For the DB2 iDataAgent, specify whether you want to include the entire database or a subset of this data as content for the subclient. For the DB2 DPF iDataAgent, specify whether you want to include all the affected database partitions or a subset of this data as content for the subclient.
  - For Exchange and GroupWise iDataAgents: Click Configure. From the Add/Modify Subclients dialog box click the subclient entry for the database element/Storage Group that you want to add to the new subclient and select the name of the destination subclient from the list that appears. Alternatively, you can select and assign a range of databases/storage groups using the Change all selected databases/storage groups to list. Note that you must have at least one database element/Storage Group assigned to this subclient in order to save the configuration.
    A database/Storage Group that is not configured for a subclient does not appear in the list. This can be the case if the subclient containing the database/Storage Group was deleted. If this happens, click Discover to display all databases/Storage Groups.
  - For the SharePoint Server iDataAgent, follow the procedure to Discover and Assign New Data Types.
  - For the SQL Server 2000 Database iDataAgent, follow the procedure to Configure SQL Server 2000/2005 Databases or Configure SQL Server 2000/2005 Files and File Groups.
  - For the Sybase iDataAgent, follow the procedure to Configure Sybase Databases.
  - For the MySQL iDataAgent, follow the procedure to Configure MySQL Databases.
- For the Informix iDataAgent, click the Subclient Properties (Content) tab and define the contents of the subclient. Specifically, establish the backup mode for the data to be backed up, set the backup level, and decide whether to back up the emergency boot file and/or the ONCONFIG file.
- For the Oracle, SAP for Oracle, or Oracle RAC iDataAgent, click the Subclient Properties (Content) tab and define the contents of the subclient. To configure this subclient for specialized types of backups, follow the appropriate procedure below:
- For SAN iDataAgents, click the Subclient Properties (Content) tab and configure content for the subclient as described below for your agent:
  - Image Level on Unix iDataAgent: Click Add. From the Add Content Path dialog box, select the volume(s) that you want to back up (use CTRL + click to select multiple volumes). Click OK. The selected volumes are added to the Contents of subclient list. These volumes are automatically configured to be CXBF devices. Alternatively, use Volume Explorer per specific scenarios to configure CXBF devices.
    To configure an unmounted block device or raw device as content, first use Volume Explorer to configure the device as a CXBF device. Then select the configured CXBF device as subclient content. You can ignore the warning that is displayed.
    
    For more information, see When to Use Volume Explorer. For a step-by-step procedure, see Configure a CXBF Device in Volume Explorer.
  - Image Level and Image Level ProxyHost on Windows iDataAgents: Click Add. Then in the Add Content dialog box, type the full path of the volume or mount point that you want to include as subclient content, then click Add. Optionally, click Browse to select the content. Click OK. The volume or mount point is added to the Contents of subclient list. Add additional content by repeating this step.
  - ProxyHost iDataAgent: Select a backup host from the Backup Host list. This is the computer to which the BCV is connected. Click Add. In the Content field of the Add/Edit Content for Subclient dialog box, type the primary host path of the content that you want to back up, or click Browse to find and select this data. In the Backup Host BCV Path field of the Add/Edit Content for Subclient dialog box, type the path through which the backup host accesses this data on the BCV, or click Browse to find and select this path. Click OK. The primary host data path and corresponding backup host BCV path are added as a single entry in the Contents of subclient list. To add additional entries, repeat these steps. Refer to Notes below for more information.
- For Quick Recovery Agents, click the Subclient Properties (Content) tab and configure the following options:
  - Click Add Volume. From the Adding Volume dialog box, select volume(s) that you want to add to the subclient content (use CTRL + click to select multiple volumes). You can add/edit additional advanced options for the selected volume by select Advanced on the Adding Volume dialog box. Click OK.
  - Click Add App to select an application and associated volumes. Click OK.
    Any instances you intend to protect and recover with the QR Agent must be configured in the QR Agent properties Authentication tab. They will not appear in the Add App dialog box if they are not configured. Only volumes containing datafiles and archive log files will be detected by Add App. Volumes containing control files and redo log files will not be detected.
    
    For a clustered Exchange Server, if you are not using VSS to perform an online quiesce, sufficient permissions are required in order to be able to perform an offline quiesce; in such cases, ensure that the User Name specified has Exchange Administrator rights.
    
    See also Configure Subclients for Overlapping Content.
Click OK to save your content configuration.

NOTES

Content examples for NetWare are OU=prospects.O=engineering.[Root], (for NDS content), and SYS:\public (for File System content).
Content examples for adding an NFS-mounted file system to subclient content of a Unix File System iDataAgent:
- /mountpointA to include the entire file system at mountpointA
- /mountpointA/projects for only the projects directory within the file system at mountpointA.
Informix subclients include one or more dbspaces. As databases are added to the dbspaces, the subclients are updated automatically.
SQL Server 2000 Database iDataAgents: The logical and physical names are available to assist in identifying the correct content. Files and file groups that are configured as content of other subclients are unavailable for selection.
Exchange Mailbox iDataAgents and Exchange Mailbox/Public Folder Archiver Agents: Initially, all unconfigured mailboxes are assigned to the default subclient. You can create a new subclient and reassign mailboxes to this new subclient (within the same backup set/archive set). Once assigned, the mailboxes become part of the content of the new subclient.
SharePoint Server iDataAgent: Initially, all unconfigured data types are assigned to the default subclient. You can create a new subclient and reassign data types to this new subclient. Once assigned, they become part of the content of the new subclient.

ProxyHost iDataAgent: The primary host data path is backed up by the subclient and is the path through which the backup host accesses this data on the BCV. A primary host path and its corresponding backup host path are listed in the following format:

<primary_host_path> --> <backup_host_path>

For example, assume that you want to back up the D:\data directory from your primary host and D:\ is mirrored by a BCV, which is mapped to the backup host as F:\. Consequently, the path to this data on the backup host is F:\data. When you add this directory to a subclient, it is listed in the Contents of subclient pane as D:\data --> F:\data.

The primary host path in the Content field is used for browse and restore purposes. However, it is the data in the Backup Host BCV Path which is actually backed up. If these two paths do not accurately correspond, the path that appears when data is browsed for restore does not accurately reflect the data that will be restored. In the example given above, assume that D:\data is entered in the Content field, while F:\data1 is accidentally entered in the Backup Host BCV Path. If you browse and select D:\data to be restored, it is actually D:\data1 that is restored. (Remember, F:\Data1 is the path on the backup host that corresponds to D:\data1 on the primary host.)

Configure the Lights Out Script to Shut Down the Database for Offline Backups

Related Topics

Before You Begin

Do not change the backup arguments of a subclient that is being backed up.
Oracle iDataAgent: Review Configuring the Lights Out Script to Shut Down the Database for Offline Backups for an overview of this feature.
Oracle RAC: Review Configuring the Lights Out Script to Shut Down the Database for Offline Backups for an overview of this feature.

Required Capability: See Capabilities and Permitted Actions

To configure the lights out script to shut down the database for offline backups on a subclient:

From the CommCell Browser, right-click the subclient whose lights out script you want to configure, then click Properties from the shortcut menu.

Click the Subclient Properties Subclient Properties (Backup Arguments) tab, then configure the following options as appropriate:

Select the Lights Out Script option to enable automatic execution of this script before backing up the database.
For Oracle on Unix, select the Warning option to enable a warning message that will be displayed on the physical node for users logged into the database, that the database will be shut down.
For Oracle on Unix, in the Delay Time (min) field, enter the number of minutes that you want the script to wait after sending out the warning message to the physical node before the system attempts to shut down the database.
If you are configuring Oracle RAC, then skip to step 3, as the remaining options in this step apply only to the Oracle iDataAgent.
In the Sleep Time (sec) field, enter the number of seconds that you want the script to wait between retry attempts to shut down the database and check the status. This field is used by the lights out script in the event that the first attempt to shut down the database was unsuccessful after the Delay Time has expired.
In the Tries Number field below the Sleep Time (sec) field, enter the number of times that you want the script to retry attempts to shut down the database when the Sleep Time (sec) field is activated.
In the Sleep Time (min) field, enter the number of minutes that you want the script to wait between retry attempts to shut down the database and check the status. This field is used by the lights out script in the event that the Tries Number limit has been reached for the Sleep Time (sec) field.
In the Tries Number field below the Sleep Time (min) field, enter the number of times that you want the script to retry attempts to shut down the database when the Sleep Time (min) field is activated.

Select the Use SQL Connect option to connect to the database using the SQL command �connect <connect string> as sysdba�. The �Connect String� entry is configured in the Instance Properties (Details) tab. Note that if this option is not selected, the CommServer sets the service name using �set oracle_sid=<Instance name>� and connects to the database using the �connect /as sysdba� command. The Instance name is displayed in the Instance Properties (General) tab.

On AIX 64 bit platform, you should always use the SQL_CONNECT option to shutdown and start the database in mount mode. This is required because of the limitation in SQL Plus to connect using / when the EXTSHM variable is set.

Select any other options as appropriate, then click OK to save the changes.

Configure the Subclient for Data Encryption

Encryption settings made at the subclient level are for data protection and recovery operations run from the CommCell Console and are not related in any way to settings made at the instance level which is for third-party Command Line operations only.

See Data Encryption - Support for a list of supported products.

Before You Begin

Encryption must be enabled at the client level prior to configuring any subclients residing on that client. See Configure the Client for Data Encryption.
If you are attempting to configure for third-party Command Line operations, do not use this procedure. See Configure Third-party Command Line Operations for Encryption.

Required Capability: Capabilities and Permitted Actions

To configure the subclient for data encryption:

From the CommCell Console, right-click the subclient and click Properties.
From the Subclient Properties (Encryption) tab, select an option based on the criteria described in the Encryption tab help.
Click OK to save your settings and close subclient properties.

Create a New Subclient

Before You Begin

Review Subclients.
Do not create a subclient while the parent node or any sibling subclient has a data protection or archive operation currently running on it.
In cases where a new subclient is created with the same name as a deleted subclient, the system will append a Unix time stamp to the deleted subclient's name in data protection job history reports and views to distinguish the two subclients. For example, subclientname_1104257351.
Informix iDataAgents: If you will be using the Informix ONBAR utility to create backup and restore scripts, you need not create subclients. Otherwise, if you will be using the CommCell Console to back up and restore Informix database objects (subsets/dbspaces), then you will need to create a subclient.
ProxyHost iDataAgents: If you are using a BCV, you must prepare a batch file or a shell script file on the backup host containing commands to synchronize and split the BCV. The Resource Pack includes information on configurations for these batch files or shell scripts, as well as examples that apply to specific applications and hardware (e.g., Exchange databases in an EMC Symmetrix environment). See Tools and Utilities for more information on the Resource Pack.
The ProxyHost iDataAgent also requires that you set permissions for the batch/shell script file on the backup host.
SQL Server 2000/2005 Database iDataAgents: When running on Windows Server 2003 and VSS is enabled, the New Subclient command is not available.

Required Capability: See Capabilities and Permitted Actions

To create a new subclient:

From the CommCell Browser, right-click the node (agent/backup set/archive set/instance) for which you want to create a new subclient, click All Tasks (if applicable), and then simply click New Subclient for most agents.
- For the SQL Server iDataAgent, expand New Subclient and click either Database to include individual databases or File/File Group to include database elements.
- For the File Archiver Agent for Windows with Data Classification, right-click the DataClassSet, expand All Tasks, and then click Create DataClassSet (subclient).
Click the General tab or General (Quick Recovery Agent) tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
- For supported agents identified in Support Information - Snapshot Engines, you can select a QSnap option to snap data and then perform a data protection operation on the data.
- For QR Agents, you must also select a QR Policy from the QR Policy list.
- For the Windows iDataAgents that support VSS, you can optionally Enable VSS on a Subclient.
Select other options from the General tab as appropriate for the agent.
Click the Content or Databases tab of the Subclient Properties dialog box and Configure Subclient Content as appropriate for your agent.
For all agents (except QR), click the Storage Device (Data Storage Policy) tab of the Subclient Properties dialog box, then select a data storage policy to associate with this subclient from the storage policy list.
- For the DB2 and DB2 DPF iDataAgents, you can also change the number of data backup streams. For the DB2 DPF iDataAgent, the default stream threshold should be equal to the total number of database partitions for the subclient.
- For SQL Server iDataAgents, you can also click the Storage Device (Log Storage Policy) tab of the Subclient Properties dialog box, then select a log storage policy to associate with this subclient from the storage policy list and select the number of backup streams for transaction log backup jobs.
- For 1-Touch for Unix, it is strongly recommended that the storage policy that you select for the subclient configured for 1-Touch use a MediaAgent on a different computer. If you do this, and if the system crashes, the media will not have to be exported to another MediaAgent in order to recover the system.
For Oracle and DB2 iDataAgents, click the Backup Arguments (Oracle) or Backup Arguments (DB2, DB2 DPF) tab of the Subclient Properties dialog box and Configure Backup Arguments as appropriate for your agent. Note that the backup arguments for Informix are located on the Content tab.
For Migration Archiver Agents, click the Archiving Rules or Rules tab of the Subclient Properties dialog box and configure archiving rules as appropriate for your agent. In order to perform rules-based migration archiving operations, the Disable All Rules checkbox must be cleared.
If the File Archiver for Windows supports Data Classification, several filter-like configuration fields are defined as archiving rules and are available from the Subclient Properties (Rules) tab. If you want to define content and archiving rules based on file attributes other than volumes, size, and modified time (i.e., if you want to customize your rules), click the Advanced tab and configure as appropriate. Also, stub management options can be configured from the Stub Rule tab. See Configure Archiving Rules - File Archiver Agents for step-by-step instructions.
For ProxyHost and Image Level ProxyHost iDataAgents, click the Pre/Post Process tab of the Subclient Properties dialog box. In the PreScan field, type the path to the batch file/shell script file that contains those commands that are to run before each backup of the subclient, or click Browse to locate and select this file. For ProxyHost and Image Level ProxyHost, the file must reside on the backup host or primary host.
Optionally (if supported for your agent) you can:
- Add a Data Protection or Discovery Filter for a Subclient on the Filters tab.
- Configure a Subclient for Pre/Post Processing of Data Protection/Archive Operations on the Pre/Post Process tab.
- Enable Software Compression for a Subclient on the Software Compression tab of the Storage Device tab.
- Configure the Subclient for Data Encryption on the Encryption tab.
- Enable or Disable Operations for this subclient on the Activity Control tab.
- Configure Mailbox Stores for Auto-Discovery on the Auto-discovery tab.
- Configure the Subclient for 1-Touch on the 1-Touch Recovery tab.
- View or change the user group security associations for this subclient from the Security tab.
- Determine location from where archive logs will be backed up or deleted from the Log Destinations tab.
- Enable backups using a snap engine from the Snap Backups tab.
Click OK to save the subclient configuration. For QR Agents, this procedure is now complete. For all other agents, continue on to the next step.
The Backup Schedule dialog box advises you to schedule data protection operations for your new subclient. It is recommended you elect to set a schedule now. You can also associate this subclient with an All Agent Types schedule policy (which is automatically created by the system, or can be a user defined Data Protection schedule policy). If you have already associated a schedule policy at a previous level (Backup Set/Instance, Agent, Client, or Client Computer Group) the schedules defined in the Schedule Policy will be automatically applied to the new subclient. See Schedule Policy for more information.
- If you want to associate this subclient with an All Agent Types schedule policy, click Associate with Generic Schedule Policy, and then select that schedule policy from the drop-down list box. Click OK.
- If you want to associate this subclient with a specific schedule policy, click Associate to schedule policy, and then select the schedule policy from the drop-down list box. Click OK.
- If you have selected to define a schedule for this subclient:
  - Click Schedule.
  - From the Backup/Archive Options dialog box, select the type of data protection operation that you want to schedule.
  - If you want to set Advanced Backup/Archive Options, click Advanced.
  - After selecting the data protection type and any advanced options, click OK. The Schedule Details dialog box appears.
  - From the Schedule Details tab, select the scheduling options that you want to apply, then click OK.
- If you don't want to create a data protection schedule at this time, click Do Not Schedule, and then click OK.

This task is now complete.

Create Subclient for Backing Up Archived Redo Log Files

Related Topics:

The following procedure demonstrates how to create a subclient for backing up archived redo log files with the following features:

Includes only archived redo log files.
Deletes the archived redo log files once they are backed up.
Re-synchronizes the contents of the Recovery Catalog with the contents of the Control File.

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients.
Oracle archives online redo log files once they become full. These logs can be used to recover database transactions that have been lost due to an operating system or disk failure, by applying them to an online backup in order to recover a database. Because of their importance in recovering data, it is recommended that you create separate subclients for backing up archived redo log files.
Archived redo log files are always backed up as a full backup even if incremental is selected.

Required Capability: See Capabilities and Permitted Actions

To create a subclient for backing up archived redo log files:

From the CommCell Browser, right-click the instance for which you want to create a new subclient, click All Tasks then click New Subclient.
Click the General tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
For Oracle or SAP for Oracle, click the Content tab. For Oracle RAC, click the Logs Backup tab and select the following option:
- Backup Archive Log - Specifies that archived redo log files will be backed up. These logs can be applied to the database in order to recover it to a point-in-time.
- Archive Delete - Specifies that archived redo log files are deleted once they are backed up. Note that any archived redo log files that do not match the format indicated by the LOG_ARCHIVE_FORMAT environment variable are not deleted.
Optionally, for Oracle RAC, use the directional arrows to reset the client/instance backup order.
Click the Backup Arguments tab and select the following options:
- Archive Files per BFS - Establishes the number of archive files to be bundled in each backup set (Default is 32).
- Resync Catalog - Specifies that the contents of the Recovery Catalog will be synchronized with the contents of the Control File (This option is automatically enabled by default when the Backup Archive Log option is selected on the Content tab in Step 3 above).
Click the Storage Device tab of the Subclient Properties dialog box, then select a storage policy to associate with this subclient from the storage policy list.
Optionally, you can:
- Establish Pre/Post processes using the Pre/Post Process tab.
- Enable a software compression scheme for the subclient from the Software Compression tab on the Storage Device tab.
- Enable De-Duplication for the subclient from the De-Duplication tab on the Storage Device tab.
- Enable data encryption for backups on the Encryption tab.
- Enable/disable backups for this subclient on the Activity Control tab.
- Select archive log destinations for backup and deletion on the Log Destinations tab.
Click OK to save the subclient configuration.
You will be prompted to create a backup schedule for the newly created item. Select Schedule if you want to create a backup schedule for this subclient, otherwise select Do Not Schedule if you don't want to create a backup schedule for this subclient, then click OK.
If you selected Do Not Schedule in the previous step, then this procedure is now complete. If you selected Schedule, the Backup Options dialog box appears.
From the Backup Options dialog box, select the type of backup that you want to schedule. If you want to access Advanced Backup Options, click Advanced.
Click Backup Archive Logs tab, if available, and select the criteria based on which the archive logs will be backed up. For more information, see Backup Archive Log Options.
Click OK. The Schedule Details dialog box appears.
From the Schedule Details (Schedule Details) tab, select the scheduling options that you want to apply, and then click OK.

Create Subclient for Backing Up Offline Databases

Related Topics:

The following procedure demonstrates how to create a subclient for backing up an offline database with the following features:

Includes Control Files (where applicable).
Incremental backup level set to 1, 2, 3 or 4. By default the system performs an incremental level 1 backup. The first time you back up the subclient the system performs a full backup for the subclient before performing a level 1, 2, 3, or 4 incremental backup.
Database is taken OFFLINE and available in the MOUNT mode for the backup.

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients..
Make sure that the database used for creating the subclient is up and running. This ensures that the system accesses the most recent configuration of the database.

Required Capability: See Capabilities and Permitted Actions

To create a subclient for backing up offline databases:

From the CommCell Browser, right-click the instance for which you want to create a new subclient, click All Tasks and then click New Subclient.
Click the General tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
Click the Content tab and select the following options where available:
- Data - Specifies that data files will be backed up.
- Offline Database - Establishes the backup as an offline database backup.
- Backup Control File - Specifies that the backup control files will be included in the subclient backup.
Click the Backup Arguments tab where available and select the following options:
- Lights Out Script - Specifies that the Lights Out Script will be automatically executed before backing up offline databases. This script shuts down the database and by default uses the SPFile to start up the database in MOUNT mode. Once the backup is completed, the script opens the database.
- STARTUP PFILE location - Specifies the location of the PFile to be used for starting up the database. You need to select this option only if you want to start up the database using the PFile. By default, the system uses the SPFile available in $ORACLE_HOME/dba directory (for Unix) or $ORACLE_HOME/database directory (for Windows) to start up the database.
Do not select the Offline Arguments option if you would like to manually start the database in MOUNT mode before you back up the subclient.
Click the Storage Device tab of the Subclient Properties dialog box, then select a storage policy to associate with this subclient from the storage policy list.
Optionally, you can:
- Establish Pre/Post processes using the Pre/Post Process tab.
- Enable a software compression scheme for the subclient from the Software Compression tab on the Storage Device tab.
- Enable De-Duplication for the subclient from the De-Duplication tab on the Storage Device tab.
- Enable data encryption for backups on the Encryption tab.
- Enable/disable backups for this subclient on the Activity Control tab.
- For Oracle RAC, enable archive log backups and use the directional arrows to reset the client/instance backup order on the Logs Backup tab.
- Select archive log destinations for backup and deletion on the Log Destinations tab.
Click OK to save the subclient configuration.
You will be prompted to create a backup schedule for the newly created item. Select Schedule if you want to create a backup schedule for this subclient, otherwise select Do Not Schedule if you don't want to create a backup schedule for this subclient, then click OK.
If you selected Do Not Schedule in the previous step, then this procedure is now complete. If you selected Schedule, the Backup Options dialog box appears.
From the Backup Options dialog box, select the type of backup that you want to schedule. If you want to access Advanced Backup Options, click Advanced. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Create Subclient for Backing Up Online Databases

Related Topics:

The following procedure demonstrates how to create a subclient for backing up an online database with the following features:

Includes control files (where applicable).
Data Files bundled in each backup set is set to 32 (default is 64).
Incremental backup level set to 1, 2, 3 or 4. By default the system performs an incremental level 1 backup. The first time you back up the subclient the system performs a full backup for the subclient before performing a level 1, 2, 3, or 4 incremental backup.
Excludes Archived Redo Log files. It is recommended that you create separate subclients for archive redo logs.

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients.
Make sure that the database used for creating the subclient is up and running. This ensures that the system accesses the most recent configuration of the database.

Required Capability: See Capabilities and Permitted Actions

To create a subclient for backing up online databases:

From the CommCell Browser, right-click the instance for which you want to create a new subclient, click All Tasks and then click New Subclient.
Click the General tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
Click the Content tab and select the following options where available:
- Data - Specifies that data files will be backed up.
- Online Database - Establishes the backup as an online database backup.
- Backup Control File - Specifies that the backup control files will be included in the subclient backup.
Click the Backup Arguments tab where available and select the following option:
- Data Files per BFS - Establishes the number of datafiles to be bundled in each backup set - set this to 32.
Click the Storage Device tab of the Subclient Properties dialog box, then select a storage policy to associate with this subclient from the storage policy list.
Optionally, you can:
- Establish Pre/Post processes using the Pre/Post Process tab.
- Enable a software compression scheme for the subclient from the Software Compression tab on the Storage Device tab.
- Enable De-Duplication for the subclient from the De-Duplication tab on the Storage Device tab.
- Enable data encryption for backups on the Encryption tab.
- Enable/disable backups for this subclient on the Activity Control tab.
- Select archive log destinations for backup and deletion on the Log Destinations tab.
Click OK to save the subclient configuration.
You will be prompted to create a backup schedule for the newly created item. Select Schedule if you want to create a backup schedule for this subclient, otherwise select Do Not Schedule if you don't want to create a backup schedule for this subclient, then click OK.
If you selected Do Not Schedule in the previous step, then this procedure is now complete. If you selected Schedule, the Backup Options dialog box appears.
From the Backup Options dialog box, select the type of backup that you want to schedule. If you want to access Advanced Backup Options, click Advanced. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Create Subclient for Backing Up Online Subsets

Related Topics:

The following procedure demonstrates how to create a subclient for backing up an online subsets that include tablespaces/datafiles with the following features:

Excludes Control Files.
Incremental backup level set to 1, 2, 3 or 4. By default the system performs an incremental level 1 backup. The first time you back up the subclient the system performs a full backup for the subclient before performing a level 1, 2, 3, or 4 incremental backup.
Excludes Archived Redo Log Files. It is recommended that you create separate subclients for archive redo logs.

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients.
Make sure that the database used for creating the subclient is up and running. This ensures that the system accesses the most recent configuration of the database.

Required Capability: See Capabilities and Permitted Actions

To create a subclient for backing up online subsets:

From the CommCell Browser, right-click the instance for which you want to create a new subclient, click All Tasks and then click New Subclient.
Click the General tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
Click the Content tab and select the following options:
- Data - Specifies that data files will be backed up.
- Online Subset - Establishes the backup of a subset of database objects. The database tree displays the subsets that are available in the database. Click the objects in the tree to include the subset objects for the subclient.
Click the Backup Arguments tab where available and select the desired options.
Click the Storage Device tab of the Subclient Properties dialog box, then select a storage policy to associate with this subclient from the storage policy list.
Optionally, you can:
- Establish Pre/Post processes using the Pre/Post Process tab.
- Enable a software compression scheme for the subclient from the Software Compression tab on the Storage Device tab.
- Enable De-Duplication for the subclient from the De-Duplication tab on the Storage Device tab.
- Enable data encryption for backups on the Encryption tab.
- Enable/disable backups for this subclient on the Activity Control tab.
- Select archive log destinations for backup and deletion on the Log Destinations tab.
Click OK to save the subclient configuration.
You will be prompted to create a backup schedule for the newly created item. Select Schedule if you want to create a backup schedule for this subclient, otherwise select Do Not Schedule if you don't want to create a backup schedule for this subclient, then click OK.
If you selected Do Not Schedule in the previous step, then this procedure is now complete. If you selected Schedule, the Backup Options dialog box appears.
From the Backup Options dialog box, select the type of backup that you want to schedule. If you want to access Advanced Backup Options, click Advanced. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Create Subclient for Performing Selective Online Full Backups

Related Topics:

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients.

Required Capability: See Capabilities and Permitted Actions

To create a subclient for performing Selective online full backups:

From the CommCell Browser, right-click the instance for which you want to create a new subclient, click All Tasks and then click New Subclient.
Click the General tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
Click the Content tab to define the contents of the subclient. Click the Selective Online Full checkbox to enable selective online full backups for this subclient.
Click the Backup Arguments tab where available to define backup arguments for the subclient.
Click the Storage Device tab of the Subclient Properties dialog box, then select a storage policy to associate with this subclient from the storage policy list.
Optionally, you can:
- Establish Pre/Post processes using the Pre/Post Process tab.
- Enable a software compression scheme for the subclient from the Software Compression tab on the Storage Device tab.
- Enable data encryption for backups on the Encryption tab.
- Enable/disable backups for this subclient on the Activity Control tab.
- For Oracle RAC, enable archive log backups and use the directional arrows to reset the client/instance backup order on the Logs Backup tab.
- Select archive log destinations for backup and deletion on the Log Destinations tab.
Click OK to save the subclient configuration.
You will be prompted to create a backup schedule for the newly created item. Select Schedule if you want to create a backup schedule for this subclient, otherwise select Do Not Schedule if you don't want to create a backup schedule for this subclient, then click OK.
If you selected Do Not Schedule in the previous step, then this procedure is now complete. If you selected Schedule, the Backup Options dialog box appears.
From the Backup Options dialog box, select the type of backup that you want to schedule. If you want to access Advanced Backup Options, click Advanced. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Delete a User-Defined Subclient

Related Topics:

Required Capability: See Capabilities and Permitted Actions

To delete a user-defined subclient:

From the CommCell Browser, right-click the user-defined subclient that you want to delete, and then click Delete from the shortcut menu.
A confirmation message is displayed, asking if you want to delete the subclient.
Click No to cancel the deletion and retain the subclient, or click Yes to continue the deletion. If you click Yes:
- the subclient, and any data that may have been protected/archived by the subclient are logically deleted, and you can no longer access the corresponding data for recovery/retrieve purposes. However, the data remains valid for the length of time specified by the associated retention period. Some agents allow you to browse data from a deleted subclient provided that the Browse Data Before date and time precedes the time that the user-defined subclient was deleted.
- for agents that support a default subclient, once the user-defined subclient is deleted its contents are automatically reallocated to the default subclient the next time a data protection/archive/discovery operation is run on the default subclient to ensure data protection coverage.
- the system deletes the selected subclient node and removes it from the CommCell Browser.
- the system deletes any data protection/archive and recovery/retrieve job schedules that are associated with the subclient.

Enable or Disable Operations

Required Capability: See Capabilities and Permitted Actions

Level	Capability
CommCell	Administrative Management with CommCell level association
Client Computer Group	Administrative Management with Client Computer Group level association
Client	Agent Management with Client level association
Agent	Agent Management with Agent level association
Subclient	Agent Management with Subclient level association

To enable or disable activity control at the CommCell, client computer group, client, agent, or subclient levels:

From the CommCell Browser, right-click the CommServe, client computer group, client computer, agent, or subclient, and then click Properties from the short-cut menu.
From the Activity Control tab of the associated Properties dialog box, select or clear option(s), as desired.
Click OK.

Disabled data management and/or data recovery operations are displayed with client and/or agent icon changes in the CommCell Browser. For a comprehensive list of all icons in the CommCell Console, see CommCell Console Icons.

Enable or Disable Software Compression for a Subclient

Before you Begin

Do not enable/disable software compression for a subclient that is being backed up/archived.

Required Capability: Capabilities and Permitted Actions

To enable software compression for a subclient:

From the CommCell Browser, right-click the subclient for which you wish to enable software compression and then click Properties.
Click the Storage Device tab and from the Data Storage Policy tab, select the storage policy from the Storage Policy list.
If applicable for the selected agent, click the Log Storage Policy tab and select a storage policy from the Transaction Log Storage Policy list.
Then click the Storage Device (Data Transfer Option) tab and choose the appropriate compression option for this subclient.
Click OK to save your changes.

This task is now complete.

Remove a Process from Pre/Post Processing of Data Protection/Archive Operations

Before You Begin

We recommend not removing a pre/post process for a subclient that is currently running a data protection or archive operation.
Review the Overview and Agent-Specific Guidelines for your agent before removing pre/post processes for data protection/archive operations.

Required Capability: Capabilities and Permitted Actions

To remove a process from Pre/Post processing of data protection/archive operations:

From the CommCell Browser, right-click the subclient for which you want to remove a pre/post process, and then click Properties from the shortcut menu.
Click the Pre/Post Process tab of the Subclient Properties dialog box.
Click the text inside the space that corresponds to one of the following phases for which you want a pre/post process removed, then press the Delete key:
- PreScan
- PreArchive
- PreCopy
- PreSnap
- PostBackup
- PostScan
- PostArchive
- PostCopy
- PostSnap
Repeat Step 3 for any additional processes that you want to remove.
Click OK.

Rename a Subclient

Before You Begin

You can rename a subclient at any time. However, we recommend that you don't rename a subclient while a data protection or archive operation is running on that subclient.
In cases where a subclient is renamed using the same name as a deleted subclient, the system will append a Unix time stamp to the deleted subclient's name in data protection job history reports and views to distinguish the two subclients. For example, subclientname_1104257351.

Required Capability: See Capabilities and Permitted Actions

To rename a subclient:

From the CommCell Browser, right-click the subclient that you want to rename, and then click Properties from the shortcut menu.
From the Subclient Properties (General) tab, or the QR Agent Subclient Properties (General) tab, type the new name in the Subclient Name field, and then click OK.

The CommCell Browser updates the subclient with its new name. The new name will also be reflected in any associated schedules and reports.

Set the Network Bandwidth and Network Agents for a Data Protection Operation

Before you Begin

Do not modify the network bandwidth and network agents for a subclient or instance that is being backed up.

Required Capability: Capabilities and Permitted Actions

To Set the Network Bandwidth and Network Agents for a Data Protection Operation:

From the CommCell Browser, right-click a subclient and then click Properties.
For the DB2, DB2 DPF, Informix, Oracle, Oracle RAC, SAP, or Sybase iDataAgent, right-click an instance and then click Properties.
Click the Storage Device Data Transfer Option tab.
For the QR Agent:
- To control network bandwidth settings, use the Throttle Network Bandwidth section in the General tab of the Subclient Properties dialog box.
- To control the number of network agents, you must create a nQRNetworkAgents registry key.
Enter a number of Network Agents that must be used to perform data protection operations on the subclient/instance.
Click the Throttle Network Bandwidth (MB/HR) option and then enter the throughput as needed. Note that throttling is done on a per Network Agent basis.
Click OK to save the changes.

This task is now complete.

View Data Paths Associated with a Subclient

Required Capability: See Capabilities and Permitted Actions

To view data paths:

From the CommCell Browser, right-click the subclient whose data paths you want to view, then click Properties from the shortcut menu.
Click the Storage Device tab of the Subclient Properties dialog box.
From the Data [or Logs] Storage Policy tab, click Show Data Paths to view the data paths used by the subclient to access the storage media for data protection operations. Click Close to exit the Data Paths dialog box.
Click OK to exit the Subclient Properties Storage Device tab.

View Subclient Content

Required Capability: See Capabilities and Permitted Actions

To view content of a subclient:

From the CommCell Browser, right-click the subclient whose content you want to view, then click Properties.
From the Subclient Properties dialog box, click the Content tab (or Databases tab for Lotus Notes) to view the contents of the subclient.
Click OK to close the dialog box.

Select Archive Log Destinations for Backup or Deletion

Related Topics:

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients, Things to Consider when Creating and Configuring Oracle RAC Subclients, or Things to Consider when Creating and Configuring SAP for Oracle Subclients.

Required Capability: See Capabilities and Permitted Actions

To select Archive Log destinations for backup or deletion:

From the CommCell Browser, right-click the appropriate subclient, click Properties from the shortcut menu, and then click the Log Destinations tab.
Do either or both of the following:
- Click Select ArchiveLog Destinations for Backup, click Add, click the desired ArchiveLog backup location, and then click OK. Repeat this step for each location that you want to include.
- Click Select ArchiveLog Destinations for Delete, click Add, click the desired ArchiveLog deletion location, and then click OK. Repeat this step for each location that you want to include.
Click OK.

Enable Backup of Flash Recovery Area

Related Topics:

Before You Begin

Make sure that a Flash Recovery Area is set for the Oracle database and all related parameters, such as size, location, and retention policy are configured.
Note that the Flash Recovery Area is an Oracle 10g feature. Therefore, backup of the Flash Recovery Area is possible only with agents that use Oracle 10g.
Note that you can backup the Flash Recovery Area only when the database is online.

Required Capability: See Capabilities and Permitted Actions

To enable backup of Flash Recovery Area:

From the CommCell Browser, right-click the subclient that you want to back up, and choose Properties.
Click SubClient Properties of data (Content) tab.
Select Protect backup recovery area checkbox.
Click OK. The Flash Recovery Area backup is now enabled.

Enable Table Browse for the Subclient

Related Topics:

Before You Begin

Review Things to Consider when Creating and Configuring Oracle Subclients or Things to Consider when Creating and Configuring Oracle RAC Subclients.
Note that you can enable the table browse for only one subclient.

Required Capability: See Capabilities and Permitted Actions

To enable table browse for the subclient:

From the CommCell Browser, right-click the subclient for which you want to enable table browse, and then click Properties.
From the Subclient Properties (Backup Arguments) tab, select Enable Table Browse.
Click OK.