Oracle Cloud Infrastructure Documentation

Add Managed Databases to a Database Group

You can add Managed Databases to a Database Group to monitor them and preform a single operation on all the databases in the group.

The option to add a Managed Database to a Database Group is available on the Managed database details and Database group details pages. For information on the Managed database details page, see Monitor and Manage a Specific Managed Database.

To add Managed Databases to a Database Group on the Database group details page:

  1. Go to the Database groups page.
  2. Click the name of the Database Group and go to the Database group details page.
  3. Click Add managed database in the Managed databases section.
  4. In the Add managed database panel, select the compartment in which the Managed Databases reside, select the Managed Databases, and click Add.

    If you want to add Managed Databases in other compartments to the Database Group, then perform steps 3 and 4 again.

    Note

    • A Database Group can have Managed Databases from a maximum of five compartments.
    • A Database Group can have a maximum of 25 Managed Databases from a single compartment.
    • A Managed Database can be added to a maximum of five Database Groups.

After you add the Managed Databases to a Database Group, you can perform the following tasks on the Database group details page:

  • Click Fleet summary to monitor all the Managed Databases in the Database Group on the Oracle Database fleet summary page. For information, see Monitor the Health of Your Oracle Database Fleet.
  • Click Edit description to add or edit the Database Group description.
  • Click Move resource to move the Database Group to another compartment.
  • Click Add tags to add tags to the Database Group. For information, see Working with Resource Tags.
  • Click Delete to delete the Database Group.
    Note

    You cannot delete a Database Group with associated Managed Databases, and to do so you must first remove the databases from the group.
  • Monitor the total number of open database alarms and the number of alarms by severity, in the Database group details section. Note that the alarms are only displayed in Database Management if the OCID of the database is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For information, see Monitor Alarms for Managed Databases.
  • Click the Tags tab to add, view, edit, or remove tags. For information, see Working with Resource Tags.
  • Click Jobs on the left pane under Resources to create a job for the Database Group and monitor job runs and executions. For information on jobs, see Create and Monitor Jobs.
    Note

    If a job is created for a Database Group that contains Autonomous Databases along with other External Databases or Oracle Cloud Databases, then the job is not executed for the Autonomous Database. In this case, an error is not displayed. If a job is created for a Database Group that only contains Autonomous Databases, then an error is displayed and the job is not created.