Oracle Cloud Infrastructure Documentation

Policies for Oracle Database

Shows how to allow Disaster Recovery (DR) to manage DR for Oracle Base Database, Oracle Exadata Database Service on Dedicated Infrastructure, Oracle Exadata Database Service on Exascale Infrastructure, Oracle Exadata Database Service on Cloud@Customer databases that are part of the application stack.

Allow group group_name to manage database-family in compartment compartment_name

A more restrictive policy that allows DR to only perform switchover and failover operations on databases is similar to the following:

Allow group group_name to update databases in compartment compartment_name

For additional details about Identity and Access Management (IAM) policies for Oracle Exadata Database Service and Oracle Base Database Service, refer Details for the Database Service.

For Databases
Allow group group_name to update databases in compartment compartment_name
Allow group group_name to read db-homes in compartment compartment_name
Allow group group_name to update data-guard-association in compartment
      compartment_name

For cloud-vmclusters (ExaCS)

Allow group group_name to update cloud-vmclusters in compartment compartment_name

For vmclusters (ExaCC)

Allow group group_name to update vmclusters in compartment compartment_name

For exadb-vm-clusters (ExaScale)

Allow group group_name to update exadb-vm-clusters in compartment
    compartment_name