Infrastructure at your Service

Tag

database Archives - Blog dbi services

Jérôme Dubar

Focus on 19c NOW!

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases. Both of them having patchsets (the last number) and regular patchset updates (the date optionally displayed at the end) to remove bugs and to increase security. Jumping from release 1 to release 2 required a…

Read More
Marc Wagner

Adding a dbvisit standby database on the ODA in a non-OMF environment

By | Database Administration & Monitoring | No Comments

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database, myDB, is running on server named srv02 and using a non-OMF configuration. On the ODA side we are working with OMF configuration. The dbvisit version available at that time was version 8. You need to…

Read More
Clemens Bleile

Oracle 19c

By | Database Administration & Monitoring | No Comments

Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https://www.oracle.com/technetwork/database/enterprise-edition/downloads or https://edelivery.oracle.com (search e.g. for “Database Enterprise Edition”) Docker-Images: https://github.com/oracle/docker-images/tree/master/OracleDatabase Oracle provides different offerings for 19c: On-premises: – Oracle Database Standard Edition 2 (SE2) –…

Read More
Marc Wagner

Migrating Oracle database from windows to ODA

By | Database Administration & Monitoring | 2 Comments

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago). Both windows databases and target ODA databases are running PSU 11.2.0.4.190115. But this would definitively also be working for oracle 12c and oracle 18c databases. The databases are licensed with Standard Edition, so migrating through…

Read More
Marc Wagner

Moving oracle database to new home on ODA

By | Database Administration & Monitoring | No Comments

Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem here, knowing we do not have any Derby database. Through this blog I would like to give you some guidance and work around to move database to a new home (of same major release). In…

Read More
Oracle Team

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle | No Comments

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More
Oracle Team

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

By | Database Administration & Monitoring, Database management, Oracle | One Comment

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 nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More
Oracle Team

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

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

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 repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2” Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…

Read More