Infrastructure at your Service

Petre Radut

New features and known issues with RMAN tool on Oracle database 12.1.0.2

By | Database Administration & Monitoring, Oracle | 2 Comments
 

 Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The RMAN tool continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. Below, I will mention couple of new features for the RMAN duplicate command, but also how to avoid issues that can happen on the creation of the temporary files. FEATURES: <INFO>Using BACKUPSET clause : In previous releases, active duplicates were performed using implicit image…

Read More
Franck Pachot

Installing ZFS on OEL7 UEK4 for Docker storage

By | Database Administration & Monitoring | No Comments
 

 The Oracle Database is fully supported on Docker according that Linux is Red Hat Enterprise Linux 7 or Oracle Enterprise Linux 7 with Unbreakable Enterprise 4. This is documented in MOS Note 2216342.1. Given the size of the Oracle database in GigaBytes even empty, the way it is installed at build with many file updates, and the per-block modifications of the datafiles, a block level copy-on-write filesystem is a must and deduplication and compression are…

Read More
Soufiane Benmalek

How to install Docker Enterprise Edition on CentOS 7 ?

By | Database Administration & Monitoring, DevOps | No Comments
 

 In this blog we are going to see how to install Docker EE trial edition on CentOS 7 hosts. As you may know or not, Docker has two editions: Docker Community Edition  (CE) and Docker Enterprise Edition (EE). To make it simple, let’s say that Docker EE is designed for production environment. More infos here.   This will be our architecture: 1 manager node hostname: docker-ee-manager1 1 worker node + Docker Trust Registry (DTR) node…

Read More
Petre Radut

Control File issues on duplicating with non patched Oracle version.

By | Database Administration & Monitoring, Oracle | No Comments
 

 Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or on a remote server with a different file structure or on the local server with a different file structure. For some old and  non patched Oracle versions such as that earlier than 11.2.0.4 , the duplicate (from…

Read More
Clemens Bleile

Restarting a failed transportable tablespace metadata import

By | Database Administration & Monitoring | 2 Comments
 

 I’m currently working in a project to migrate a Datawarehouse-database from Solaris to Linux Intel (Endian-change). We do use the cross platform incremental backups method as described in My Oracle Support Note 1389592.1 for that. I.e. incremental backups are applied to database files and during the migration the recovered datafiles are attached to the target database via the transportable tablespace method. When testing the transportable tablespace metadata import I got an error for a table:…

Read More
Franck Pachot
CaptureSUM

Google Cloud Spanner – no decimal numeric data types

By | Cloud, Database Administration & Monitoring | No Comments
 

 Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages of NoSQL database (like Bigtable) but adding transactions, relational tables, SQL, structured data,… as in the relational databases we love for decades. The commercial pitch includes all the NoSQL buzzwords, with the addition of the legacy properties of SQL…

Read More
Franck Pachot

Drilling down the pgSentinel Active Session History

By | Database Administration & Monitoring, Postgres | No Comments
 

 In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity, down to the details where we can do some tuning. The idea is to always focus on the components which are relevant to our tuning goal: Filter/Group by the relevant dimension to focus on what you want to tune (a program, session, query, time…

Read More
Mouhamadou Diaw

Database Vault : Rules, Rule Sets and Command Rules

By | Database Administration & Monitoring | No Comments
 

 In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database definition language (DDL), and data manipulation language (DML) statements. We can do this with Command Rules. In this blog I am demonstrating how we can use a Command Rule to prevent SYS from creating a new pluggable database in a multitenant environment. Before…

Read More
Daniel Westermann

PGDay Amsterdam – follow up 1 – Adding columns with a default value and changing the default value right after

By | Database Administration & Monitoring | No Comments
 

 As always, this time during my talk about the PostgreSQL 11 new features in Amsterdam, there have been question I could not immediately answer. The first one was this: Suppose we add a column with a default value in PostgreSQL 11, what happens when we change that default afterwards? Does the table get rewritten? Do we have more than on distinct default value for that column? Here we go …

Read More
Daniel Westermann

What a great event – PGDay Amsterdam

By | Database Administration & Monitoring | No Comments
 

 PostgreSQL conferences are always cool and this time it was in Amsterdam: PGDay Amsterdam. Beside that meeting all the great people was fun again the location was really outstanding: The TOBACCO Theater: Some impressions: Here you can see Devrim preparing the opening of the event with the introduction session: … and then it happened: We finally started: Jan kicked of the sessions with his talk about the reasons he finally arrived in the PostgreSQL community…

Read More