Converting an Administrator-Managed Database to a Policy-Managed Database and vise versa.
Hi, Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database is dynamic with instances managed automatically based on server pools for effective resource utilization. Admin-Managed database results in instances tied to specific servers. When we create 11g Release 2 RAC database, on database configuration assistant’s 3 of 13 step we must choose Configuration type : Admin-Managed or Polisy-Managed. As you know, we can convert configuration type of Oracle RAC Database after installation.In this post I want share steps of conversion of Admin-Managed database to Policy managed (Case #1) and Policy-Managed to Admin-Managed (Case #2). In my case my test RAC Database (racdb) is created Adminstrator-Managed. Case #1 : Convert Administrator-Managed Database to Policy-Managed Database Checking configuration of racdb database. [oracle@oel62-rac1 /]$ srvctl config database -d racdb Database unique name: racdb Database name: