Oracle

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

Restarting a failed transportable tablespace metadata import

I’m currently working in a project to migrate a Datawarehouse-database from Solaris to Linux Intel (Endian-change). We do use the cross platform incremental backups method as described in My Oracle Support Note 1389592.1 for that. I.e. incremental backups are(…)

Oracle Database Vault: Realm in a Pluggable Database

By Mouhamadou Diaw Database Vault can also be used in a multitenant environment. In a multitenant environment we must register Oracle Database Vault in the root first, then after in the PDBs. In this blog we will see how(…)

Data Guard: always set db_create_file_dest on the standby

By Franck Pachot . The file name convert parameters are not dynamic and require a restart of the instance. An enhancement request was filled in 2011. I mentioned recently on Twitter that it can be annoying with Active Data Guard(…)

My tmux scripts to script demos

By Franck Pachot . When I did my first demo using tmux, I have written the following blog post to explain it: https://www.dbi-services.com/blog/using-tmux-for-semi-interactive-demos/. Since then I've done all my demos with this technique. My scripts and(…)

18c: Order by in WITH clause is not preserved

By Franck Pachot . For a previous post I’ve run on 18c a script of mine to get the V$MYSTAT delta values between two queries. This script (new version available on(…)

ODA fiber interface link detection issue

Configuring fiber interfaces during an ODA installation can sometime been challenging. The configuration can depend on the kind of gigabit interface converter (GBIC) and switch been used. In this blog, I would like to show a real case faced during(…)

18c: some optimization about redo size

By Franck Pachot . Some years ago, at the time of 12.1 release, I published in the SOUG newsletter some tests to show the amount of redo generated by different operations on a 10000 rows(…)

Event Sourcing: CQN is not a replacement for CDC

By Franck Pachot . We are in an era where software architects want to stream the transactions out of the database and distribute them, as events, to multiple microservices. Don't ask why, but that's the trend: store inconsistent eventually consistent(…)