Understanding the discovery of Oracle databases

"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. You should be aware of the process that SnapCenter follows to discover different types and versions of Oracle databases.

For Oracle versions 11g to 12cR1 For Oracle versions 12cR2 to 18c
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.

RAC database: The RAC databases are discovered using the srvctl config command.
Standalone: The standalone 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 based on the entries in the /etc/oratab file and the output of the srvctl config command.
ASM: The ASM instance entry should be available in the /etc/oratab file. ASM: The ASM instance entry need not be 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.
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:

  1. Manually refresh the resources.
  2. Select the RAC One Node database from the resource page, and then click Database Settings.
  3. Configure the database to set the preferred cluster nodes to the RAC node currently hosting the database.
  4. 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.