1  实验

1.1   查看数据库配置信息

[[email protected]~]$ srvctl config database -db cndba
Database unique name: cndba
Database name: cndba
Oracle home: /u01/app/oracle/12.2.0/db_1
Oracle user: oracle
Spfile: +DATA/CNDBA/PARAMETERFILE/spfile.276.951664119
Password file: +DATA/CNDBA/PASSWORD/pwdcndba.256.951662701
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: cndba1,cndba2
Configured nodes: rac1,rac2
Database is administrator managed

[[email protected]~]$ srvctl config service -db cndba
[[email protected]~]$

1.2   创建server pool用于policy-managed database

http://www.cndba.cn/Expect-le/article/2138http://www.cndba.cn/Expect-le/article/2138

[[email protected]~]$ srvctl add srvpool -serverpool cndba_pool -min 0 -max 2

http://www.cndba.cn/Expect-le/article/2138

1.3   关闭数据库

[[email protected]~]$ srvctl stop database -db cndba

http://www.cndba.cn/Expect-le/article/2138

1.4   修改数据库到新的server pool中

Root用户执行

[[email protected]~]# /u01/app/12.2.0/grid/bin/srvctl modify database -db cndba -serverpool cndba_pool

http://www.cndba.cn/Expect-le/article/2138http://www.cndba.cn/Expect-le/article/2138

1.5   再查看数据库配置

[[email protected]~]$ srvctl config database -db cndba
Database unique name: cndba
Database name: cndba
Oracle home: /u01/app/oracle/12.2.0/db_1
Oracle user: oracle
Spfile: +DATA/CNDBA/PARAMETERFILE/spfile.276.951664119
Password file: +DATA/CNDBA/PASSWORD/pwdcndba.256.951662701
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: cndba_pool
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances:
Configured nodes:
Database is policy managed

版权声明：本文为博主原创文章，未经博主允许不得转载。

Policy-Managed Administrator-Managed