RAC数据库administrator managed管理员管理OR policy managed策略管理

最新推荐文章于 2022-11-16 08:31:56 发布

cjh81378066

最新推荐文章于 2022-11-16 08:31:56 发布

阅读量272

点赞数

administrator managed
Database administrators define on which servers a database resource should run, and place resources manually as needed. This is the management strategy used in previous releases.
管理员管理
数据库管理员定义数据库资源在哪些服务器上运行，并根据需要手动放置资源。这是以前版本中使用的管理策略。

policy managed
Database administrators specify the server pool (excluding generic or free) in which the database resource runs. Oracle Clusterware places the database resource on a server.
策略管理
数据库管理员指定运行数据库资源的服务器池（不包括通用或空闲）。 Oracle Clusterware将数据库资源放在服务器上。

当创建了一个serverpool，再把数据修改使用这个serverpool，这时就是policy managed了
srvctl add serverpool -g ocmserverpool -n "node1,node2"
srvctl modify database -d orcl -g ocmserverpool

不要和 Management policy的概念混淆了
SRVCTL只有database和service才有-y Management policy的选项
Management policy for the database. If AUTOMATIC (the default), the database is automatically restored to its previous running condition (started or stopped) upon restart of the database host computer. If MANUAL, the database is never automatically restarted upon restart of the database host computer.
The management policy for a service controls whether the service starts automatically when the database is restarted. If the management policy for a service is set to AUTOMATIC, then it restarts automatically. If the management policy for a service is set to MANUAL, then it must be started manually.

[root@node1 ~]# srvctl config database -d orcl -a
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATA
Mount point paths:
Services: srv1
Type: RAC
Database is enabled
Database is administrator managed

DB创建的时候，默认使用administrator managed管理员管理