Oracle 12c

Create a primary database using the backup of a standby database on 12cR2

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in(…)

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

How to migrate Grid Infrastructure from release 12c to release 18c

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic(…)

RMAN PITR recover table Oracle 12c

At one client’s site, I had to restore a table someone had partially deleted one week before. Before Oracle 12c, we had to duplicate the target database to another server, and then to export and import data to the(…)

Using Oratcptest

By Mouhamadou Diaw Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show(…)

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

Database Vault : Rules, Rule Sets and Command Rules

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

One command database upgrade on ODA

The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some(…)

Multitenant, PDB, ‘save state’, services and standby databases

By Franck Pachot . Creating - and using - your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each(…)

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just(…)