Solved

add storage policy to subclient automatically

  • 23 April 2021
  • 4 replies
  • 496 views

Userlevel 4
Badge +14

 

Hello, I have deployed a client using a custom package through ansible.

the dba run the backup automatically with database third part tool from the client.

 

 

when the Oracle instance are discovered, 

There is no storage policy associated by default, I have to associated it manually for each instance, or, maybe it is also possible to add a general Storage policy here when I right click on Oracle 

 

I am trying to find a solution to add the storage policy from the client with qcommand, API or someting like that.

 

Thanks !

icon

Best answer by Damian Andre 23 April 2021, 15:47

View original

4 replies

Userlevel 7
Badge +15

Hi @Bloopa 

You can modify subclient properties using command line or REST API, here are the details for Oracle subclient and command line:

Modifying Subclient Properties Using the Commvault Command Line Interface

And similar options for REST API, although non-agent specific general subclient properties:

REST API - POST Subclient Properties

 

As another idea, I had a quick check for subclient policy, but this isn’t supported for Oracle agent. 

 

Thanks,

Stuart

Userlevel 7
Badge +23

I was going to suggest region-based storage as well - but it does not appear to support archive logs / trans logs:

https://documentation.commvault.com/commvault/v11_sp20/article?p=58855_1.htm

or

https://documentation.commvault.com/commvault/v11_sp20/article?p=107568.htm

So maybe not relevant here but is an option for other backup/client types.

Userlevel 4
Badge +14

Hi @Damian Andre,

 

Thanks for your help ! I will read your documentations.

I share what we’ve found with the dba to achieve that :

 

[root@myvma ~]# /opt/commvault/Base64/qinfo instance -c myvma -a Q_ORACLE -i DB01
Name                            :       DB01
Description                     :
Commandline storage policy      :       CV_DEFAULT
Log storage policy              :       CV_DEFAULT


[root@myvma ~]# /opt/commvault/Base64/qmodify instance -c myvma -a Q_ORACLE -i DB01 -csp SP_BRONZE_aws -lsp SP_BRONZE_aws
Modified instance successfully.


[root@myvma ~]# /opt/commvault/Base64/qinfo instance -c myvma -a Q_ORACLE -i DB01
Name                            :       DB01
Description                     :
Commandline storage policy      :       SP_BRONZE_aws
Log storage policy              :       SP_BRONZE_aws

 

Userlevel 7
Badge +23

Hey @Bloopa , hope all is well!

Following up to see if the above advice answered your questions.

Thanks!

Reply