Topics | How To | Related Topics
Things to Consider when Creating and Configuring SAP for Oracle Subclients
The following table shows subclient creation and configuration details specific to the SAP for Oracle iDataAgent.
Agent |
Type of Data | Default Subclient created during install of the Agent | Supports Default Subclient | Supports User Defined Subclient | Contents of the default subclient when user-defined subclient is present | Other Types of subclients supported by the Agent | Notes |
SAP for Oracle iDataAgent | Oracle databases/ datafiles/ tablespaces | No | Yes | Yes | database objects not assigned to other subclients, unless otherwise configured* | None |
|
Before you back up data, you must define the data that you want to back up, and how this data should be backed up. This is done by creating one or more subclients for the database you are backing up. For the SAP for Oracle iDataAgent, a subclient defines:
Depending on your needs, you can create multiple subclients for one or all of the following:
From the CommCell Console, the SAP for Oracle iDataAgent is designed to back up SAP for Oracle data files (*.dbf) and archived redo log files. After you install an SAP for Oracle iDataAgent, a default subclient is created by the system only after you first configure an SAP for Oracle database instance from the CommCell Console. Since an SAP for Oracle instance references a database, the default subclient includes the entire database associated with that instance. However, you can use the CommCell Console to create user-defined subclients to include only some of the database content by configuring the Subclient Properties (Content) tab. Any content that is not included in the user-defined subclients will remain in the default subclient.
When you configure subclient content, you click the Subclient Properties (Content) tab for the subclient to view the eligible data for inclusion in the subclient content. You then select an option to include one of the following in the subclient content: online database, offline database, one or more online subsets of the database, or archive log files. You can also choose to include selective online full backups for the subclient.
If you opt to include just online subsets in the subclient content, you click the appropriate option and then select the desired table spaces and data files to configure the content for the subclient. Once you do this, the subclient content may be displayed as follows:
In this example, suse11GR1 is the name of the instance, and this instance includes a single database. The database includes six table spaces out of which two of the table spaces have been included in the subclient content. \
When creating user-defined subclients, it is recommended that you create a separate user-defined subclient for the archive log files. Also, make sure to use separate storage policies for data backup, which is set at the subclient level and log backup, which is set at the instance level.
A useful way to distribute subclient content for this iDataAgent is to create separate user-defined sublients for frequently used table spaces and also for log files. For example, if the EXAMPLE and USERS dbspaces shown above undergo frequent changes, you can create a separate subclient for each table space. For example:
Content:
EXAMPLE
Content:
USERS
It is recommended that you create a separate user-defined subclient for the log files on the client. For example:
Content:
(all the archive log files)
Distributing the client data using subclients in this way can help improve backup performance by distributing the workload on the client into logical groupings.
Data protection filtering is not applicable for this agent.
Wildcards and regular expressions are not supported for this agent when defining subclient content.
For more information, see Things to Consider when Creating and Configuring SAP for Oracle Subclients.
Once installed, the agent is configured and is therefore able to manage the data or volumes on the client computer. However, you can change certain aspects of the subclient configuration to manage the data in the manner that best suits your needs.
You can view or change the subclient configuration from the Subclient Properties dialog box. The following information can be configured.
You can enable or disable all operations for this CommCell object and all objects below it. For more information, see Activity Control.
You can specify the location from where the archive logs will be backed up. You can also specify the location from where archive files will be deleted. Either option allows you to create more than one schedule with different log destinations on the same subclient.
See Select Archive Log Destinations for Backup or Deletion for a step-by-step procedure.
You can define the content of the subclient. Most agents include a configure button that displays a dialog where you can add or modify the data included as subclient content. For a step-by-step procedure, see Configure Subclient Content.
You can enable or disable the encryption of data for transmission over unsecure networks and for storage on media. For more information, see Data Encryption.
Several configurable options to efficiently use available resources for transferring data secured by data protection operations are provided in the subclient. This includes the following:
You can view the data paths associated with the primary storage policy copy of the selected storage policy or incremental storage policy. You can also modify the data paths for the subclient including their priority. For additional information, see Configuring Alternate Data Paths for Subclients.
You can add, modify or view Pre/Post processes for the subclient. These are batch files or shell scripts that you can run before or after certain job phases. For more information, see Pre/Post Processes.
You can also change the user account for running Pre/Post processes for data protection operations of agents residing on Windows platforms. These agents include Active Directory, DataArchiver, DB2 on Windows, Exchange, Image Level on Windows, Lotus Notes, NAS, Oracle on Windows, Image Level ProxyHost on Windows, ProxyHost, Quick Recovery Agent, SAP for Oracle on Windows, SharePoint, SQL Server, and Windows File System. For more information, see User Accounts and Passwords.
You can associate the subclient to a storage policy. For more information, see Storage Policies.
You can rename a subclient. For a step-by-step procedure, see Rename a Subclient.
The following pertains to SAP for Oracle on Windows:
You can define an account with permissions to execute Pre/Post commands for the agent's archive, backup, or volume creation jobs.
See Oracle iDataAgents: Other User Accounts in User Accounts and Passwords for more information.
When creating and configuring subclients for the SAP for Oracle iDataAgent, keep in mind the following considerations:
SAP for Oracle Automatic Subclient Updates:
When new objects are added to databases, the system automatically adds these
objects to subclients; you do not have to add them to subclients to ensure that
they get backed up. This section explains how the system determines which subclients
are assigned new objects.
on_accounts | An online database subclient that backs up the entire database. |
on_user | An online subset subclient that backs up the user tablespace. |
on_sys | An online subset subclient that backs up the system tablespace. |
Then assume that the datafile users05.dbf is added to the users tablespace. This datafile will be automatically added to the on_accounts, and on_user subclients, but not to the on_sys subclient. This is because the on_accounts and on_user subclients contain the users tablespace, but the on_sys subclient does not.
|
Subclients must contain the entire contents of a tablespace if you want the system to automatically add a new datafile to the subclient. For example, the on_user subclient must contain the files users01.dbf through users04.dbf if you want the system to automatically add the users05.dbf file. If the on_user subclient only contained the files users01.dbf and users02.dbf, the system will not automatically add users05.dbf to this subclient. |
|
Oracle recommends performing a mandatory Incremental Level 0 backup (i.e., Full backup) after adding new tablespaces and datafiles to the database. If this is not done, the next Incremental backup would fail, because Recovery Manager will not be able to find the parent files for the new tablespaces and datafiles. |
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.