How To Move a Database From One Server Pool To Another Server Pool
Last updated on OCTOBER 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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/18.104.22.168/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
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