Oracle database High Availability – Exadata and Oracle 12c

Going through different approaches in building Oracle database systems in best High Availability (HA) practices in my previous articles we went through following important topics:
understanding High Availability (HA) and SLA requirements; reviewing database Availability Levels based on industry standards; building High Availably (HA) database systems based on Oracle ASM, Clusterware and Cold Failover cluster; Oracle Data Guard, Standby and RAC; Extended RAC and MAA. Basically we finished everything but I wanted to give two more extras, which is Oracle Exadata and Oracle 12c High Availability features.

Oracle Exadata Database Machine

The integration of Oracle Maximum Availability Architecture (MAA) best practices with Oracle Exadata Database Machine (Exadata MAA) provides the most comprehensive Oracle High Availability (HA) solution available for the Oracle database. Exadata MAA is very matured and pre-optimized, pre-configured, integrated system of software, servers, storage and MAA configuration best practices that comes ready to implement the highest database High Availability.

Exadata MAA architecture shown in figure below is designed to tolerate unplanned outages of all types, providing both High Availability (HA) and data protection. Exadata MAA also minimizes planned downtime by performing maintenance in a rolling fashion.

Oracle Exadata MAA architecture

Oracle Exadata Maximum Availability Architecture (MAA) architecture

With Oracle Exadata X3 machine version 3 that was announced just before Oracle Open World 2012, Oracle extended the Exadata resources, features and the Support model that all improved the overall system High Availability (HA). The new Oracle Exadata X4 is going to be released in 2014.

See below some high-lights of Oracle Exadata X3
Read more »

Oracle 12c Pluggable Database (PDB) – SQL code examples

Oracle database 12c is still not there and last time I predicted it will be released in March. Let’s see if Oracle can fix all the release issues and provide the nice and clean new major database release 12c that will greatly help enterprises in their consolidation strategies and enable them building Private Database Clouds.

With this I’ll continue my series of articles on Oracle 12c Pluggable Database (PDB) feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:

Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience
Oracle 12c Pluggable Database – Plug Unplug and Clone
Oracle 12c Pluggable Database (PDB) – FAQ

This time I focus on a few interesting SQL code examples. I’ll show how to create lots of empty PDBs programmatically from scratch and from the Gold images, how to open all Pluggable Databases (PDBs) automatically after CDB startup as well as to drop all PDBs. Once again I’d like to mention that the below code should work on Oracle database 12.1 Beta2. So let’s move on. Read more »

Oracle 12c Pluggable Database (PDB) – FAQ

Let’s continue my series of articles on Oracle 12c Pluggable Database feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience
Oracle 12c Pluggable Database – Plug Unplug and Clone

Oracle 12c Pluggable Database Point-In-Time recovery

Oracle 12c Pluggable Database Point-In-Time recovery

There are several questions on Oracle 12c Pluggable Database feature came up on my presentation at the German Oracle User Group (DOAG) regional meeting and from other users. Some of them I’ll clarify in this article. Read more »

Oracle 12c Pluggable Database – Plug Unplug and Clone

My presentation of Oracle 12c Pluggable Database feature at DOAG

My presentation of Oracle 12c Pluggable Database feature at DOAG

Last week I gave a presentation called “12c Pluggable Database Feature Insights”at the German Oracle User Group (DOAG) regional meeting in Nuremberg. Not only the presentation itself but also a later discussion was very interesting and valuable. I encourage my nearby German colleagues joining DOAG and visiting regular Regional DOAG meetings in Nuremberg.

Let’s continue my series of articles on Oracle 12c Pluggable Database feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience

This time I’ll show how to plug a Pluggable Database (PDB) into another Container Database (CDB), how to clone PDBs and how to adopt non-CDB as a PDB into a pre-existing CDB. To start with, I will use a Pluggable Database MY_PDB which I unplugged in my previous article and will plug it into another Oracle 12c Container database called cdb2. Read more »

Oracle 12c Pluggable Database (PDB) feature hands-on experience

I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights

As I wrote previously Pluggable Databases is a brand-new capability in Oracle Database 12c that will be released soon. In this article I continue giving more practical insights of an Oracle 12c Pluggable Database future including SQL statement examples. The SQL code I mention below is applicable to Oracle database 12.1 Beta2.

Let’s repeat the step of connecting to a Container database (CDB) called cdb1 from my last article.

sqlplus sys/pass@localhost:1521/cdb1 as sysdba
Read more »

« Previous PageNext Page »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email