Skip to main content
SnapCenter Software 6.0

How SnapCenter discovers Oracle databases

Contributors netapp-jsnyder thrisun

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.

The following sections describe the process that SnapCenter uses to discover different types and versions of Oracle databases.

For Oracle versions 11g to 12cR1

RAC database

The RAC databases are discovered only on the basis of /etc/oratab`entries. You should have the database entries in the /etc/oratab file.

Standalone

The standalone databases are discovered only on the basis of /etc/oratab entries.

ASM

The ASM instance entry should be available in the /etc/oratab file.

RAC One Node

The RAC One Node databases are discovered only on the basis of /etc/oratab entries. The databases should be either in nomount, mount, or open state. You should have the database entries in the /etc/oratab file.

The RAC One Node database status will be marked as renamed or deleted if the database is already discovered and backups are associated with the database.

You should perform the following steps if the database is relocated:

  1. Manually add the relocated database entry in the /etc/oratab file on the failed-over RAC node.

  2. Manually refresh the resources.

  3. Select the RAC One Node database from the resource page, and then click Database Settings.

  4. Configure the database to set the preferred cluster nodes to the RAC node currently hosting the database.

  5. Perform the SnapCenter operations.

  6. If you have relocated a database from one node to another node and if the oratab entry in the earlier node is not deleted, manually delete the oratab entry to avoid the same database being displayed twice.

For Oracle versions 12cR2 to 18c

RAC database

The RAC databases are discovered using the srvctl config command. You should have the database entries in the /etc/oratab file.

Standalone

The standalone databases are discovered based on the entries in the /etc/oratab file and the output of the srvctl config command.

ASM

The ASM instance entry need not be in the /etc/oratab file.

RAC One Node

The RAC One Node databases are discovered using the srvctl config command only. The databases should be either in nomount, mount, or open state. The RAC One Node database status will be marked as renamed or deleted if the database is already discovered and backups are associated with the database.

You should perform the following steps if the database is relocated: . Manually refresh the resources. . Select the RAC One Node database from the resource page, and then click Database Settings. . Configure the database to set the preferred cluster nodes to the RAC node currently hosting the database. . Perform the SnapCenter operations.

Note If there are any Oracle 12cR2 and 18c database entries in the /etc/oratab file and the same database is registered with the srvctl config command, SnapCenter will eliminate the duplicate database entries. If there are stale database entries, the database will be discovered but the database will be unreachable and the status will be offline.