In this Document

  Purpose
 

_afrLoop=1459311711568804&id=1481647.1&displayIndex=6&_afrWindowMode=0&_adf.ctrl-state=foyvm6hmv_102#REF_TEXT">Details

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 and later

Information in this document applies to any platform.

Purpose

This document describes 11gR2 databases services for Policy and Administrator Managed Databases. Pre-11gR2 has only Administrator Managed Databases

Details

Services for Policy Managed Database:

Service for a policy-managed databases are defined to a server pool where the database is running, the service can be either UNIFORM or SINGLETON:

-UNIFORM (running on all instances in the pool)

-SINGLETON (running on only one instance in the pool)

For singleton services, RAC chooses on which instance the service is active. If that instance fails, the service fails over to another instance in the same pool.

Note: A single RAC database can run on multiple server pools.

Eg:



To create a SINGLETON service called BACKUP_JOB using server pool SP1 and a UNIFORM service called ERP using server pool SP2



$srvctl add service -d RAC_DB -s BACKUP_JOB -g SP1 -c singleton

$srvctl add service -d RAC_DB -s ERP -g SP2 -c UNIFORM

Services for Administrator Managed database:

Service for administrator-managed databases is similar as what's in pre-11gR2, it has PREFERRED instances and optionally AVAILABLE instances to control on which instances the service is active:



-PREFERRED (running on these instances normally )

-AVAILABLE (running on these instances when PREFERRED fails)

Eg:



To create a service called PAYROLL with preferred instance RAC_DB2 and available instance RAC_DB1



$srvctl add service -d RAC_DB -s PAYROLL -r RAC_DB2 -a RAC_DB1

最新文章

  1. 常用RGB色值表
  2. Koala-Sass编译
  3. SPOJ REPEATS 后缀数组
  4. rbenv Your user account isn't allowed to install to the system Rubygems
  5. 知乎上有一个问题“在mfc框架中，有上面方法能直接将opencv2.0库中的Mat格式图片传递到Picture Control”中显示？
  6. CentOS 安装ftp
  7. SQL优化 csdn
  8. logback.xml_appender配置
  9. 【原】lua的table深拷贝
  10. 【POJ】3283 Card Hands
  11. CF 295E Yaroslav and Points（Splay）
  12. HID Keyboard & Mouse descriptor.
  13. C#中使用ref 和 out 的一点认识
  14. sql语句按月份统计查询
  15. jquery换肤
  16. 自兴人工智能------------python入门基础（2）列表和元祖
  17. InkImageDataSetGenerator-开源一个可用于机器学习的书写轨迹图片生成的小工具
  18. PTA_Have fun with numbers(C++)
  19. PostgreSQL函数(存储过程)----笔记
  20. 2018蓝桥杯 省赛B题(明码)

热门文章

  1. Your configuration specifies to merge with the ref 'refs/heads/v.autoCheckProduct.20190325' from the remote, but no such ref was fetched.
  2. 2-bitmap
  3. HTML基础练习
  4. java.util.Arrays
  5. spring整合redis客户端及缓存接口设计
  6. 学习廖雪峰的Python教程之数据类型
  7. VR: AR和VR演进哲学
  8. 【Python基础】while循环语句
  9. vue 上滑加载更多
  10. selenium使用Xpath+CSS+JavaScript+jQuery的定位方法（治疗selenium各种定位不到，点击不了的并发症）