Oracle

Dry Run with ZDM Physical Online with no Downtime for the source

I have been sharing my experience migrating On-Premises database to ExaCC using ZDM Physical Online, see my previous blog : https://www.dbi-services.com/blog/zdm-physical-online-migration-a-success-story/ In this blog I will share how you can make a Dry Run migration on your own without(…)

Integrating MongoDB Documents in Oracle Database: A Modern Approach to Hybrid Data Management

In today’s data-driven world, organizations often leverage a variety of databases to meet their diverse data storage and processing needs. MongoDB and Oracle Database are two prominent names in the database landscape, each excelling in different areas. MongoDB is renowned(…)

Oracle 21c: Attention Log – Useful or Superflous?

Attention.log is a feature, which was introduced in Oracle Database 21c, designed to capture high-level summaries of significant database events and activities. It differs from the alert.log in following points: High-Level Summaries: The attention.log focuses on summarizing critical and significant(…)

Exploring Vector Search in Oracle 23c AI

Exploring Vector Search in Oracle 23c AI(…)

Cleanup Audit Trail – the Full Picture

Oracle Database 23ai introduces several enhancements to unified auditing, focused on flexibility, and effectiveness. Some of the new key features are: Desupport of Traditional Auditing: Traditional auditing is desupported in Oracle 23ai, which means all auditing must now be done(…)

Oracle 23ai New Backup & Recovery Features

In this article I will give a short overview of some Backup & Recovery features in the new Oracle 23ai database. Meanwhile there are more than 300 new features in Oracle 23ai most of them reflecting artificial intelligence. I will(…)

Is DPR compatible with 12.1 databases running on your ODA?

Introduction Since patch version 19.21 (current one is 19.23), ODA (Oracle Database Appliance) X7, X8 and X9 will require the use of Data Preserving Reprovisioning (DPR) to get the patch. Unlike traditional patching, DPR erases the system disks but keeps(…)

Simulate (Transparent Tablespace Encryption) TDE on Oracle Standard Edition

by Alexandre Nestor Introduction The Oracle database Standard Edition do not have the Transparent Tablespace Encryption (TDE) feature which is a part of ASO (Advanced Security), and ASO is availabale only on Entreprise Edition version. But encryption can still be(…)

ODA X10-L storage configuration is different from what you may expect

Introduction Oracle Database Appliance X10 lineup is available since September 2023. Compared to X9-2 lineup, biggest changes are the AMD Epyc processors replacing Intel Xeons, and new license model regarding Standard Edition 2, clarified by Oracle several weeks ago.

ODA patching: ASR manager stuck to old version

Introduction Patching an Oracle Database Appliance is mainly applying 3 patches: the system patch, including OS and Grid Infrastructure updates, the storage patch for data disks and disk controllers, and the DB patch for DB homes and databases. ASR manager(…)