If you want to create a subclient for Log backups on multiple instances or clients instead of navigating to each client and creating the subclients, then, use this procedure.
Procedure
-
From the command prompt, logon to the CommServe using the qlogin command.
Example: To log on to CommServe commserve.commcell.com with user name user1:
qlogin -cs commserve.commcell.com -u user1
Password:
-
Run the command to create a subclient.
D:\>qcreate sub client -cs commserve.commcell.com -c client_name -a Q_ORACLE -i auto -n "NEWlog" -sp "data_storage_policy" -f "auto"
-
Run the command to disable Data option.
D:\>qoperation execscript -sn SetSubClientProperty.sql -si 'c=client' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Oracle Backup Mode' -si '1' -si '2'
-
Run the command to disable Backup Control File option.
D:\>qoperation execscript -sn SetSubClientProperty.sql -si 'c=client' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Backup Control Files' -si '0' -si '2'
-
Run the command to disable Delete Archive log option.
D:\>qoperation execscript -sn SetSubClientProperty.sql -si 'c=client' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Archive Log Deleting' -si '0' -si '2'
For more information about the parameters and arguments, see qscript.