BE SHARING

Recovery

An example of ORA-01152: file … was not restored from a sufficiently old backup

30.04.2021 by Oracle Team

By Franck Pachot . Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file ... was not restored from a sufficiently old backup ORA-01110: data file ... This error is one of(…)

Cloud

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

11.12.2020 by Open source Team

By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures(…)

Cloud

Recovery in the ☁ with Oracle Autonomous Database

18.11.2020 by Oracle Team

By Franck Pachot . I’ll start this series with the Oracle Autonomous database but my goal is to cover the Point In Time recovery for many managed databases in the major cloud providers. Because I’ve seen lot of confusion(…)

Database Administration & Monitoring

What is a database backup (back to the basics)

22.10.2020 by Open source Team

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(…)

Oracle

Oracle recovery concepts

29.03.2020 by Oracle Team

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(…)

Database Administration & Monitoring

RMAN in a Multitenant Environment

13.09.2019 by Oracle Team

By Mouhamadou Diaw 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)(…)

Database Administration & Monitoring

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

24.11.2016 by Daniel Westermann

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.

Database Administration & Monitoring

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

09.02.2016 by Daniel Westermann

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(…)

Database management

Is CDB stable after one patchset and two PSU?

16.02.2015 by Oracle Team

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(…)

Database management

What’s the consequence of NOLOGGING loads?

04.09.2014 by Oracle Team

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(…)