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

Interview Question 18 : What are oinstall and dba groups? Why we assign these groups to oracle user ?

  What are oinstall and dba groups in Oracle? Short answer oinstall → Controls software ownership and installation dba → Controls databa...