My Oracle Support Banner

EM 13c MIGRATE_DB : Enterprise Manager Migrate Db FAQ (Doc ID 2692273.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.8.0 and later
Information in this document applies to any platform.

Purpose

 This Document contains Frequently Asked Questions for migrating databases using migrate_db.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1. Which Management Pack is needed for migrate databases using migrate_db verb in Enterprise Manager.
 2. What is the Minimum version of Enterprise Manager needed for migrate_db verb.
 3. Can I do migrate_db from Enterprise Manager Console.
 4. Is migrate_db available only for database plugin targets(database, GI, Oracle restart).
 5. Is it possible to use migrate_db to do both minor(Ex: 12.2.0.4 to 12.2.0.4/12.2.0.4.200714) and major upgrades(Example: 12c to 19c).
 6. Should Enterprise Manager be connected to My Oracle Support(online mode) for using migrate_db.
 7. What is the minimum privileges required for Enterprise manager user to do fleet maintenance.
 8. How does OEM accomplish the task of migrate_db.
 9. Is migrate_db used for migration of database version 10G.
 10. Is databases running on windows is supported.
 11. Can we migrate databases between crossplatforms.
 12. What happens when source and destination are in different endian format.
 13. Do we need to have staging location for implementing migrate_db.
 14. Can we perform migration with non sys db user.
 15. Can we perform migration with non sysman em user.
 16. What happens when source and destination are in different characterset.
 17. Can we use migrate_db having source and destination running with different timezone at DB level.
 18. What happens to source database after migration.
 19. Do we support migration_db where source and destination are tde enabled.
 20. Do we support migration_db where source and destination where data vault enabled.
 21. Can we migrate same source databases as a different pluggable in target container.
 22. Can we use migrate_db where source and destniation databases having same tablepace name.
 23. Does migrate_db migrates the source database target history into newly created pluggable database in container.
 24. Can we use migrate_db for migrating only specific tablespaces.
 25. Does migrate_db supports database running on different storage.
 26. Can we use migrate_db on dataguard enabled databases.
 27. Can we restore the source database on failures in migrate_db.
 28. Can we use migrate_db operations with non sys user having default tablespace.
 29. Does the migrate_db migrates objects in SYSTEM/SYSAUX TBS.
 
30. Is is mandatory to pass pdbAdminPassword parameter value in input file.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.