Blog.

20266 posts
31
Aug

Oracle to AWS Migration Lab

18 minEN

A complete walkthrough of migrating an on-premises Oracle database to AWS using DMS and GoldenGate โ€” architecture, Terraform, scripts, cutover steps, and lessons learned from doing this at Kainga Ora.

oracleawsdmsgoldengatemigrationrdsterraform
/blog/oracle-aws-migration-lab
31
Aug

GoldenGate Replication Lab: Oracle to Oracle and Oracle to PostgreSQL

14 minEN

How Oracle GoldenGate replication actually works โ€” the EXTRACT, PUMP, and REPLICAT pipeline explained with real configuration, monitoring commands, and the things that break in production.

oraclegoldengatereplicationpostgresqldbaaws
/blog/goldengate-replication-lab
30
Aug

AI vs ML vs Deep Learning: A Cloud Engineer's Plain-English Guide

8 minEN

Everyone uses AI, ML, and deep learning interchangeably. They are not the same thing. Here is how they actually relate, explained using infrastructure analogies that will stick.

aimlawscertificationai-practitioner
/blog/ai-ml-deep-learning-cloud-engineer-guide
26
Jun

Oracle Data Manipulation Internals: Undo, Redo, and Archiving

12 minEN

A deep dive into how Oracle handles undo and redo data โ€” what they are, how MVCC uses them together, how LGWR and archiving work, and what it all means practically when running Oracle on RDS.

oracledbaundoredoarchivelogperformancerds
/blog/Oracle-Data-manipulation-Undo-Redo-arch-01
24
Jun

Oracle Memory Architecture: SGA, PGA, and Automatic Memory Management

9 minEN

A practical deep-dive into Oracle's memory architecture โ€” how SGA and PGA work, the evolution from manual tuning to AMM, how to use the memory advisors, and how to diagnose the dreaded ORA-04031 error.

oracledbamemoryperformancetuning
/blog/Oracle-memory-management-RDS
23
Jun

Managing Archive Logs in RDS for Oracle

6 minEN

A practical guide to managing Oracle archive logs on AWS RDS โ€” from listing files with rdsadmin to fixing DMS CDC failures caused by logs aging out before replication catches up.

awsoraclerdsdmsdatabase
/blog/managing-archivelogs-RDS-for-oracle