Christian Gohmann

Christian_Gohmann 300x300

Christian Gohmann

Data Engineering Associate Manager

Trivadis - Part of Accenture

Biography

Christian Gohmann is currently working as Principal Consultant and Instructor at Trivadis - Part of Accenture in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration - with a specialization in high availability solutions, like Data Guard, Oracle RAC. Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in the German-speaking areas. Besides his consultancy activities, he is the main developer and the responsible person for db*BACKUP - a product distributed by Trivadis, which is responsible for the intelligent backup and recovery of an Oracle database. In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de and spends as much time as possible with his two dogs Susi and Taran, and for his hobbies climbing/bouldering, hiking, and watching movies.

Papers

xTTS - Lesson(s) learned

Event: Connect 2022
Stream: Architecture, Cloud Database & Technology

Transportable Tablespaces (TTS) exist since Oracle 8i and are a method to exchange data between databases in an efficient way. With every new release, the capabilities were enhanced, for example, Cross-platform TTS in Oracle 10g or Restore Foreign Tablespace/Datafile in Oracle 12c. In the last few months, I was involved in a customer project where the main goal was to upgrade/migrate existing Oracle 11gR2 databases to 19c (including the switch to the CDB architecture). For a lot of databases, the TTS approach was used. This presentation summarizes the experiences gathered with the TTS procedure including all its ups and downs. After an introduction to TTS itself, different methods of copying the data files are presented - for example, DBMS_FILE_TRANSFER or Foreign Tablespace/Datafile Restore with RMAN. The next part of the presentation covers pitfalls and challenges with the actual data migration. New features and enhancements introduced with 19c and 21c are also part of the presentation.