11gR2 Database Services for " policy" " administrator" Managed Databases (document ID 1481647.1)

Source: Internet
Author: User

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 have only Administrator Managed Databases

Details


Services for Policy Managed Database:

Service for a policy-managed databases was defined to a server pool where the database was running, the service can be eith Er 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 is 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 S P2

$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 was similar as what's in Pre-11gr2, it had PREFERRED instances and optionally A vailable 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

11gR2 Database Services for " policy" " administrator" Managed Databases (document ID 1481647.1)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.