Tag

#dba

88 posts17 followers

Explore Hashnode

Alternatives

OCI DMS vs Manual Data Pump Migration: A Time and Risk Comparison

OCI Database Migration vs manual Data Pump: real timings, setup overhead, and the online SCN-handoff risk that decides which one to use.

12 min readlevelupcareers.hashnode.dev

chetan yadavAug 7

Near-Zero Downtime Migration: The Dual-Write Pattern Explained

How the dual-write migration pattern really works: transactional outbox, idempotent version-guarded upserts, reconciliation, and shadow reads, with SQL examples.

16 min readlevelupcareers.hashnode.dev

Rob MoayedzadehAug 6

Cloning a Pluggable Database (PDB) Across CDBs via Database Link

Master Oracle 19c PDB cloning across CDBs via database link. Follow this complete DBA guide with SQL examples, requirements, tips, and best practices.

5 min readblog.dbadispatch.tech

Rob MoayedzadehAug 6

Migrating Oracle LOBs from BasicFile to SecureFiles: A Field Guide

earn how to migrate Oracle LOBs from BasicFile to SecureFiles with step-by-step instructions, SQL examples, best practices, and performance tips.

7 min readblog.dbadispatch.tech

Database InsightsJul 31

Automating the Mundane: 5 Database Tasks Every Growing IT Team Should Stop Doing Manually

Discover five database tasks IT teams should automate to reduce risk, save time, and help DBAs focus on higher-value work.

7 min readdatabaseinsights.hashnode.dev

chetan yadavJul 30

Heterogeneous Migration Pitfalls: Data Type and Collation Traps

Real data type and collation conversion errors in heterogeneous database migration, from Oracle DATE truncation to collation duplicate-key failures, with fixes.

17 min readlevelupcareers.hashnode.dev

chetan yadavJul 27

Homogeneous Migration in Oracle 19c to 23ai: Full Walkthrough

A production-tested Oracle 19c to 23ai migration walkthrough: AutoUpgrade, guaranteed restore points, and optimizer plan stability

18 min readlevelupcareers.hashnode.dev

Sagar ThosarJun 14

To the People Nobody Notices Until Something Breaks

A heartfelt tribute to DBAs, support engineers, sysadmins, and network teams whose work often goes unnoticed until something breaks.

3 min readunscriptedthoughts.hashnode.dev

Sagar ThosarJun 5

Oracle 26ai — Setting Up Data Guard Per Pluggable Database (DGPDB) From Scratch

Pluggable database level dataguard setup with switchover of only one pdb at a time. Redo flows bidirectionally between two CDB databases.

13 min readsagarthosar.hashnode.dev

Soumyajeet KhuntiaMay 23

SQL Server Index Rebuild vs Reorganize — What Every DBA Should Know

Learn the difference between Index Rebuild and Reorganize in SQL Server, understand index fragmentation, page count, performance impact, and best practices used by DBAs in production environments.

3 min readsqldbcraft.hashnode.dev

Search Hashnode