RAC資料庫administrator managed管理員管理OR policy managed策略管理

lusklusklusk發表於2017-08-25
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管理員管理

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30126024/viewspace-2144129/,如需轉載,請註明出處,否則將追究法律責任。

相關文章