How To Move a Database From One Server Pool To Another Server Pool

(Doc ID 1620171.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

How to move a policy managed database from one serverpool to another serverpool?

Here is an example with 4 nodes (rac1, rac2, rac3, rac4) cluster that is policy managed and have two serverpools set up, each with two nodes. A database currently runs in serverpool1 and needs to be moved to serverpool2. 

> srvctl config database -d RACDB -a
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: serverpool1
Database instances:
Disk Groups: DATA,FLASH
Mount point paths:
Services: RACDB_S,RACDB_U
Type: RAC
Database is enabled
Database is policy managed                             <<<<<<<<<<<<<<<


> srvctl status database -d RACDB
Instance RACDB_1 is running on node rac1
Instance RACDB_2 is running on node rac2


> srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Candidate server names:
Server pool name: serverpool1
Importance: 0, Min: 1, Max: 3
Candidate server names: rac1,rac2
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms