Use XML to create SAP for Oracle subclients. Run the operation from the command line, or automate configuration by combining command line operations in a script.
The XML parameters can be included in the XML file, or specified on the command line when they frequently change. For more information on command line parameters and XML elements, see Command Line - Syntax.
Procedure
-
On the SAP for Oracle Agent host, run the qlogin command to log on to the CommServe computer.
-
Download the CreateSubclient.xml file to the computer where you will run the command.
-
Open the CreateSubclient.xml file, add your specific parameters and save the file.
For information on supported subclient XML parameters, see Available XML Parameters for SAP for Oracle Subclient Configuration.
-
On the command line, go to Software_Installation_Directory/Base and type the following command.
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'client_name' -subClientEntity/instanceName 'Instance_Name' -subClientEntity/Subclient name 'subclient_name'
Examples
Creating a Default Subclient
The following parameters are set when you create a subclient.
|
Parameter |
Value |
|---|---|
|
sapBackupDevice |
RMAN_UTIL |
|
sapBackupMode |
ONLINE |
|
sapArchiveDelete |
true |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subclientName 'test_cmd_sub1' -dataBackupStoragePolicy/storagePolicyName 'test_sap'
Creating a Subclient by Specifying the Device Type as 'UTIL_FILE'
To create a subclient with the device type as util_file, set the following parameters
|
Parameter |
Value |
|---|---|
|
sapBackupDevice |
'UTIL_FILE' |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub2' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE'
Creating a Subclient by Specifying the Device Type as'UTIL_FILE_ONLINE'
To create a subclient with the device type as util_file_online, set the following parameters
|
Parameter |
Value |
|---|---|
|
sapBackupDevice |
'UTIL_FILE_ONLINE' |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub2' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE'
Creating a Subclient with the Partial DB Option
To create a partial database subclient, set the following parameters
|
Parameter |
Value |
|---|---|
|
sapBackupMode |
'ONLINE_SUBSET_DB' |
|
contentOperationType |
'ADD' |
|
content/sapForOracleDBContent |
database content |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub2' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE' -sapData 'true' -sapBackupMode 'ONLINE_SUBSET_DB' -contentOperationType 'ADD' -content/sapForOracleDBContent/sapTableSpace 'USERS' -content/sapForOracleDBContent/sapdataFile '/database/Oracle/app/oracer/oradata/oratest/users01.dbf'
Creating a Data Only Subclient
qoperation execute –af create_subclient_template.xml -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub2' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE' -sapBackupMode 'ONLINE_DB' -sapData 'true' -sapBackupArchiveLog 'false'
Creating a Log Only Subclient
To create a subclient with backup archive log and disable delete archive log options, set the following parameters
|
Parameter |
Value |
|---|---|
|
sapBackupArchiveLog |
'true' |
|
sapArchiveDelete |
'false' |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub5' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE' -sapBackupMode 'ONLINE_DB' -sapData 'false' -sapBackupArchiveLog 'true'
Creating a Subclient with the Backup Archive Log and Archive Log Secondary Copy Options
To create a log only subclient, set the following parameters
|
Parameter |
Value |
|---|---|
|
sapBackupArchiveLog |
'true' |
|
sapData |
'false' |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub7' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE' -sapData 'false' -sapBackupArchiveLog 'true' -sapArchiveDelete 'false' -sapArchiveLogSecondCopy 'true'
Creating a Selective Online Full Subclient
To create a selective online full Subclient, set the following parameters:
|
Parameter |
Value |
|---|---|
|
data |
'true' |
|
selectiveOnlineFull |
'true' |
|
dataBackupStoragePolicy/storagePolicyName |
Storage Policy Name (in this example, 'data_sp') |
qoperation execute –af create_subclient_template.xml -subClientEntity/appName 'SAP for Oracle' -subClientEntity/clientName 'saporavm2' -subClientEntity/instanceName 'oratest' -subClientEntity/subclientName 'test_cmd_sub8' -dataBackupStoragePolicy/storagePolicyName 'test_sap' -sapBackupDevice 'UTIL_FILE_ONLINE' -sapSelectiveOnlineFull 'true' -sapArchiveDelete 'false'