Oracle Team

18c, Cloud First and Cloud Only features: think differently

By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the(…)

A free persistent Google Cloud service with Oracle XE

By Franck Pachot . In a previous post I've listed several free online services which run an Oracle XE so that you can test your SQL easily. You may want use Oracle XE further, with full(…)

PDB upgrade from 12c to 18c

By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug/plug. Faster upgrade should be(…)

ODA Lite: What is this ‘odacli’ repository?

By Franck Pachot . When ODA Lite was introduced, with ODA X6-2 S/M/L, and now with ODA x7-2 S/M, a new 'odacli' was there to manage it. It will probably replace the oakcli for ODA HA as well in the(…)

How to prevent RMAN archivelog backup from log switch

When RMAN backups archivelogs, it does a logswitch before backing up all archivelogs. In some cases this log switching should be suppressed. This can be done with expression “until time ‘sysdate'”, which actually filters nothing. For example: backup archivelog until(…)

Migrate Oracle Database(s) and ASM diskgroups from VMWARE to Oracle VM

This is a step by step demonstration on how to migrate any ASM disk groups from a cluster to another. May be use, with or without virtualization and may be used with storage layer snapshot for fast environment provisioning. Step(…)

18c Read Only Oracle Home

By Franck Pachot . This is the big new feature of Oracle 18c about database software installation. Something that was needed for decades for the ease of software deployment. Piet de Visser raised this to(…)

Duplex RMAN backups between disk and tape

Below a workaround is shown how to “duplex” archivelog backups between disk and tape: Backup on disk (normal way): backup device type disk archivelog all;   Immediately  backup on tape: backup device type sbt archivelog until time 'sysdate' not backed(…)

Backup and Restore PostgreSQL with PgBackRest II

By Mouhamadou Diaw In a precedent blog I shown a basic utilization of PgBackRest which is a tool to backup and restore PostgreSQL databases. In this blog I am going to talk some useful(…)

(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=YES)(LOAD_BALANCE=NO)

By Franck Pachot . Do you have complex connection strings with DESCRIPTION_LIST, DESCRIPTION, ADDRESS_LIST, ADDRESS and a nice combination of FAILOVER and LOAD_BALANCE? You probably checked the documentation, telling you that FAILOVER=YES is the default at all levels, but LOAD_BALANCE=YES(…)