Infrastructure at your Service

Tag

Recovery Archives - Blog dbi services

Franck Pachot

What is a database backup (back to the basics)

By | Database Administration & Monitoring, Postgres | 8 Comments

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy recovery interface, but don’t trust it before you try it and… I’ve written this after…

Read More
Franck Pachot

Oracle recovery concepts

By | Oracle | No Comments

I’ve published a while ago a twitter thead on some Oracle recovery concepts. For those who are not following twitter, I’m putting the whole thread here:   🔴⏬ Here I start a thread about some Oracle Database concepts. We will see how far it goes - all questions/comments welcome. 🔴⏬ A database (or DBMS - database management system) stores (for short and long term) and manipulates (from many concurrent users/devices) your #data. 🔴⏬ #data is logically structured (tablespaces, schemas, tables, columns, datatypes,…

Read More
Mouhamadou Diaw

RMAN in a Multitenant Environment

By | Database Administration & Monitoring, Oracle | One Comment

The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an oracle 19c database with 2 pluggable databases. Below the configuration we are using. SQL> show pdbs CON_ID CON_NAME…

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 1 – Restore points

By | Database Administration & Monitoring | 2 Comments

When discussing with customers about PostgreSQL we often hear that they can do things in one database that they can not do in PostgreSQL. Most of the times this is not true and you actually can do it in PostgreSQL. Maybe not in exactly the same way but this is not surprising as PostgreSQL does implement features not in exactly the same way other vendors do. To start this series we’ll talk about restore points….

Read More
Daniel Westermann

The dbi services PostgreSQL reference architecture (2) – The community approach

By | Database Administration & Monitoring | No Comments

In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I’ll look at the same questions but using pure community tools. If you do not need vendor support and do trust the community for providing help and fixes this is another way to go. And usually you can trust the community around PostgreSQL very well. The architecture itself is pretty much the…

Read More
Franck Pachot

Is CDB stable after one patchset and two PSU?

By | Database management, Oracle | 7 Comments

By Franck Pachot . There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable. Well. Let’s talk about the major issue I’ve encountered. Multitenant is there for consolidation. What is the major requirement of consolidation? It’s availability. If you put all your databases into one server and managed by one instance, then you don’t expect a failure. When 12c was out (and even earlier as we are…

Read More
Franck Pachot

What’s the consequence of NOLOGGING loads?

By | Database management, Oracle | No Comments

By Franck Pachot . When you load data in direct-path and have the NOLOGGING attribute set, you minimize redo generation, but you take the risk, in case of media recovery, to loose the data in the blocks that you’ve loaded. So you probably run a backup as soon as the load is done. But what happens if you have a crash, with media failure, before the backup is finish? I encountered recently the situation but…

Read More
Franck Pachot

PDB media failure may cause the whole CDB to crash

By | Database management, Oracle | 3 Comments

By Franck Pachot . Do you remember last year, when 12c arrived with multitenant, David Hueber warned us about the fact that a single PDB can, under certain conditions, generate a complete system downtime? We are beta testers and opened a SR for that. Now one year later the first patchset is out and obviously I checked if the issue was fixed. It’s a patchset afterall, which is expected to fix issues before than bringing…

Read More
Franck Pachot

The consequences of NOLOGGING in Oracle

By | Database management, Oracle | No Comments

By Franck Pachot . While answering to a question on Oracle forum about NOLOGGING consequences, I provided a test case that deserves a bit more explanation. Nologging operations are good to generate minimal redo on bulk operations (direct-path inserts, index creation/rebuild). But in case we have to restore a backup that was made before the nologging operation, we loose data. And even if we can accept that, we have some manual operations to do. Here…

Read More
Open source Team

Pgbarman : gestion de sauvegarde et récupération PostgreSQL

By | Hardware & Storage | No Comments

Fin 2012, j’ai prĂ©senté « pgbarman », une solution de sauvegarde et rĂ©cupĂ©ration pour PostgreSQL et dĂ©crit son installation. Pgbarman fournit un ensemble de commandes vous permettant la mise en Ɠuvre de sauvegardes vers un serveur dĂ©diĂ©. Le principal intĂ©rĂȘt est Ă  mon sens la gestion d’un catalogue de vos sauvegardes et la gĂ©nĂ©ration de commandes destinĂ©es Ă  une reconstruction locale ou sur un serveur tiers. Je vais maintenant parler de la gestion des sauvegardes et dĂ©crire la…

Read More