--- title: "#dba articles | Hashnode" description: "Explore 88 articles tagged #dba on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/dba" --- Tag # #dba 88 posts · 17 followers [chetan yadav](https://hashnode.com/@levelupcareer) · [Aug 27](https://hashnode.com/posts/oci-dms-vs-manual-data-pump-migration-a-time-and-risk-comparison/6a8fb61675e06d2f12480146) ### [OCI DMS vs Manual Data Pump Migration: A Time and Risk Comparison](https://levelupcareers.hashnode.dev/oci-dms-vs-manual-data-pump-migration-a-time-and-risk-comparison?utm_source=hashnode&utm_medium=feed) 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 read · [levelupcareers.hashnode.dev](https://levelupcareers.hashnode.dev/oci-dms-vs-manual-data-pump-migration-a-time-and-risk-comparison?utm_source=hashnode&utm_medium=feed) [chetan yadav](https://hashnode.com/@levelupcareer) · [Aug 7](https://hashnode.com/posts/near-zero-downtime-migration-the-dual-write-pattern-explained/6a75bbb66fea9fd0cbcb74b0) ### [Near-Zero Downtime Migration: The Dual-Write Pattern Explained](https://levelupcareers.hashnode.dev/near-zero-downtime-migration-the-dual-write-pattern-explained?utm_source=hashnode&utm_medium=feed) How the dual-write migration pattern really works: transactional outbox, idempotent version-guarded upserts, reconciliation, and shadow reads, with SQL examples. 16 min read · [levelupcareers.hashnode.dev](https://levelupcareers.hashnode.dev/near-zero-downtime-migration-the-dual-write-pattern-explained?utm_source=hashnode&utm_medium=feed) [Rob Moayedzadeh](https://hashnode.com/@dba-dispatch) · [Aug 6](https://hashnode.com/posts/cloning-a-pluggable-database-pdb-across-cdbs-via-database-link/6a74c723ba54eec462b5aded) ### [Cloning a Pluggable Database (PDB) Across CDBs via Database Link](https://blog.dbadispatch.tech/cloning-a-pluggable-database-pdb-across-cdbs-via-database-link?utm_source=hashnode&utm_medium=feed) 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 read · [blog.dbadispatch.tech](https://blog.dbadispatch.tech/cloning-a-pluggable-database-pdb-across-cdbs-via-database-link?utm_source=hashnode&utm_medium=feed) [Rob Moayedzadeh](https://hashnode.com/@dba-dispatch) · [Aug 6](https://hashnode.com/posts/migrating-oracle-lobs-from-basicfile-to-securefiles-a-field-guide/6a74ce13dd2c0ae4a1b454b9) ### [Migrating Oracle LOBs from BasicFile to SecureFiles: A Field Guide](https://blog.dbadispatch.tech/migrating-oracle-lobs-from-basicfile-to-securefiles-a-field-guide?utm_source=hashnode&utm_medium=feed) earn how to migrate Oracle LOBs from BasicFile to SecureFiles with step-by-step instructions, SQL examples, best practices, and performance tips. 7 min read · [blog.dbadispatch.tech](https://blog.dbadispatch.tech/migrating-oracle-lobs-from-basicfile-to-securefiles-a-field-guide?utm_source=hashnode&utm_medium=feed) [Database Insights](https://hashnode.com/@databaseinsights) · [Jul 31](https://hashnode.com/posts/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually/6a6ce4f71201e0039d710995) ### [Automating the Mundane: 5 Database Tasks Every Growing IT Team Should Stop Doing Manually](https://databaseinsights.hashnode.dev/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually?utm_source=hashnode&utm_medium=feed) Discover five database tasks IT teams should automate to reduce risk, save time, and help DBAs focus on higher-value work. 7 min read · [databaseinsights.hashnode.dev](https://databaseinsights.hashnode.dev/automating-the-mundane-5-database-tasks-every-growing-it-team-should-stop-doing-manually?utm_source=hashnode&utm_medium=feed) [chetan yadav](https://hashnode.com/@levelupcareer) · [Jul 30](https://hashnode.com/posts/heterogeneous-migration-pitfalls-data-type-and-collation-traps/6a6b5c09b5eb7455c9a1241e) ### [Heterogeneous Migration Pitfalls: Data Type and Collation Traps](https://levelupcareers.hashnode.dev/heterogeneous-migration-pitfalls-data-type-and-collation-traps?utm_source=hashnode&utm_medium=feed) Real data type and collation conversion errors in heterogeneous database migration, from Oracle DATE truncation to collation duplicate-key failures, with fixes. 17 min read · [levelupcareers.hashnode.dev](https://levelupcareers.hashnode.dev/heterogeneous-migration-pitfalls-data-type-and-collation-traps?utm_source=hashnode&utm_medium=feed) [chetan yadav](https://hashnode.com/@levelupcareer) · [Jul 27](https://hashnode.com/posts/homogeneous-migration-in-oracle-19c-to-23ai-full-walkthrough/6a671e3bb0507811e1671a84) ### [Homogeneous Migration in Oracle 19c to 23ai: Full Walkthrough](https://levelupcareers.hashnode.dev/homogeneous-migration-in-oracle-19c-to-23ai-full-walkthrough?utm_source=hashnode&utm_medium=feed) A production-tested Oracle 19c to 23ai migration walkthrough: AutoUpgrade, guaranteed restore points, and optimizer plan stability 18 min read · [levelupcareers.hashnode.dev](https://levelupcareers.hashnode.dev/homogeneous-migration-in-oracle-19c-to-23ai-full-walkthrough?utm_source=hashnode&utm_medium=feed) [Sagar Thosar](https://hashnode.com/@sagarthosar) · [Jun 14](https://hashnode.com/posts/to-the-people-nobody-notices-until-something-breaks/6a2edcd4c457eb4da57b02ec) ### [To the People Nobody Notices Until Something Breaks](https://unscriptedthoughts.hashnode.dev/to-the-people-nobody-notices-until-something-breaks?utm_source=hashnode&utm_medium=feed) A heartfelt tribute to DBAs, support engineers, sysadmins, and network teams whose work often goes unnoticed until something breaks. 3 min read · [unscriptedthoughts.hashnode.dev](https://unscriptedthoughts.hashnode.dev/to-the-people-nobody-notices-until-something-breaks?utm_source=hashnode&utm_medium=feed) [Sagar Thosar](https://hashnode.com/@sagarthosar) · [Jun 5](https://hashnode.com/posts/oracle-26ai-setting-up-data-guard-per-pluggable-database-dgpdb-from-scratch/6a2339d7f685a602c6cd2bfb) ### [Oracle 26ai — Setting Up Data Guard Per Pluggable Database (DGPDB) From Scratch](https://sagarthosar.hashnode.dev/oracle-26ai-setting-up-data-guard-per-pluggable-database-dgpdb-from-scratch?utm_source=hashnode&utm_medium=feed) Pluggable database level dataguard setup with switchover of only one pdb at a time. Redo flows bidirectionally between two CDB databases. 13 min read · [sagarthosar.hashnode.dev](https://sagarthosar.hashnode.dev/oracle-26ai-setting-up-data-guard-per-pluggable-database-dgpdb-from-scratch?utm_source=hashnode&utm_medium=feed) [Soumyajeet Khuntia](https://hashnode.com/@sqldbcraft) · [May 23](https://hashnode.com/posts/sql-server-index-rebuild-vs-reorganize-what-every-dba-should-know/6a11f76f1a3cf7bffc491509) ### [SQL Server Index Rebuild vs Reorganize — What Every DBA Should Know](https://sqldbcraft.hashnode.dev/sql-server-index-rebuild-vs-reorganize-what-every-dba-should-know?utm_source=hashnode&utm_medium=feed) 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 read · [sqldbcraft.hashnode.dev](https://sqldbcraft.hashnode.dev/sql-server-index-rebuild-vs-reorganize-what-every-dba-should-know?utm_source=hashnode&utm_medium=feed)