database

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)

RMAN catalog upgrade, why, when and how

One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).

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

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

Control File issues on duplicating with non patched Oracle version.

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

Dbvisit Standby Archive Log Daemon

Dbvisit Standby version 8 comes with a nice feature, a daemon, which gives the benefit to send and apply the archive log automatically in the background. Bypassing the system scheduling, the daemon will facilitate customer RPO (Recovery Point Objective) and(…)

ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4

To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was(…)

RMAN debugging during catalog import

In this post I would like to share how I have been able to troubleshoot and solve a catalog import issue using RMAN debug function. As we can see, the error message provided by RMAN is not very helpful. oracle@vmtestoradg1:/home/oracle/(…)

ORACLE 11g to 12c RMAN catalog migration

This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:/home/oracle/ [RCAT11G] sqh SQL*Plus:(…)

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By Franck Pachot . The development teams often see the database as a 'persistence layer' only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be(…)