Wednesday Feb 11, 2015

Cross-Site Load Balancing - Prerequisites and Steps to Be Performed

Summary of the Prerequisites and Steps to Be Performed

Let’s consider the following configuration:

Site A: Primary is replicated by Active Data Guard to Site B: Secondary

Site B: Primary is replicated by Active Data Guard to Site A: Secondary

Let's assume that we have a pdb (MY_PDB) which runs on Site A: Primary. If, for example the workload is too high on Site A: Primary and a specific SLA can not be fulfilled, we can perform the following steps in order to move MY_PDB to Site B: Primary where the SLA can be met:

1. Stop MY_PDB on Site A: Primary and Site B: Secondary(Log files will continue to apply in MOUNT DB Mode)

2. Unplug MY_PDB from Site A: Primary

3. Copy XML manifest to the other site – Site B: Primary

4. Setup aliases on Site B: Primary and Site A: Secondary

5. Ensure media recovery (MRP) is running on the Site A: Secondary

6. Plugin MY_PDB on Site B: Primary

7. Check MY_PDB was replicated on Site A: Secondary

8. Open MY_PDB on Site B: Primary

9. Open MY_PDB (Read Only) on Site A: Secondary (if Active DG is running)

10. Drop MY_PDB on Site A: Primary (keep Datafiles)

These steps show that load balancing across sites is possible using a combination of Oracle Multitenant and Oracle Data Guard. When coupled with the flexibility offered by Oracle Real Application Clusters for local site management, it is an excellent example of the level agility and flexibility that enable a full-featured Database as a Service deployment.

Friday Sep 05, 2014

New whitepaper: Database as a Service Reaches New Heights of Efficiency

An IDC research vice president, senior Oracle product managers and a solution provider's technology director explain how Database as a Service Reaches New Heights of Efficiency by leveraging the latest technologies in Oracle Database 12c. 

Monday Dec 30, 2013

New Year's Resolution: learn more about Oracle Database 12c

 Interested in learning more about Oracle Database 12c's Multitenant option?  Here's a great opportunity to help kick off the new year:

Independent Oracle Users Group (IOUG) Oracle EM Techcast: DBA Best Practices for Performance Tuning in a Pluggable World

Thursday, 9 January 2014, 10 am PT

In Oracle Database 12c, a container database (CDB) can host up to 252 pluggable databases (PDBs).  This presentation look at the performance aspects of this deployment option:

• Best practices for DBAs
• Tuning and configuration tips
• New features

Featured Speaker: Julian Dontcheff(*), Head of Database Management & Exadata Lead for EALA (Europe, Middle East, Africa and Latin America), Accenture
*Oracle Certified Master and an Oracle ACE Director

Sunday Dec 08, 2013

Why DBaaS will be one of 2014's technology headliners

As you settle in to some holiday reading and prepare for 2014, a recent blog and several blogs it connects to will be of interest.  Check out this OracleVoice blog on  "Why Database As A Service (DBaaS) Will Be The Breakaway Technology of 2014".

From the entry's introduction:

"Database as a Service (DBaaS) is arguably the next big thing in IT. Indeed, the market analysis firm 451 Research projects an astounding 86% cumulative annual growth rate, with annual revenues from DBaaS providers rising from $150 million in 2012 to $1.8 billion by 2016."

 The  article explores the benefits of DBaaS and some of the key enabling technologies, such as Oracle Multitenant, which promises to be a game-changer as Oracle Database 12c adoption rises.

Tuesday Jul 02, 2013

Database Consolidation onto Private Clouds - updated for Oracle Database 12c

One of our team's most popular white papers has been expanded and updated to discuss Oracle Database 12c.  Now available on our OTN page, the new version of Database Consolidation onto Private Clouds covers best practices for consolidation with pluggable databases that the new mulitenant architecture provides, and expanded information on the database and schema consolidation options.  These are the consolidation models the paper evaluates:  

server  database  schema
pluggable databases 

Key considerations for consolidating workloads which the paper explores:

  • Choosing a consolidation model
  • How PDBs solve the IT complexity problem
  • Isolation in consolidated environments
  • Cloud pool design
  • Complementary workloads
  • Enterprise Manager 12c for consolidation planning and operations

Many more white papers have been updated or are new for Oracle Database 12c. We'll continue to highlight those which tie directory to your journey to enterprise cloud.

Tuesday Jun 25, 2013

Delivering Oracle DBaaS: Journey to Enterprise Cloud with Oracle Database 12c

The release of Oracle Database 12 is accompanied by extensive supporting collateral that details the new features and options of this major release.  But with so much to read and investigate, where to start?  If you don't have the time to pore through everything, then you may wish organize your reading in terms of the use case you're most interested in.  If your interest is Database as a Service in private database clouds then may I suggest that you start here:

Accelerate the Journey to Enterprise Cloud with Oracle Database 12c

This paper describes the phases of the journey to enterprise cloud, and enumerates the new features and options in Oracle Database 12c that support each phase.  Oracle Multitenant figures prominently, but it's not the only cloud-enabling topic: Oracle Database Quality of Service Management, Application Continuity, Automatic Data Optimization, Global Data Services and Active Data Guard Far Sync all deliver key benefits for delivering database as a service. 

Further reading and research is suggested by the references included in the paper.

Happy clouding!


The Database Cloud Architecture Team at Oracle develops and documents best practices for designing and delivering database consolidation and database-as-a-service projects for on-premises database clouds.


« July 2016