How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle

 

Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use of resources. An Admin-Managed database has instances connected to specific servers.

The following figure shows the differences in behavior.

Some benefits of the Policy-Managed configuration:

  • Provides distribution according to demand.
  • Manages business requirements effectively.
  • Scales just in time.
  • Maximizes data center efficiency.

By default, there are two server pools, GENERIC and FREE. We can display existing pools as follows.

Features of server pools :

 min : (-l)

The minimum number of servers that must be protected in the server pool.

max : (-u)

Maximum number of servers allowed in server pool.

imp : (-i)

The server pool with an imp value is filled to the Min values first. imp determines the order of precedence.

By following these steps, you can convert a database that is created as Admin-Managed to a Policy-Managed database.

First, let’s look at our current configuration.

Let’s create a new pool. The min and max values for the new pool are set to 2.

When we view existing pools, the pool we just created is visible.

Now, we can convert our database.

The database configuration will now appear as policy managed.

Now our database is policy managed. Our database will run when there is an appropriate server for the testpool we created above. We can check the status of the server repositories as follows.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *