Converting 11gR2 "Administrator" managed database to "Policy" managed and vice versa (文檔 ID 1486772.

In this Document

Goal

Fix

References

Applies to: Oracle Server - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Goal

This document describes how to convert an administrator managed database to policy managed database and vice versa.

Fix

Converting an Administrator managed database to a Policy managed Database

1.Check the current configuration of all services and the database

  srvctl config database -d db_unique_name
  srvctl config service -d db_unique_name

 Before converting the instance name shows as:

  Eg:
    $ ps -eaf|grep pmon|grep orcl
      oracle   16450     1  0 Aug31 ?        00:00:02 ora_pmon_orcl1

2.Create a server pool for the policy-managed database (you must have GI Administrator privileges to do this), as follows:

   srvctl add srvpool -g server_pool -l 0 -u n(In the preceding command,n is the number of servers you want in the server pool.)

3. Modify the database to be in the new server pool, as follows:

    srvctl modify database -d db_unique_name -g server_pool

4. After restart, check the status of the database to confirm that it is now policy managed by repeating the commands in step 1.
   
  After converting the instance name show as:

  Eg:
    $ ps -eaf|grep pmon|grep orcl
      oracle   14462     1  0 11:14 ?        00:00:00 ora_pmon_orcl_1

  Note: After convering the database to policy-managed,instance name will be db_unique_name_# (notice the additional underscore (_) before the number sign (#) character).

Converting Policy managed databases to administrtor managed Database

You cannot directly convert a policy-managed database to an administrator-managed database. Instead, you need to remove the policy-managed configuration and then register the same database as an administrator managed databases.

1. Remove the database and services

   srvctl remove database -d <dbname>
   srvctl remove service -d <dbname> -s <service name>

2. Register the same database as an administrator-managed databases

   srvctl add database -d <dbname> -o <RDBMS_HOME>
   srvctl add instance -d <dbname> -i <instance_name> -n <nodename>
   srvctl add service -d <db_unique_name> -s <service_name> -u -r <new_pref_inst> | -a <new_avail_inst>

Referenceshttp://docs.oracle.com/cd/E11882_01/rac.112/e16795/admin.htm#CACJJGFE
NOTE:1481647.1 - 11gR2 Database Services for "Policy" and "Administrator" Managed Databases
NOTE:1484800.1 - Can pre 11.2 databases coexist with 11gR2 DB policy managed databases in GI (Grid Infrastructure)?
NOTE:1473998.1 - 11gR2 DBCA Instance Management Option Greyed Out for Policy Managed Database