Configuring the Recovery Appliance Using the Command Line

You can configure the Recovery Appliance using PL/SQL statements on the command line. You must create an SBT library, one or more attribute sets, and the SBT job template.

On the Recovery Appliance where the Commvault software is installed, create the following additional setting. This additional setting is needed to make sure the system can obtain the JOBID from the CommServe computer for backup or restore operations in the Recovery Appliance.

To the CommServe computer, add the sSKIPSINGLEJOBID additional setting as shown in the following table. For instructions about adding an additional setting from the CommCell Console, see Adding an Additional Setting from the CommCell Console.

On the Recovery Appliance, the procedures to set up a tape backup must be executed as the RASYS user. Define the attribute set parameters specific to the Commvault configuration. These parameters must be supplied when creating the SBT attribute set. The two Commvault parameters which must be defined are the following:

• CVOraSid - Set this to the SID of the target database.

• CVInstanceName - Set this to the name of the instance you created, which is usually “Instance001”.

Do not specify the CvClientName parameter, since this results in the Recovery Appliance using only one node during backup and restore operations.

The following describes an example Recovery Appliance configuration with two physical nodes, and the commands to set up that configuration:

• To set up a single instance database named xman1db, add an instance for each of the RAC nodes in the Recovery Appliance. For example, if the nodes are isrx3pdb01 and isrx3pdb02, the first “Instance Physical Client” added is isrx3pdb01, which is set up with the SID of the target database xman1db. Specify the path to the ORACLE home directory on isrx3pdb01, but leave the connect string empty. Repeat the steps for isrx3pdb02. After you have added both instances, both physical clients (isrx3pdb01 and isrx3pdb02) should be listed with the instance name of xman1db.

• The following shows the commands to set up the example configuration:

  BEGIN 
      DBMS_RA.CREATE_SBT_LIBRARY( 
        LIB_NAME => 'COMMVAULT_SBT', 
        DRIVES => 4, 
        RESTORE_DRIVES => 1, 
        PARMS => 
        SBT_LIBRARY=Client Agent Install Path/Base/libobk.so'); 
      DBMS_RA.CREATE_SBT_ATTRIBUTE_SET( 
        ATTRIBUTE_SET_NAME => 'DRIVE_COUNT_1', 
        LIB_NAME => 'COMMVAULT_SBT', 
        STREAMS => 1, 
        PARMS => 'ENV=(CVOraSid=xman1db,CvInstanceName=Instance001)'); 
      DBMS_RA.CREATE_SBT_ATTRIBUTE_SET( 
        ATTRIBUTE_SET_NAME => 'DRIVE_COUNT_2', 
        LIB_NAME => 'COMMVAULT_SBT', 
        STREAMS => 2, 
        PARMS => 'ENV=(CVOraSid=xman1db,CvInstanceName=Instance001)'); 
      DBMS_RA.CREATE_SBT_ATTRIBUTE_SET( 
        ATTRIBUTE_SET_NAME => 'DRIVE_COUNT_3', 
        LIB_NAME => 'COMMVAULT_SBT', 
        STREAMS => 3, 
        PARMS => 'ENV=(CVOraSid=xman1db,CvInstanceName=Instance001)'); 
      DBMS_RA.CREATE_SBT_ATTRIBUTE_SET( 
        ATTRIBUTE_SET_NAME => 'DRIVE_COUNT_4', 
        LIB_NAME => 'COMMVAULT_SBT', 
        STREAMS => 4, 
        PARMS => 'ENV=(CVOraSid=xman1db,CvInstanceName=Instance001)'); 
      DBMS_RA.CREATE_SBT_JOB_TEMPLATE( 
        TEMPLATE_NAME => 'xman1', 
        DB_UNIQUE_NAME => 'xman1db', 
        ATTRIBUTE_SET_NAME => 'DRIVE_COUNT_4', 
        BACKUP_TYPE => 'FULL,ARCH', 
        FULL_TEMPLATE_NAME => 'xman1', 
        PRIORITY => 100, 
        COPIES => 1); 
  END;

You can queue jobs manually using the command line. The following example shows a job being queued manually:

BEGIN 
    DBMS_RA_QUEUE_SBT_BACKUP_TASK ( 
    TEMPLATE_NAME => 'xman1'); 
END;