Determining whether Oracle databases are available for backup

Resources are Oracle databases on the host that are maintained by SnapCenter. You can add these databases to resource groups to perform data protection operations after you discover the databases that are available.

Before you begin

About this task

The databases should be at least in the mounted state or above for the discovery of the databases to be successful. In an Oracle Real Application Clusters (RAC) environment, the RAC database instance in the host where the discovery is performed should be at least in the mounted state or above for the discovery of the database instance to be successful. Only the databases that are discovered successfully can be added to resource groups.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.
  2. In the Resources page, select Database from the View list.
    Click and select the host name and the database type to filter the resources. You can then click to close the filter pane.
  3. Click Refresh Resources.
    The newly added or deleted Oracle databases are updated to the SnapCenter Server inventory.

    If the database details are not included in /etc/oratab, the databases will not be discovered. You can search for SCO-LOG-1073 and SCO-LOG-1074 in the spl_jobid.log file of the discover operation located at /var/opt/snapcenter/spl/logs to see the number of databases that are discovered. If any database is not discovered, you must enter the database details in /etc/oratab.

Result

The databases are displayed along with information such as database type, host or cluster name, associated resource groups and policies, and status.
Note: If you have enabled an Oracle database authentication, a red color lock icon is shown in the resources view. You must configure database Run As credentials to be able to protect the database or add it to the resource group to perform data protection operations.