> Expert > Backup and Restore Agents > Databases > Oracle > Oracle Backup Administrator Guide > Configuration for Oracle > Instances for Oracle

Manually Adding CommCell Instances for Oracle Databases

Manually add an Oracle instance in the CommCell when you need to manage a database before the automatic instance discovery interval completes or when you add an Oracle container database.

By default, when you discover or create an Oracle instance, the Commvault software automatically creates a default data subclient and a default archive log subclient.

Best Practice: Do not modify the default archive log subclient properties.

If you don't want the software to create the default archive log subclient, you can disable this feature by setting an additional setting. For more information, see Disabling Automatic Archive Log Subclient Creation.You can configure the data and log storage policies for the agent when you manually discover or automatically discover instances. The Commvault software assigns these storage policies to all the instances and default subclients that you discover.

The Commvault software assigns the storage policy to the discovered instance and default subclients by analyzing the following configuration information:

  • The storage policies configured for the discovered instances in the Oracle agent properties.

    The data storage policy is assigned to the discovered instance for command line data backup and to the Default subclient for data backups. The log storage policy is assigned to the discovered instance and to the Default archive log subclient for log backups.

  • The storage policies that are configured for a previously discovered Oracle instance.

  • The storage policy for the Default subclient of the DefaultBackupSet on the File System Agent agent.

  • If the client computer is associated with a Plan from the Command Center, the Plan is assigned as the storage policy for data and log backups on the discovered instance and the default subclients.

  • If there is no assigned storage policy in any of the above configuration information, you must add the storage policy to the Default subclient manually.

When you add or discover an Oracle instance, the software sets the default block size to 1MB. You can change the Oracle block size. For more information, see Configuring the Oracle Block Size.

Procedure

  1. From the CommCell Browser, go to Client Computers > client.

  2. Right-click Oracle, point to All Tasks, and then click New Instance (ORACLE SID).

    The Creating New Instance dialog box appears.

  3. On the General tab:

    1. In the Instance (ORACLE SID) box, enter the instance name.

    2. In the User Account box, enter the login credentials to access the Oracle client.

    3. In the ORACLE HOME box, enter the Oracle application install path.

    4. In the Storage Policy used for the data of default subclient list, select a storage policy name.

  4. On the Details tab, determine how you want to connect to Oracle.

    Option

    Configuration

    Oracle Wallet Auto Login

    You can use this option when you have configured the Secure External Password Store (Oracle Wallet) feature that stores password credentials, and you want to use those credentials during the data protection operations. For more information on the Secure External Password Store, go to the Oracle documentation website, Secure External Password Store.

    1. Select the Oracle Wallet Auto Login check box.

    2. Enter the Oracle Service Name in the Connect String third box.

      Note: If you provide the user name and password, the software ignores the Oracle Wallet feature.

    Use the Oracle Connect String

    Enter the Connect String to connect to the Oracle database.

    1. Enter the database user name in the Connect String first box.

    2. Enter the database user password in the Connect String second box.

    3. In the Confirm Password dialog box, re-enter the password, and click OK.

    4. Enter the Oracle service name in the Connect String third box.

      For example, in the following:

      sysdba/<password>@orcl

      sysdba is the database user id

      <password> is the database user id password

      orcl is the Oracle service name

    Use the Oracle Catalog Connect String

    Select the Use Connect String check box and in the Connect String box enter the Oracle connect string credentials.

    Note: If you want to use an account other than 'sys', you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege to the user account.

    Enter the Catalog Connect String to connect to the Oracle database.

    1. Enter the database user name in the Connect String first box.

    2. Enter the database user password in the Connect String second box.

    3. In the Confirm Password dialog box, re-enter the password, and click OK.

    4. Enter the Oracle service name in the Connect String third box.

      For example, in the following:

      sysdba/<password>@orcl

      sysdba is the database user id

      <password> is the database user id password

      orcl is the Oracle service name

  5. In the Automatic Backup of Control Files list, select Configure On to include the control file in all backups for this instance.

    Note: You can override this option to have the feature on the subclient level. For more information, see Enabling Automatic Backups of the Oracle Control File at the Subclient Level.

  6. Select the Disable Backup Aging check box to disable the Oracle CROSSCHECK and, then click OK to close the warning message.

  7. On the Storage Device tab, enter storage policy information:

    • In the Storage Policy used for user command backup of data list, select a storage policy.

    • In the Storage Policy used for all Archive Log backups list, select a storage policy name.

  8. Click OK to close the Creating New Instance dialog box.

  9. On the Oracle database host, edit the oratab file and add an entry for the added instance.

Loading...