Monday, July 17, 2023

High Level Oracle Database Migration Plan – Datapump

 Pre-Migration Phase: No Downtime

  • Review the Source database configuration
  • Build target environment in AWS Cloud
  • Prepare target database 



 Migration Phase (cutover) : Downtime

  • Source database backup 
  • Transfer the backup to target
  • Import backup in target database
  • Validate the migrated database


 


Post-Migration Phase : Downtime

  • Handover database to application team
  • Application team start validation
  • Decide Go-Live /No Go-Live
  • Target database golden backup
  • Release database and application


 


Note : Normally good for small database 

No comments:

Post a Comment

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle Database Deep Health Check Checklist

Oracle Database Deep Health Check Checklist Recommended assessment levels Level Purpose Typical scope L1 Operational health Availability, sp...