How To Move a Database From One Server Pool To Another Server Pool
(Doc ID 1620171.1)
Last updated on DECEMBER 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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/22.214.171.124/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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document