High Availability for Standard Edition Two It’s a nasty discussion whenver it comes to Desaster Recovery or High Availability with Standard Edition Two. Even though RAC is available there is no real Desaster Recovery as Oracle does not allow to use Data Guard. So the only real alternative today is dbvisit Standby. … and than Oracle released Multitenant Database!
Oracle 12.2 Standby Database for Standard Edition Two Blogbeitrag lesen »
Reading the “new features” topic “Case insensitive database” for Oracle 12.2 it sounds as if you are back in the last century where data was stored case insensitive. But guess we are all on one page: that’s not what we want to have. In reality this feature is not to store data indepentent but to search and sort data independent of upper or lower case or accents. That’s what “collation” stands for.
Oracle 12.2 Collation Blogbeitrag lesen »
With Version 12.2.02 the release policy for Oracle database will change drastically. During his keynote at DOAG 2017 Datenbank Andy Mendelsohn (Executive Vice President for Database Server Technologies at Oracle) said, that there will be no Version 12.2.0.2 but instead Oracle will release a new database version every year and the version number will be the year. Now we got the announcement: The next database release will be 18 (due to the “Release Schedule of Current Database Releases (Doc ID 742060.1)”
New Oracle Release Policy Blogbeitrag lesen »
About problems with Oracle 12c Multitenant Database Back in the days everything was easier, wasn’t it? Thus far you connect to your database and in doubt you send a query to v$instance or v$database to check you’re actually connected to the right place. But since 12c the world is no more that clear. Meanwhile we’ve got the Multitenant Option and by connecting to a Pluggable Database, maybe you won’t get the desired result. But for what reason it is such a problem?
Help, where am I? CDB or PDB … and which DB anyway? Blogbeitrag lesen »
Flashback Pluggable Database Oracle 12.2 will be general available within the next few weeks including several new fetaures for Flashback Pluggable Database. But it will take some more month before customers will adopt 12.2 for their production database and we need some more experience with the PDB Undo management. Because thats the requirement for Flashback Pluggable Database. But you can use this feature alread with 12.1.0.2 if your environment relies on Data Guard.This configuration might be an interesting alternative because it ends up with two individual PDBs – the original and the flashback version.
Flashback PDB with Version 12.1.0.2 Blogbeitrag lesen »
The Challenge There are some anomalies when using Multitenant Database with Data Guard. In the following example I will describe how to clone a pluggable database and synchronize Data Guard. The base is Oracle 12 Release 1 (12.1.0.2) and Data Guard without Real Time Query (Active Data Guard).
PDB Cloning with Data Guard Blogbeitrag lesen »
