Loading...

Configuring Automatic Instance Discovery for Oracle Databases

You can disable or enable automatic instance discovery. Enabling Automatic instance discovery ensures that newly added Oracle databases are regularly accounted for in backup operations.

By default, the Commvault software creates CommCell instances for Oracle databases under the following conditions:

  • Discovery is initiated every 24 hours. Change this interval by Setting the Automatic Discovery Frequency.
  • When the Communications Service (GxCVD) is restarted (for example after a computer reboot).
  • Instances that are defined in the Oracle oratab file, which is created by Oracle at installation and acts as a database registry file. On Solaris systems, this file is normally located in the /var/opt/oracle directory and on Linux/UNIX systems, it is located in the /etc directory.
  • Instances that are in the NOMOUNT, MOUNT or OPEN state. The software does not discover instances that are shut down.

To prevent the discovery of databases, on the CommServe computer, create the nDisableAutoDiscoverInstancePostInstall additional setting and set the value to 1 before you install the Oracle Agent on your clients. When you set the additional setting to 1, the auto discovery feature is unavailable on any client where you install the Oracle Agent software.

Default Subclient and Storage Policy Creation

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.

Procedure

  1. From the CommCell Browser, go to Client Computers > client.
  2. Right-click Oracle, and then click Properties.

    The Oracle Properties dialog box appears.

  3. On the General tab, set options for the instance:
    1. Determine the automatic instance discovery options. These options apply to both single instance Oracle databases and Oracle RAC databases.
      • To disable automatic instance discovery, clear the Enable Automatic Instance Discovery check box.
      • To enable automatic instance discovery, check the Enable Automatic Instance Discovery check box.
    2. Optional: Configure the default data and log storage policies for all discovered instances.

      Policy

      Option

      Data Storage Policy

      From the Data Storage Policy list, select a policy

      Log Storage Policy

      From the Log Storage Policy list, select a policy

  4. Set the default data storage policy for the instance default subclient when it has not been set.

    For information, see Setting the Data Storage Policy on the Default Subclient after Discovering Oracle Instances.

  5. Set the default command line backup and log backup storage policies when they have not been set.

    For information, see Setting the Log Backup and Command Line Backup Storage Policies after Discovering Oracle Instances.

  6. Click OK.

Related Topics

Last modified: 8/13/2019 8:57:09 PM