Skip to main content

How can we help you?

Druva Documentation

Manage Oracle databases

Phoenix Editions: File:/tick.png Business File:/cross.png Enterprise File:/tick.png Elite

 

Add a database

You can add database instances manually on the Databases page. 

Druva Phoenix may not discover database instances running on an Oracle server host in the following cases:

  • PhoenixOracle service is not running.
  • The Oracle database instance is offline.
  • The database name is not available in the DB registry (etc/oratab) and the database instance is offline.
  • Database credentials are incorrect or missing.

Procedure 

  1. On the Databases page, click Add Database. The Add Database dialog opens.
    AddDatabaseSBTNew.PNG
  2. In the Database Details section, provide the following details:
    • Database SID: Enter the Oracle system identifier of the database instance that you want to back up. 
    • Oracle Server: Select the registered Oracle server host that is running the database instance.
    • Oracle Home: Enter the Oracle directory that contains Oracle database software and the configuration files.
  3. In the Database Authentication section, provide the following details:
    • Authentication Type: Specify the type of method used to authenticate Oracle databases. Druva Phoenix supports the following two types:
      • Oracle authentication: This type requires a user to provide a valid username and password to connect to the database. The connection is denied on providing an incorrect username and password.
        • Database Credentials: This field is displayed only if the Oracle type is selected. Select the credential label from the drop-down list. Druva Phoenix maintains the credentials securely in its Credential Store. You can assign credentials to one or more servers seamlessly without having to input the credentials manually each time. For more information, see Credentials store.
          In addition, you can also define credentials to connect to the database. For more information, see Add credentials.
      • OS authentication: In this authentication type, Druva Phoenix will automatically detect the OS-authenticated user and uses the user details to connect to the database. Druva Phoenix does not store the OS-user authentication details. 
      • TNS Alias: Specify the Transparent Network Substrate (TNS) entry that Oracle listener uses to connect to the database. The TNS alias is specified in the tnsnames.ora file located at $ORACLE_HOME/network/admin.
  4. Click Test Connection to validate the Oracle credentials provided for the database. If the test connection is successful, you can save credentials and use them to connect to the database for further operations.
  5. In the RMAN Recovery Catalog section, enable the Enable Recovery Catalog option to connect to the RMAN through the RMAN Recovery Catalog.
    • In the Catalog Credentials list, select the Catalog credential label. In addition, you can also define credentials to connect to the RMAN Recovery Catalog using New Credentials.
    • In the TNS Alias box, specify the Transparent Network Substrate (TNS) entry that Oracle listener uses to connect to the Catalog. The TNS alias is specified in the tnsnames.ora file located at $ORACLE_HOME/network/admin.

      Note: You must specify the TNS alias if the environment variable, Oracle_SID, is not set on your Oracle server.

  6. Click Save to add the database details.

The database is added successfully and listed on the Databases page.

Authenticate a database 

Druva Phoenix requires you to configure Oracle databases to authorize users and entities to connect to the databases. Druva Phoenix enables you to authenticate users based on the following two types:

  • OS authentication: In this authentication type, Druva Phoenix automatically detects the OS-authenticated users and uses the user details to connect to the databases.

    Note: Druva Phoenix does not store the OS-user authentication details.

  • Oracle authentication: In this authentication type, you must provide a valid username and password to connect to the database. The connection is denied on providing an incorrect username and password. Druva Phoenix maintains the credentials securely in its Credential Store. You can assign credentials to one or more servers seamlessly without having to input the credentials manually each time. For more information, see Credentials store.
    In addition, you can also define credentials to connect to the database. For more information, see Add credentials.  

Add credentials

You can define credentials and assign them to one or more servers seamlessly without having to input the credentials manually each time.

Procedure

  1. On the Database Authentication page, click New Credentials.
  2. On the Add Credentials page, provide the following details:
    • Label: Enter a label to uniquely identify a credential that you want to store with Druva Phoenix.
    • Username: Enter the username of the credential you want to store with Druva Phoenix. If your account uses a domain, enter the username as domain\username. For example,  DruvaCorp\JohnDoe.
    • Password: Enter the password of the credential you want to store with Druva Phoenix.
    • Confirm Password: Re-enter the password of the credential you want to store with Druva Phoenix.
  3. Click Save.

Druva Phoenix lists all the credentials on the Credentials Store page. To view the credentials, select an organization, click Settings_icon.PNG > Credentials Store on the top menu.

Update database parameters

When you trigger discovery, the Phoenix agent fetches the database parameters and lists the details on the Databases page. Druva Phoenix lets you update values of the database parameters after the databases are discovered on the Databases page.

Note: You cannot change the name of the database and Oracle server.

Procedure

  1. Click the All Databases tab. The Databases page opens.
  2. In the Database Name column, select the database for which you want to update the setting values, and click the more More icon.png icon and then click Database Parameters.
  3. On the Database Parameters dialog, update the required settings:
    • Oracle Home: The Oracle directory that contains Oracle database software and the configuration files.
    • Authentication Type: The type of method used to authenticate Oracle databases, Oracle or OS, respectively. For more information about the authentication types, see Authenticate a database.
    • TNS Alias: The TNS entry that the Oracle listener used to connect to the database.

Change backup policy

You can reconfigure a database for backup by changing its backup policy.

Procedure

  1. Click the Configured Databases tab. 
  2. On the Configured Databases page, click the database for which you want to assign a different backup policy.
  3. On the Configured database details page, click the more icon and click Change Backup Policy.
    SBTChangeBackupPolicy.png
  4. On the Change Backup Policy dialog, select the required backup policy from the drop-down list.
  5. Click Save.

Druva Phoenix applies backup settings of the selected backup policy to all the existing snapshots.