Appendix: Oracle migration questionnaire - AWS Prescriptive Guidance
General informationInfrastructureDatabase backupsDatabase securityDatabase high availability and disaster recovery

Appendix: Oracle migration questionnaire

Use the questionnaire in this section as a starting point to gather information for the assessment and planning phases of your migration project. You can download this questionnaire in Microsoft Excel format and use it to record your information.

General information

  1. What is the name of your Oracle database?

  2. What is the version of your Oracle database?

  3. What is the edition of the database: Standard or Enterprise?

  4. What is the size of your database?

  5. What is the database character set?

  6. What is the time zone of the database?

  7. What are the average and maximum I/O transactions per second (TPS)?

  8. What is the IOPS (on average and maximum) for this database for read/write operations?

  9. What is the redo log generation per hour (on average and maximum) per day?

  10. How many schemas do you plan to migrate?

  11. What is the size of each schema?

  12. How many big tables (over 100 GB) do you have per schema?

  13. Can you archive the tables that don't need to migrate?

  14. What is the size of system global areas (SGAs) and program global areas (PGAs) or Automatic Memory Management (AMM) usage, in megabytes?

  15. How many tables have LOBs? What is the maximum size of the LOBs?

  16. Do all your tables with LOBs have primary keys?

  17. Do you have database links that point to other databases?

  18. What are the SLA requirements for your database?

  19. What are the RTO and RPO requirements for your database?

  20. How much database downtime can you allow for migration purposes?

  21. Do you have any compliance, regulatory, or auditing requirements?

Infrastructure

  1. What is the hostname of the database?

  2. What is the operating system used for this database?

  3. How many CPU cores does the server have?

  4. What is the memory size on the server?

  5. Are you using local storage?

  6. Do you use network-attached storage (NAS) or storage area network (SAN) storage types?

  7. Do you have a RAC database? If yes, how many nodes does it have?

  8. Do you use partitioning features?

  9. Do you use Oracle Spatial?

  10. Do you have a multi-tenant database?

Database backups

  1. How do you back up your database?  How often?

  2. What is your retention period for archive logs and backups?

  3. Do you use backups to clone your database?

  4. Where do you store your backup?

Database security

  1. Do you use Oracle Database Vault?

  2. Do you use data masking?

  3. Do you use Secure Sockets Layer (SSL)?

  4. Do you use Oracle Advanced Security features such as Transparent Data Encryption (TDE)?

  5. Do you use Oracle Advanced Compression?

Database high availability and disaster recovery

  1. What are your high availability requirements?

  2. Do you use Oracle Data Guard?  Where are your primary and standby database regions?

  3. Do you use Oracle Active Data Guard?

  4. Do you use a Domain Name System (DNS) alias for database connectivity?

  5. Do you use replication tools such as Oracle GoldenGate, Quest SharePlex, or Oracle Streams?